public List <Imcc1> Get_Imcc1_List(imcc request)
{
List <Imcc1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
if (!string.IsNullOrEmpty(request.CustomerCode))
{
Result = db.SelectParam <Imcc1>(
i => i.CustomerCode != null && i.CustomerCode != "" && i.CustomerCode == request.CustomerCode
).OrderByDescending(i => i.CycleCountDateTime).ToList <Imcc1>();
}
else if (request.TrxNo > 0)
{
Result = db.SelectParam <Imcc1>(
i => i.TrxNo > 0 && i.TrxNo == request.TrxNo
).OrderByDescending(i => i.CycleCountDateTime).ToList <Imcc1>();
}
}
}
catch { throw; }
return(Result);
}
public List <Imcc2> Get_Imcc2_List(imcc request)
{
List <Imcc2> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
string strSql = " select TrxNo ,LineItemNo ,WarehouseCode ,StoreNo ,ProductTrxNo ,'' as Description,'' as PackingQtyTempValue ,'' as WholeQtyTempValue ,'' as LooseQtyTempValue, " +
" isnull((select DimensionFlag from impr1 where impr1.TrxNo =imcc2.ProductTrxNo),'') as DimensionFlag, " +
" isnull((select PackingUomCode from impr1 where impr1.TrxNo =imcc2.ProductTrxNo),'') as PackingUomCode, " +
" isnull((select LooseUomCode from impr1 where impr1.TrxNo =imcc2.ProductTrxNo),'') as LooseUomCode, " +
" isnull((select WholeUomCode from impr1 where impr1.TrxNo =imcc2.ProductTrxNo),'') as WholeUomCode, " +
" isnull((select ProductCode from impr1 where impr1.TrxNo=imcc2.ProductTrxNo),'') as ProductCode ," +
" isnull((select CustomerCode from imcc1 where imcc1.TrxNo=imcc2.TrxNo),'') as CustomerCode ," +
" RowNum = ROW_NUMBER() OVER (ORDER BY Imcc2.lineItemNo ASC) " +
" from Imcc2 " +
" Where Imcc2.TrxNo='" + request.TrxNo + "' order by LineItemNo";
Result = db.Select <Imcc2>(strSql);
}
}
catch { throw; }
return(Result);
}
public int ConfirmAll_Imcc2(imcc request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
if (request.UpdateAllString != null && request.UpdateAllString != "")
{
JArray ja = (JArray)JsonConvert.DeserializeObject(request.UpdateAllString);
if (ja != null)
{
for (int i = 0; i < ja.Count(); i++)
{
int TrxNo;
int LineItemNo;
int ProductTrxNo = 0;
int PackingQty;
int WholeQty;
int LooseQty;
if (ja[i]["TrxNo"] != null || ja[i]["TrxNo"].ToString() != "")
{
if (ja[i]["LineItemNo"] != null || ja[i]["LineItemNo"].ToString() != "")
{
TrxNo = int.Parse(ja[i]["TrxNo"].ToString());
LineItemNo = int.Parse(ja[i]["LineItemNo"].ToString());
if (ja[i]["ProductTrxNo"] != null || ja[i]["ProductTrxNo"].ToString() != "")
{
ProductTrxNo = int.Parse(ja[i]["ProductTrxNo"].ToString());
}
if (ja[i]["PackingQtyTempValue"].ToString() == "")
{
PackingQty = 0;
}
else
{
PackingQty = int.Parse(ja[i]["PackingQtyTempValue"].ToString());
}
if (ja[i]["WholeQtyTempValue"].ToString() == "")
{
WholeQty = 0;
}
else
{
WholeQty = int.Parse(ja[i]["WholeQtyTempValue"].ToString());
}
if (ja[i]["LooseQtyTempValue"].ToString() == "")
{
LooseQty = 0;
}
else
{
LooseQty = int.Parse(ja[i]["LooseQtyTempValue"].ToString());
}
db.ExecuteSql("insert into impm1 (CustomerCode, WarehouseCode, StoreNo,ProductCode ,Description, DimensionFlag, PackingQty, WholeQty,LooseQty,ProductTrxNo,UpdateBy) values (" +
Modfunction.SQLSafeValue(ja[i]["CustomerCode"].ToString()) + "," + Modfunction.SQLSafeValue(ja[i]["WarehouseCode"].ToString()) + "," + Modfunction.SQLSafeValue(ja[i]["StoreNo"].ToString()) + "," + Modfunction.SQLSafeValue(ja[i]["ProductCode"].ToString()) + "," + Modfunction.SQLSafeValue(ja[i]["Description"].ToString()) + "," +
Modfunction.SQLSafeValue(ja[i]["DimensionFlag"].ToString()) + "," + PackingQty + "," + WholeQty + "," + LooseQty + "," + ProductTrxNo + "," + Modfunction.SQLSafeValue(ja[i]["UserId"].ToString()) + ")");
string str;
string strTableName = "imcc2";
str = " PackingQty = " + PackingQty + ",WholeQty = " + WholeQty + ",LooseQty = " + LooseQty + ", UpdateBy=" + Modfunction.SQLSafeValue(ja[i]["UserId"].ToString()) + "";
db.Update(strTableName,
str,
" TrxNo=" + TrxNo + " and LineItemNo=" + LineItemNo + "");
}
}
}
Result = 1;
}
}
}
}
catch { throw; }
return(Result);
}
