public override int Query(FormM form, DFDictionary entity, DataGridVM vm, int start, int limit, ref string message)
{
if (entity["action"] == "querylist")
{
vm.rows = WF_M_PUBLICCODELoader.Query(entity["CodeType"]).Select(a =>
new WFItem()
{
text = a.CodeName, value = string.Format("{0}{1}", a.CodeValue, a.CodeLongValue)
}).ToList();
return(DFPub.EXECUTE_SUCCESS);
}
/*基本查询语句*/
var sql = @"select a.* from WF_M_PUBLICCODE a where 1=1";
/*查询条件*/
if (!string.IsNullOrWhiteSpace(entity["CodeType"]))
{
sql += " and a.CodeType like @CodeType";
}
sql += " order by a.CodeType";
using (var db = Pub.DB)
{
var parameters = new
{
CodeType = string.Format("%{0}%", entity["CodeType"])
};
vm.results = db.Query <int>(DFPub.GetCountSql(sql), parameters).FirstOrDefault();
var list = db.Query <WF_M_PUBLICCODE>(DFPub.GetPageSql(sql, start + 1, start + limit), parameters).ToList();
vm.rows = list;
return(DFPub.EXECUTE_SUCCESS);
}
}
public override void SetAccess(FormM form, DFDictionary entity)
{
var ycs = WF_M_PUBLICCODELoader.Query("YCName");
var palletDict = new DFDictionary();
foreach (var item in ycs)
{
palletDict.Add(item.CodeName, item.CodeValue);
}
this.Model.Add("YCName_DataSource", Base64StringHelper.ConvertToBase64String(JsonSerializeHelper.SerializeObject(palletDict)));
}
