public List <ASSETKKF_MODEL.Data.Mssql.Mcis.lnItemGroup> Search(ASSETKKF_MODEL.Request.Mcis.lnItemGroupReq d)
{
DynamicParameters param = new DynamicParameters();
/*
* param.Add("@Seq_ItemgroupIsNull", d.Seq_Itemgroup.ListNull());
* param.Add("@Item_GroupIsNull", d.Item_Group.ListNull());
* param.Add("@DescriptionIsNull", d.Description.ListNull());
* param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
*/
string cmd = "";
/*
* string cmd = "SELECT * FROM mcis.dbo.lnItemGroup " +
* $"WHERE (@Seq_ItemgroupIsNull IS NULL OR Seq_Itemgroup IN ('{ d.Seq_Itemgroup.Join("','") }')) " +
* $"AND (@Item_GroupIsNull IS NULL OR Item_Group IN ('{ d.Item_Group.Join("','") }')) " +
* $"AND (@DescriptionIsNull IS NULL OR Description IN ('{ d.Description.Join("','") }')) " +
* $"AND (Seq_Itemgroup LIKE @txtSearch OR Seq_Itemgroup LIKE @txtSearch) " +
* //"ORDER BY ;";
*/
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.lnItemGroup>(cmd, param).ToList();
return(res);
}
public int Save(ASSETKKF_MODEL.Data.Mssql.Mcis.lnItemGroup d, string userID = "", SqlTransaction transac = null)
{
var req = new ASSETKKF_MODEL.Request.Mcis.lnItemGroupReq();
req.Seq_Itemgroup = d.seq_itemgroup;
if (GetDataSeq(req).Count > 0)
{
return(Update(d, userID, transac));
}
return(Insert(d, userID, transac));
}
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.lnItemGroup> GetData(ASSETKKF_MODEL.Request.Mcis.lnItemGroupReq d)
{
DynamicParameters param = new DynamicParameters();
param.Add("@Seq_Itemgroup", d.Seq_Itemgroup);
param.Add("@Item_Group", d.Item_Group);
param.Add("@Description", d.Description);
//param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
string cmd = "SELECT * FROM mcis.dbo.lnItemGroup " +
$"WHERE Seq_Itemgroup = @Seq_Itemgroup ";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.lnItemGroup>(cmd, param).ToList();
return(res);
}
