/// <summary> /// 请购单变更数量 更新Manage表数据 /// </summary> /// <param name="ItemID"></param> /// <param name="FileName"></param> public void UpdatePORequest_NumBG(int ItemID, string FileName, int TaskID) { //获取待更新的Log 数据明细 JD_PORequest_Log logmodel = Detail(ItemID); JD_PORequestManageDal dal = new JD_PORequestManageDal(); JD_PORequestManage model = dal.Detail(logmodel.SNumber, logmodel.ItemID); string ErrorMsg = string.Empty; try { if (model != null) { //更新Manage表数量 model.FQty = logmodel.FQtyNew; dal.Update(model); } } catch (Exception ex) { ErrorMsg = ex.Message; common.WriteLogs(FileName, ItemID.ToString(), ex.Message); } finally { //更新日志表状态 logmodel.IsUpdate = "1"; logmodel.UpdateTime = DateTime.Now; Update(logmodel); if (!string.IsNullOrEmpty(ErrorMsg)) { common.AddLogQueue(TaskID, "JD_PORequest_Log", ItemID, "SQL", ErrorMsg, false); } else { common.AddLogQueue(TaskID, "JD_PORequest_Log", ItemID, "SQL", "操作成功!", true); } } }
/// <summary> /// 更新JD_PORequest_Log对象 /// 编写人:ywk /// 编写日期:2018/7/31 星期二 /// </summary> public void Update(JD_PORequest_Log model) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("UPDATE JD_PORequest_Log SET TaskID = @m_TaskID,IsUpdate = @m_IsUpdate,CreateTime = @m_CreateTime,UpdateTime = @m_UpdateTime,Operater = @m_Operater,CheckID = @m_CheckID,BusinessType = @m_BusinessType,BusinessTypeCode = @m_BusinessTypeCode,PlanType = @m_PlanType,PlanTypeCode = @m_PlanTypeCode,ordernum = @m_ordernum,Remarks = @m_Remarks,FBillNo = @m_FBillNo,FInterID = @m_FInterID,FEntryID = @m_FEntryID,FNumber = @m_FNumber,FName = @m_FName,FModel = @m_FModel,Funit = @m_Funit,FUnitID = @m_FUnitID,FNeedQty = @m_FNeedQty,FQty = @m_FQty,DetailRemarks = @m_DetailRemarks,FFixLeadTime = @m_FFixLeadTime,FAdmit = @m_FAdmit,FFetchTime = @m_FFetchTime,FQtyMin = @m_FQtyMin,FBatchAppendQty = @m_FBatchAppendQty,Flimitprice = @m_Flimitprice,FOpenPo = @m_FOpenPo,Fpoqty = @m_Fpoqty,Fpoqty1 = @m_Fpoqty1,Fpoqty2 = @m_Fpoqty2,Fstockqty = @m_Fstockqty,PackageInfo = @m_PackageInfo,FSecInv = @m_FSecInv,FSourceInterId = @m_FSourceInterId,FSourceBillNo = @m_FSourceBillNo,FSourceEntryID = @m_FSourceEntryID,Fsupname = @m_Fsupname,FsupNum = @m_FsupNum,FsupplyID = @m_FsupplyID,CostPrice = @m_CostPrice,TypeNumber = @m_TypeNumber,ProductName = @m_ProductName,FAuxPrice = @m_FAuxPrice,Fcess = @m_Fcess,FAmount = @m_FAmount,FTaxAmount = @m_FTaxAmount,SNumber = @m_SNumber,LogType = @m_LogType,FQtyNew = @m_FQtyNew,REQType = @m_REQType WHERE ItemID = @m_ItemID", con); con.Open(); if (model.TaskID == null) { cmd.Parameters.Add(new SqlParameter("@m_TaskID", SqlDbType.Int, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_TaskID", SqlDbType.Int, 0)).Value = model.TaskID; } if (model.IsUpdate == null) { cmd.Parameters.Add(new SqlParameter("@m_IsUpdate", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_IsUpdate", SqlDbType.NVarChar, 50)).Value = model.IsUpdate; } if (model.CreateTime == new DateTime()) { cmd.Parameters.Add(new SqlParameter("@m_CreateTime", SqlDbType.DateTime, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_CreateTime", SqlDbType.DateTime, 0)).Value = model.CreateTime; } if (model.UpdateTime == new DateTime()) { cmd.Parameters.Add(new SqlParameter("@m_UpdateTime", SqlDbType.DateTime, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_UpdateTime", SqlDbType.DateTime, 0)).Value = model.UpdateTime; } if (model.Operater == null) { cmd.Parameters.Add(new SqlParameter("@m_Operater", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Operater", SqlDbType.NVarChar, 50)).Value = model.Operater; } if (model.CheckID == null) { cmd.Parameters.Add(new SqlParameter("@m_CheckID", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_CheckID", SqlDbType.NVarChar, 50)).Value = model.CheckID; } if (model.BusinessType == null) { cmd.Parameters.Add(new SqlParameter("@m_BusinessType", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_BusinessType", SqlDbType.NVarChar, 50)).Value = model.BusinessType; } if (model.BusinessTypeCode == null) { cmd.Parameters.Add(new SqlParameter("@m_BusinessTypeCode", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_BusinessTypeCode", SqlDbType.NVarChar, 50)).Value = model.BusinessTypeCode; } if (model.PlanType == null) { cmd.Parameters.Add(new SqlParameter("@m_PlanType", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_PlanType", SqlDbType.NVarChar, 50)).Value = model.PlanType; } if (model.PlanTypeCode == null) { cmd.Parameters.Add(new SqlParameter("@m_PlanTypeCode", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_PlanTypeCode", SqlDbType.NVarChar, 50)).Value = model.PlanTypeCode; } if (model.ordernum == null) { cmd.Parameters.Add(new SqlParameter("@m_ordernum", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_ordernum", SqlDbType.NVarChar, 50)).Value = model.ordernum; } if (model.Remarks == null) { cmd.Parameters.Add(new SqlParameter("@m_Remarks", SqlDbType.NVarChar, 500)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Remarks", SqlDbType.NVarChar, 500)).Value = model.Remarks; } if (model.FBillNo == null) { cmd.Parameters.Add(new SqlParameter("@m_FBillNo", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FBillNo", SqlDbType.NVarChar, 50)).Value = model.FBillNo; } if (model.FInterID == null) { cmd.Parameters.Add(new SqlParameter("@m_FInterID", SqlDbType.Int, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FInterID", SqlDbType.Int, 0)).Value = model.FInterID; } if (model.FEntryID == null) { cmd.Parameters.Add(new SqlParameter("@m_FEntryID", SqlDbType.Int, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FEntryID", SqlDbType.Int, 0)).Value = model.FEntryID; } if (model.FNumber == null) { cmd.Parameters.Add(new SqlParameter("@m_FNumber", SqlDbType.NVarChar, 100)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FNumber", SqlDbType.NVarChar, 100)).Value = model.FNumber; } if (model.FName == null) { cmd.Parameters.Add(new SqlParameter("@m_FName", SqlDbType.NVarChar, 100)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FName", SqlDbType.NVarChar, 100)).Value = model.FName; } if (model.FModel == null) { cmd.Parameters.Add(new SqlParameter("@m_FModel", SqlDbType.NVarChar, 500)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FModel", SqlDbType.NVarChar, 500)).Value = model.FModel; } if (model.Funit == null) { cmd.Parameters.Add(new SqlParameter("@m_Funit", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Funit", SqlDbType.NVarChar, 50)).Value = model.Funit; } if (model.FUnitID == null) { cmd.Parameters.Add(new SqlParameter("@m_FUnitID", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FUnitID", SqlDbType.NVarChar, 50)).Value = model.FUnitID; } if (model.FNeedQty == null) { cmd.Parameters.Add(new SqlParameter("@m_FNeedQty", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FNeedQty", SqlDbType.Decimal, 18)).Value = model.FNeedQty; } if (model.FQty == null) { cmd.Parameters.Add(new SqlParameter("@m_FQty", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FQty", SqlDbType.Decimal, 18)).Value = model.FQty; } if (model.DetailRemarks == null) { cmd.Parameters.Add(new SqlParameter("@m_DetailRemarks", SqlDbType.NVarChar, 500)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_DetailRemarks", SqlDbType.NVarChar, 500)).Value = model.DetailRemarks; } if (model.FFixLeadTime == null) { cmd.Parameters.Add(new SqlParameter("@m_FFixLeadTime", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FFixLeadTime", SqlDbType.NVarChar, 50)).Value = model.FFixLeadTime; } if (model.FAdmit == null) { cmd.Parameters.Add(new SqlParameter("@m_FAdmit", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FAdmit", SqlDbType.NVarChar, 50)).Value = model.FAdmit; } if (model.FFetchTime == new DateTime()) { cmd.Parameters.Add(new SqlParameter("@m_FFetchTime", SqlDbType.DateTime, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FFetchTime", SqlDbType.DateTime, 0)).Value = model.FFetchTime; } if (model.FQtyMin == null) { cmd.Parameters.Add(new SqlParameter("@m_FQtyMin", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FQtyMin", SqlDbType.Decimal, 18)).Value = model.FQtyMin; } if (model.FBatchAppendQty == null) { cmd.Parameters.Add(new SqlParameter("@m_FBatchAppendQty", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FBatchAppendQty", SqlDbType.Decimal, 18)).Value = model.FBatchAppendQty; } if (model.Flimitprice == null) { cmd.Parameters.Add(new SqlParameter("@m_Flimitprice", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Flimitprice", SqlDbType.NVarChar, 50)).Value = model.Flimitprice; } if (model.FOpenPo == null) { cmd.Parameters.Add(new SqlParameter("@m_FOpenPo", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FOpenPo", SqlDbType.Decimal, 18)).Value = model.FOpenPo; } if (model.Fpoqty == null) { cmd.Parameters.Add(new SqlParameter("@m_Fpoqty", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Fpoqty", SqlDbType.Decimal, 18)).Value = model.Fpoqty; } if (model.Fpoqty1 == null) { cmd.Parameters.Add(new SqlParameter("@m_Fpoqty1", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Fpoqty1", SqlDbType.Decimal, 18)).Value = model.Fpoqty1; } if (model.Fpoqty2 == null) { cmd.Parameters.Add(new SqlParameter("@m_Fpoqty2", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Fpoqty2", SqlDbType.Decimal, 18)).Value = model.Fpoqty2; } if (model.Fstockqty == null) { cmd.Parameters.Add(new SqlParameter("@m_Fstockqty", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Fstockqty", SqlDbType.Decimal, 18)).Value = model.Fstockqty; } if (model.PackageInfo == null) { cmd.Parameters.Add(new SqlParameter("@m_PackageInfo", SqlDbType.NVarChar, 500)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_PackageInfo", SqlDbType.NVarChar, 500)).Value = model.PackageInfo; } if (model.FSecInv == null) { cmd.Parameters.Add(new SqlParameter("@m_FSecInv", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FSecInv", SqlDbType.Decimal, 18)).Value = model.FSecInv; } if (model.FSourceInterId == null) { cmd.Parameters.Add(new SqlParameter("@m_FSourceInterId", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FSourceInterId", SqlDbType.NVarChar, 50)).Value = model.FSourceInterId; } if (model.FSourceBillNo == null) { cmd.Parameters.Add(new SqlParameter("@m_FSourceBillNo", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FSourceBillNo", SqlDbType.NVarChar, 50)).Value = model.FSourceBillNo; } if (model.FSourceEntryID == null) { cmd.Parameters.Add(new SqlParameter("@m_FSourceEntryID", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FSourceEntryID", SqlDbType.NVarChar, 50)).Value = model.FSourceEntryID; } if (model.Fsupname == null) { cmd.Parameters.Add(new SqlParameter("@m_Fsupname", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Fsupname", SqlDbType.NVarChar, 50)).Value = model.Fsupname; } if (model.FsupNum == null) { cmd.Parameters.Add(new SqlParameter("@m_FsupNum", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FsupNum", SqlDbType.NVarChar, 50)).Value = model.FsupNum; } if (model.FsupplyID == null) { cmd.Parameters.Add(new SqlParameter("@m_FsupplyID", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FsupplyID", SqlDbType.NVarChar, 50)).Value = model.FsupplyID; } if (model.CostPrice == null) { cmd.Parameters.Add(new SqlParameter("@m_CostPrice", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_CostPrice", SqlDbType.Decimal, 18)).Value = model.CostPrice; } if (model.TypeNumber == null) { cmd.Parameters.Add(new SqlParameter("@m_TypeNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_TypeNumber", SqlDbType.NVarChar, 50)).Value = model.TypeNumber; } if (model.ProductName == null) { cmd.Parameters.Add(new SqlParameter("@m_ProductName", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_ProductName", SqlDbType.NVarChar, 50)).Value = model.ProductName; } if (model.FAuxPrice == null) { cmd.Parameters.Add(new SqlParameter("@m_FAuxPrice", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FAuxPrice", SqlDbType.Decimal, 18)).Value = model.FAuxPrice; } if (model.Fcess == null) { cmd.Parameters.Add(new SqlParameter("@m_Fcess", SqlDbType.Int, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Fcess", SqlDbType.Int, 0)).Value = model.Fcess; } if (model.FAmount == null) { cmd.Parameters.Add(new SqlParameter("@m_FAmount", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FAmount", SqlDbType.Decimal, 18)).Value = model.FAmount; } if (model.FTaxAmount == null) { cmd.Parameters.Add(new SqlParameter("@m_FTaxAmount", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FTaxAmount", SqlDbType.Decimal, 18)).Value = model.FTaxAmount; } if (model.SNumber == null) { cmd.Parameters.Add(new SqlParameter("@m_SNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_SNumber", SqlDbType.NVarChar, 50)).Value = model.SNumber; } if (model.LogType == null) { cmd.Parameters.Add(new SqlParameter("@m_LogType", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_LogType", SqlDbType.NVarChar, 50)).Value = model.LogType; } if (model.FQtyNew == null) { cmd.Parameters.Add(new SqlParameter("@m_FQtyNew", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FQtyNew", SqlDbType.Decimal, 18)).Value = model.FQtyNew; } if (model.REQType == null) { cmd.Parameters.Add(new SqlParameter("@m_REQType", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_REQType", SqlDbType.NVarChar, 50)).Value = model.REQType; } cmd.Parameters.Add(new SqlParameter("@m_ItemID", SqlDbType.Int, 0)).Value = model.ItemID; try { cmd.ExecuteNonQuery(); } catch (Exception e) { throw new Exception(e.ToString()); } cmd.Dispose(); con.Close(); con.Dispose(); }
/// <summary> /// K3集成 请购单更新 /// </summary> /// <param name="ItemID"></param> /// <param name="FileName"></param> public void UpdatePORequest_Apply(int ItemID, string FileName, int TaskID) { JD_PORequest_Log model = Detail(ItemID); string Sql = string.Empty; string LogMsg = string.Empty; string FUserID = string.Empty; decimal Empty = Convert.ToDecimal("0"); if (model != null) { try { decimal FAuxQty = model.FQtyNew; #region 更新PORequestEntry 的FAuxQty //2018-11-12 新增功能 //如果请购单对应的请购数量为0 删除原单 if (FAuxQty == Empty) { Sql = string.Format("delete from PORequestEntry where FInterID='{0}' and FEntryID='{1}'", model.FInterID, model.FEntryID); DBUtil.ExecuteSql(Sql, K3connectionString); } else { string FCoefient = MeasureUnit(model.FUnitID); if (!string.IsNullOrEmpty(FCoefient)) { decimal Fient = Convert.ToDecimal(FCoefient); FAuxQty = Math.Round(model.FQtyNew / Fient, 10); } Sql = string.Format(@"update PORequestEntry set FQty='{0}',FAuxQty='{1}',FUse='{4}' where FInterID='{2}' and FEntryID='{3}'", model.FQtyNew.ToString("f10"), FAuxQty.ToString("f10"), model.FInterID, model.FEntryID, model.DetailRemarks); DBUtil.ExecuteSql(Sql, K3connectionString); } #endregion #region 更新表头 Sql = string.Format(@"select top 1 FUserID from t_Base_User where FName='{0}' ", model.CheckID); object obj = DBUtil.GetSingle(Sql, K3connectionString); if (obj == null) { throw new Exception("未能在系统中找到和K3匹配的FUserID"); } else { //备注更新去掉 //Sql = string.Format(@" update PORequest set FCheckerID=(select top 1 FUserID from t_Base_User where FName='{0}'), // FCheckTime='{1}',fstatus=1,FNote='{3}',FCheckDate='{1}' where FInterID='{2}' ", // model.CheckID, model.CreateTime.ToString("yyyy-MM-dd"), model.FInterID, model.Remarks); Sql = string.Format(@" update PORequest set FCheckerID=(select top 1 FUserID from t_Base_User where FName='{0}'), FCheckTime='{1}',fstatus=1,FCheckDate='{1}' where FInterID='{2}' ", model.CheckID, model.CreateTime.ToString("yyyy-MM-dd"), model.FInterID); DBUtil.ExecuteSql(Sql, K3connectionString); } #endregion } catch (Exception ex) { common.WriteLogs(FileName, ItemID.ToString(), ex.Message); LogMsg = ex.Message; } finally { //更新发送标志 model.IsUpdate = "1"; model.UpdateTime = DateTime.Now; Update(model); if (!string.IsNullOrEmpty(LogMsg)) { common.AddLogQueue(TaskID, "JD_PORequest_Log", ItemID, "SQL", LogMsg, false); } else { common.AddLogQueue(TaskID, "JD_PORequest_Log", ItemID, "SQL", "操作成功!", true); } } } else { common.WriteLogs(FileName, ItemID.ToString(), "对象为空!"); } }
public static string connectionString = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None).AppSettings.Settings["ConnectionString"].Value; //连接信息 /// <summary> /// 对象JD_PORequest_Log明细 /// 编写人:ywk /// 编写日期:2018/7/31 星期二 /// </summary> public JD_PORequest_Log Detail(int ItemID) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("SELECT * FROM JD_PORequest_Log WHERE ItemID = @m_ItemID", con); con.Open(); cmd.Parameters.Add(new SqlParameter("@m_ItemID", SqlDbType.Int, 0)).Value = ItemID; JD_PORequest_Log myDetail = new JD_PORequest_Log(); SqlDataReader myReader = cmd.ExecuteReader(); if (myReader.Read()) { if (!Convert.IsDBNull(myReader["ItemID"])) { myDetail.ItemID = Convert.ToInt32(myReader["ItemID"]); } if (!Convert.IsDBNull(myReader["TaskID"])) { myDetail.TaskID = Convert.ToInt32(myReader["TaskID"]); } if (!Convert.IsDBNull(myReader["IsUpdate"])) { myDetail.IsUpdate = Convert.ToString(myReader["IsUpdate"]); } if (!Convert.IsDBNull(myReader["CreateTime"])) { myDetail.CreateTime = Convert.ToDateTime(myReader["CreateTime"]); } if (!Convert.IsDBNull(myReader["UpdateTime"])) { myDetail.UpdateTime = Convert.ToDateTime(myReader["UpdateTime"]); } if (!Convert.IsDBNull(myReader["Operater"])) { myDetail.Operater = Convert.ToString(myReader["Operater"]); } if (!Convert.IsDBNull(myReader["CheckID"])) { myDetail.CheckID = Convert.ToString(myReader["CheckID"]); } if (!Convert.IsDBNull(myReader["BusinessType"])) { myDetail.BusinessType = Convert.ToString(myReader["BusinessType"]); } if (!Convert.IsDBNull(myReader["BusinessTypeCode"])) { myDetail.BusinessTypeCode = Convert.ToString(myReader["BusinessTypeCode"]); } if (!Convert.IsDBNull(myReader["PlanType"])) { myDetail.PlanType = Convert.ToString(myReader["PlanType"]); } if (!Convert.IsDBNull(myReader["PlanTypeCode"])) { myDetail.PlanTypeCode = Convert.ToString(myReader["PlanTypeCode"]); } if (!Convert.IsDBNull(myReader["ordernum"])) { myDetail.ordernum = Convert.ToString(myReader["ordernum"]); } if (!Convert.IsDBNull(myReader["Remarks"])) { myDetail.Remarks = Convert.ToString(myReader["Remarks"]); } if (!Convert.IsDBNull(myReader["FBillNo"])) { myDetail.FBillNo = Convert.ToString(myReader["FBillNo"]); } if (!Convert.IsDBNull(myReader["FInterID"])) { myDetail.FInterID = Convert.ToInt32(myReader["FInterID"]); } if (!Convert.IsDBNull(myReader["FEntryID"])) { myDetail.FEntryID = Convert.ToInt32(myReader["FEntryID"]); } if (!Convert.IsDBNull(myReader["FNumber"])) { myDetail.FNumber = Convert.ToString(myReader["FNumber"]); } if (!Convert.IsDBNull(myReader["FName"])) { myDetail.FName = Convert.ToString(myReader["FName"]); } if (!Convert.IsDBNull(myReader["FModel"])) { myDetail.FModel = Convert.ToString(myReader["FModel"]); } if (!Convert.IsDBNull(myReader["Funit"])) { myDetail.Funit = Convert.ToString(myReader["Funit"]); } if (!Convert.IsDBNull(myReader["FUnitID"])) { myDetail.FUnitID = Convert.ToString(myReader["FUnitID"]); } if (!Convert.IsDBNull(myReader["FNeedQty"])) { myDetail.FNeedQty = Convert.ToDecimal(myReader["FNeedQty"]); } if (!Convert.IsDBNull(myReader["FQty"])) { myDetail.FQty = Convert.ToDecimal(myReader["FQty"]); } if (!Convert.IsDBNull(myReader["DetailRemarks"])) { myDetail.DetailRemarks = Convert.ToString(myReader["DetailRemarks"]); } if (!Convert.IsDBNull(myReader["FFixLeadTime"])) { myDetail.FFixLeadTime = Convert.ToString(myReader["FFixLeadTime"]); } if (!Convert.IsDBNull(myReader["FAdmit"])) { myDetail.FAdmit = Convert.ToString(myReader["FAdmit"]); } if (!Convert.IsDBNull(myReader["FFetchTime"])) { myDetail.FFetchTime = Convert.ToDateTime(myReader["FFetchTime"]); } if (!Convert.IsDBNull(myReader["FQtyMin"])) { myDetail.FQtyMin = Convert.ToDecimal(myReader["FQtyMin"]); } if (!Convert.IsDBNull(myReader["FBatchAppendQty"])) { myDetail.FBatchAppendQty = Convert.ToDecimal(myReader["FBatchAppendQty"]); } if (!Convert.IsDBNull(myReader["Flimitprice"])) { myDetail.Flimitprice = Convert.ToString(myReader["Flimitprice"]); } if (!Convert.IsDBNull(myReader["FOpenPo"])) { myDetail.FOpenPo = Convert.ToDecimal(myReader["FOpenPo"]); } if (!Convert.IsDBNull(myReader["Fpoqty"])) { myDetail.Fpoqty = Convert.ToDecimal(myReader["Fpoqty"]); } if (!Convert.IsDBNull(myReader["Fpoqty1"])) { myDetail.Fpoqty1 = Convert.ToDecimal(myReader["Fpoqty1"]); } if (!Convert.IsDBNull(myReader["Fpoqty2"])) { myDetail.Fpoqty2 = Convert.ToDecimal(myReader["Fpoqty2"]); } if (!Convert.IsDBNull(myReader["Fstockqty"])) { myDetail.Fstockqty = Convert.ToDecimal(myReader["Fstockqty"]); } if (!Convert.IsDBNull(myReader["PackageInfo"])) { myDetail.PackageInfo = Convert.ToString(myReader["PackageInfo"]); } if (!Convert.IsDBNull(myReader["FSecInv"])) { myDetail.FSecInv = Convert.ToDecimal(myReader["FSecInv"]); } if (!Convert.IsDBNull(myReader["FSourceInterId"])) { myDetail.FSourceInterId = Convert.ToString(myReader["FSourceInterId"]); } if (!Convert.IsDBNull(myReader["FSourceBillNo"])) { myDetail.FSourceBillNo = Convert.ToString(myReader["FSourceBillNo"]); } if (!Convert.IsDBNull(myReader["FSourceEntryID"])) { myDetail.FSourceEntryID = Convert.ToString(myReader["FSourceEntryID"]); } if (!Convert.IsDBNull(myReader["Fsupname"])) { myDetail.Fsupname = Convert.ToString(myReader["Fsupname"]); } if (!Convert.IsDBNull(myReader["FsupNum"])) { myDetail.FsupNum = Convert.ToString(myReader["FsupNum"]); } if (!Convert.IsDBNull(myReader["FsupplyID"])) { myDetail.FsupplyID = Convert.ToString(myReader["FsupplyID"]); } if (!Convert.IsDBNull(myReader["CostPrice"])) { myDetail.CostPrice = Convert.ToDecimal(myReader["CostPrice"]); } if (!Convert.IsDBNull(myReader["TypeNumber"])) { myDetail.TypeNumber = Convert.ToString(myReader["TypeNumber"]); } if (!Convert.IsDBNull(myReader["ProductName"])) { myDetail.ProductName = Convert.ToString(myReader["ProductName"]); } if (!Convert.IsDBNull(myReader["FAuxPrice"])) { myDetail.FAuxPrice = Convert.ToDecimal(myReader["FAuxPrice"]); } if (!Convert.IsDBNull(myReader["Fcess"])) { myDetail.Fcess = Convert.ToInt32(myReader["Fcess"]); } if (!Convert.IsDBNull(myReader["FAmount"])) { myDetail.FAmount = Convert.ToDecimal(myReader["FAmount"]); } if (!Convert.IsDBNull(myReader["FTaxAmount"])) { myDetail.FTaxAmount = Convert.ToDecimal(myReader["FTaxAmount"]); } if (!Convert.IsDBNull(myReader["SNumber"])) { myDetail.SNumber = Convert.ToString(myReader["SNumber"]); } if (!Convert.IsDBNull(myReader["LogType"])) { myDetail.LogType = Convert.ToString(myReader["LogType"]); } if (!Convert.IsDBNull(myReader["FQtyNew"])) { myDetail.FQtyNew = Convert.ToDecimal(myReader["FQtyNew"]); } if (!Convert.IsDBNull(myReader["REQType"])) { myDetail.REQType = Convert.ToString(myReader["REQType"]); } } myReader.Close(); cmd.Dispose(); con.Close(); con.Dispose(); return(myDetail); }