Tips

• store new dll
• render combo item with page size
• refresh gird
• check ALL
• Connection String for visual 2022

¶store new dll

.Store(
                Util.BuildStoreRemote(this, "LoadMPS", typeof(MF00006_pgLoadMPS_Result)).PageSize(20)
                .Parameters(ps =>
                {
                    ps.Add(new StoreParameter("Company_Site_Id", "_Company_Site_Id", ParameterMode.Raw));
                })
            )

public ActionResult LoadMPSView(StoreRequestParameters parameters, int Company_Site_Id)
        {
            var result = _db.MF00006_pgLoadMPS(_client_Id, Company_Site_Id).ToList();
            return result.ApplyExtFilter(parameters);
        }

.AutoFilterColumns(false) -- sẽ fillter full các trang

¶render combo item with page size

@(
    HQ.StoreRenderer("grdPAT_MF_MPS_Line", "Item_Id", "MF00024/grdLine_ItemsRender")
)


#region Renderer
public ActionResult grdLine_ItemsRender(string[] listid)
{
    List<MF00024_Line_Items> list = new List<MF00024_Line_Items>();
    if (listid != null)
    {
        List<int> realID = new List<int>();
        foreach (string ids in listid)
        {
            if (int.TryParse(ids, out int newid))
            {
                realID.Add(newid);
            }
        }

        string idw = string.Join(",", realID);
        string q = $"SELECT Item_Id, Item_Code, Item_Name, Uom_Code FROM dbo.Inv_Items as ii WITH(NOLOCK) INNER JOIN dbo.Inv_Unit_Of_Measures AS iu WITH(NOLOCK) ON ii.Onhand_Uom_Id = iu.Uom_Id where ii.Item_Id in ({idw})";
        list = _db.QuickAccess().ExecuteQueryList<MF00024_Line_Items>(q, null).Result;
    }

    return this.Store(list);
}

class MF00024_Line_Items
{
    public int Item_Id { get; set; }
    public string Item_Code { get; set; }
    public string Item_Name { get; set; }
    public string Uom_Code { get; set; }
}
#endregion

const renderItem_Id = function (value) {
    let obj = App.cboItem_Id.store.findItemRenderer(p => p.Item_Id == value);
    if (obj == null)
        obj = App.stoRenderer_grdPAT_MF_MPS_Line_Item_Id.findItemRenderer(p => p.Item_Id == value);
    if (obj)
        return obj.Item_Code;
    else return value;
}

¶refresh gird

WaitingValidate(ValidateCboLoading, () => {
            App.grdQC_ProductionConditionsLine.view.refresh()
        });

¶check ALL

convert(bit,0) [Check]

     

, X.CheckColumn().Text(Util.GetLang("Check")).DataIndex("Check").Width(60).Editable(true).Align(Alignment.Center)

     .HeaderItems(X.Checkbox().ID("ckALL").Listeners(l =>{l.Change.Fn = "btnCheckAll_Click";}))

var btnCheckAll_Click = function () {

    var x = App.ckALL.value;

    for (var i = 0; i < App.stoLoadGridPN.allData.items.length; i++) {

        var obj = App.stoLoadGridPN.allData.items[i];

        obj.set("Check", x);

    }

};



for (j = 0; j < App.stoHoTroLayPN.getChangedData().Updated.length; j++) {

    var obj = App.stoHoTroLayPN.getChangedData().Updated[j];

    if (obj.Check == true) {

        insertRecordTCHoTroLayPN(obj);            

    }

}

¶Connection String for visual 2022

;encrypt=False;trustservercertificate=True