private string GetTaskTransSql(UserModel user, T_StockInfo model, T_OutStockTaskDetailsInfo detailModel)
{
string strSql = string.Empty;
strSql = "insert into t_tasktrans( Serialno, Materialno, Materialdesc, Supcuscode, " +
"Supcusname, Qty, Tasktype, Vouchertype, Creater, Createtime,TaskdetailsId, Unit, Unitname,partno,materialnoid,erpvoucherno,voucherno," +
"Strongholdcode,Strongholdname,Companycode,Supprdbatch,Edate,taskno,status,batchno,barcode,houseprop,ean,Fromerpwarehouse,ISAMOUNT,ToWarehouseNo,ToWarehouseName,ToHouseNo,ToAreaNo,PalletNo)" +
" values ('" + model.SerialNo + "'," +
" '" + model.MaterialNo + "','" + model.MaterialDesc + "','" + detailModel.CustomerCode + "','" + detailModel.CustomerName + "','" + model.Qty + "','12'," +
" (select vouchertype from t_outstock where id = '" + detailModel.HeaderID + "') ,'" + user.UserName + "',getdate(),'" + model.TaskDetailesID + "', " +
"'" + detailModel.Unit + "','" + detailModel.UnitName + "','" + detailModel.PartNo + "','" + model.MaterialNoID + "','" + detailModel.ErpVoucherNo + "'," +
" '" + detailModel.VoucherNo + "','" + detailModel.StrongHoldCode + "','" + detailModel.StrongHoldName + "','" + detailModel.CompanyCode + "'," +
" '" + model.SupPrdBatch + "','" + model.StrEDate + "' ,'" + detailModel.TaskNo + "','" + model.Status + "','" + model.FromBatchNo + "','" + model.Barcode + "','" + model.HouseProp + "','" + model.EAN + "','" + detailModel.FromErpWarehouse + "','" + model.IsAmount + "'," +
" (select WAREHOUSENO from T_WAREHOUSE where id ='" + model.WareHouseID + "') ," +
" (select WAREHOUSENAME from T_WAREHOUSE where id ='" + model.WareHouseID + "')," +
" (select HOUSENO from T_HOUSE where id='" + model.HouseID + "')," +
" (select AREANO from T_AREA where id ='" + model.AreaID + "'),'" + model.PalletNo + "' ) ";
return(strSql);
}
public bool GetT_OutTaskDetailsListByPage(ref List <T_OutStockTaskDetailsInfo> modelList, UserInfo user, T_OutStockTaskDetailsInfo t_taskdetails, ref DividPage page, ref string strError)
{
T_OutTaskDetails_Func tfunc = new T_OutTaskDetails_Func();
return(tfunc.GetModelListByPage(ref modelList, user, t_taskdetails, ref page, ref strError));
}
public bool GetT_OutTaskDetailsByID(ref T_OutStockTaskDetailsInfo model, ref string strError)
{
T_OutTaskDetails_Func tfunc = new T_OutTaskDetails_Func();
return(tfunc.GetModelByID(ref model, ref strError));
}
public bool DeleteT_OutTaskDetailsByModel(UserInfo user, T_OutStockTaskDetailsInfo model, ref string strError)
{
T_OutTaskDetails_Func tfunc = new T_OutTaskDetails_Func();
return(tfunc.DeleteModelByModel(user, model, ref strError));
}
public bool SaveT_OutTaskDetails(UserInfo user, ref T_OutStockTaskDetailsInfo t_taskdetails, ref string strError)
{
T_OutTaskDetails_Func tfunc = new T_OutTaskDetails_Func();
return(tfunc.SaveModelBySqlToDB(user, ref t_taskdetails, ref strError));
}
public bool UpdateT_OutTaskDetailsStatus(UserInfo user, ref T_OutStockTaskDetailsInfo t_taskdetails, int NewStatus, ref string strError)
{
T_OutTaskDetails_Func tfunc = new T_OutTaskDetails_Func();
return(tfunc.UpdateModelStatus(user, ref t_taskdetails, NewStatus, ref strError));
}