public void UpdateItemInfo() { DataView dv = GetDistinct(); if (dv.Count > 0) { JD_IcItemPrjBGApply_Log model = new JD_IcItemPrjBGApply_Log(); foreach (DataRowView dr in dv) { string ErrorMsg = string.Empty; string sql = string.Empty; try { int ItemID = Convert.ToInt32(dr["ItemID"].ToString()); int FItemID = Convert.ToInt32(dr["FItemID"].ToString()); model = Detail(ItemID); #region 更新PPQ if (model.FPPQ != model.FPPQNew) { sql = string.Format(@" update t_ICItemCustom set f_119='{0}' where FItemID='{1}'", model.FPPQNew.ToString(), FItemID.ToString()); DBUtil.ExecuteSql(sql, K3connectionString); } #endregion #region 更新fname,fmodel if (model.FName != model.FNameNew) { sql = string.Format(@" update t_ICItemCore set fname='{0}' where FItemID='{1}'", model.FNameNew.ToString(), FItemID.ToString()); DBUtil.ExecuteSql(sql, K3connectionString); } if (model.FModel != model.FModelNew) { sql = string.Format(@" update t_ICItemCore set FModel='{0}' where FItemID='{1}'", model.FModelNew.ToString(), FItemID.ToString()); DBUtil.ExecuteSql(sql, K3connectionString); } #endregion #region 更新全名 if (model.FFullName.IndexOf('_') > -1 && (model.FName != model.FNameNew)) { model.FFullName = model.FFullName.Split('_')[0] + "_" + model.FNameNew; sql = string.Format(@" update t_ICItemBase set FFullName='{0}' where FItemID='{1}'", model.FFullName, FItemID.ToString()); DBUtil.ExecuteSql(sql, K3connectionString); } #endregion } catch (Exception ex) { ErrorMsg = ex.Message; } finally { model.IsUpdate = 1; model.UpdateTime = DateTime.Now; Update(model); //显示到集成日志的应用中 common.AddLogQueue(model.TaskID, "JD_IcItemPrjBGApply_Log", model.ItemID, "SQL", ErrorMsg); } } } }
/// <summary> /// 对象JD_IcItemPrjBGApply_Log明细 /// 编写人:ywk /// 编写日期:2018/10/11 星期四 /// </summary> public JD_IcItemPrjBGApply_Log Detail(int ItemID) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("SELECT * FROM JD_IcItemPrjBGApply_Log WHERE ItemID = @m_ItemID", con); con.Open(); cmd.Parameters.Add(new SqlParameter("@m_ItemID", SqlDbType.Int, 0)).Value = ItemID; JD_IcItemPrjBGApply_Log myDetail = new JD_IcItemPrjBGApply_Log(); SqlDataReader myReader = cmd.ExecuteReader(); if (myReader.Read()) { if (!Convert.IsDBNull(myReader["ItemID"])) { myDetail.ItemID = Convert.ToInt32(myReader["ItemID"]); } if (!Convert.IsDBNull(myReader["Requester"])) { myDetail.Requester = Convert.ToString(myReader["Requester"]); } if (!Convert.IsDBNull(myReader["RequestDate"])) { myDetail.RequestDate = Convert.ToDateTime(myReader["RequestDate"]); } if (!Convert.IsDBNull(myReader["TaskID"])) { myDetail.TaskID = Convert.ToInt32(myReader["TaskID"]); } if (!Convert.IsDBNull(myReader["SNumber"])) { myDetail.SNumber = Convert.ToString(myReader["SNumber"]); } if (!Convert.IsDBNull(myReader["FItemID"])) { myDetail.FItemID = Convert.ToInt32(myReader["FItemID"]); } 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["FFullName"])) { myDetail.FFullName = Convert.ToString(myReader["FFullName"]); } if (!Convert.IsDBNull(myReader["FNameNew"])) { myDetail.FNameNew = Convert.ToString(myReader["FNameNew"]); } if (!Convert.IsDBNull(myReader["FModel"])) { myDetail.FModel = Convert.ToString(myReader["FModel"]); } if (!Convert.IsDBNull(myReader["FModelNew"])) { myDetail.FModelNew = Convert.ToString(myReader["FModelNew"]); } if (!Convert.IsDBNull(myReader["FNetWeight"])) { myDetail.FNetWeight = Convert.ToDecimal(myReader["FNetWeight"]); } if (!Convert.IsDBNull(myReader["FNetWeightNew"])) { myDetail.FNetWeightNew = Convert.ToDecimal(myReader["FNetWeightNew"]); } if (!Convert.IsDBNull(myReader["FGrossWeight"])) { myDetail.FGrossWeight = Convert.ToDecimal(myReader["FGrossWeight"]); } if (!Convert.IsDBNull(myReader["FGrossWeightNew"])) { myDetail.FGrossWeightNew = Convert.ToDecimal(myReader["FGrossWeightNew"]); } if (!Convert.IsDBNull(myReader["FPPQ"])) { myDetail.FPPQ = Convert.ToDouble(myReader["FPPQ"]); } if (!Convert.IsDBNull(myReader["FPPQNew"])) { myDetail.FPPQNew = Convert.ToDouble(myReader["FPPQNew"]); } if (!Convert.IsDBNull(myReader["Remarks"])) { myDetail.Remarks = Convert.ToString(myReader["Remarks"]); } if (!Convert.IsDBNull(myReader["UpdateTime"])) { myDetail.UpdateTime = Convert.ToDateTime(myReader["UpdateTime"]); } if (!Convert.IsDBNull(myReader["IsUpdate"])) { myDetail.IsUpdate = Convert.ToInt32(myReader["IsUpdate"]); } } myReader.Close(); cmd.Dispose(); con.Close(); con.Dispose(); return(myDetail); }
/// <summary> /// 更新JD_IcItemPrjBGApply_Log对象 /// 编写人:ywk /// 编写日期:2018/10/11 星期四 /// </summary> public void Update(JD_IcItemPrjBGApply_Log model) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("UPDATE JD_IcItemPrjBGApply_Log SET Requester = @m_Requester,RequestDate = @m_RequestDate,TaskID = @m_TaskID,SNumber = @m_SNumber,FItemID = @m_FItemID,FNumber = @m_FNumber,FName = @m_FName,FFullName = @m_FFullName,FNameNew = @m_FNameNew,FModel = @m_FModel,FModelNew = @m_FModelNew,FNetWeight = @m_FNetWeight,FNetWeightNew = @m_FNetWeightNew,FGrossWeight = @m_FGrossWeight,FGrossWeightNew = @m_FGrossWeightNew,FPPQ = @m_FPPQ,FPPQNew = @m_FPPQNew,Remarks = @m_Remarks,UpdateTime = @m_UpdateTime,IsUpdate = @m_IsUpdate WHERE ItemID = @m_ItemID", con); con.Open(); if (model.Requester == null) { cmd.Parameters.Add(new SqlParameter("@m_Requester", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Requester", SqlDbType.NVarChar, 50)).Value = model.Requester; } if (model.RequestDate == new DateTime()) { cmd.Parameters.Add(new SqlParameter("@m_RequestDate", SqlDbType.DateTime, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_RequestDate", SqlDbType.DateTime, 0)).Value = model.RequestDate; } 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.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.FItemID == null) { cmd.Parameters.Add(new SqlParameter("@m_FItemID", SqlDbType.Int, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FItemID", SqlDbType.Int, 0)).Value = model.FItemID; } if (model.FNumber == null) { cmd.Parameters.Add(new SqlParameter("@m_FNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FNumber", SqlDbType.NVarChar, 50)).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.FFullName == null) { cmd.Parameters.Add(new SqlParameter("@m_FFullName", SqlDbType.NVarChar, 100)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FFullName", SqlDbType.NVarChar, 100)).Value = model.FFullName; } if (model.FNameNew == null) { cmd.Parameters.Add(new SqlParameter("@m_FNameNew", SqlDbType.NVarChar, 100)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FNameNew", SqlDbType.NVarChar, 100)).Value = model.FNameNew; } if (model.FModel == null) { cmd.Parameters.Add(new SqlParameter("@m_FModel", SqlDbType.NText, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FModel", SqlDbType.NText, 0)).Value = model.FModel; } if (model.FModelNew == null) { cmd.Parameters.Add(new SqlParameter("@m_FModelNew", SqlDbType.NText, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FModelNew", SqlDbType.NText, 0)).Value = model.FModelNew; } if (model.FNetWeight == null) { cmd.Parameters.Add(new SqlParameter("@m_FNetWeight", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FNetWeight", SqlDbType.Decimal, 18)).Value = model.FNetWeight; } if (model.FNetWeightNew == null) { cmd.Parameters.Add(new SqlParameter("@m_FNetWeightNew", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FNetWeightNew", SqlDbType.Decimal, 18)).Value = model.FNetWeightNew; } if (model.FGrossWeight == null) { cmd.Parameters.Add(new SqlParameter("@m_FGrossWeight", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FGrossWeight", SqlDbType.Decimal, 18)).Value = model.FGrossWeight; } if (model.FGrossWeightNew == null) { cmd.Parameters.Add(new SqlParameter("@m_FGrossWeightNew", SqlDbType.Decimal, 18)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FGrossWeightNew", SqlDbType.Decimal, 18)).Value = model.FGrossWeightNew; } if (model.FPPQ == null) { cmd.Parameters.Add(new SqlParameter("@m_FPPQ", SqlDbType.Float, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FPPQ", SqlDbType.Float, 0)).Value = model.FPPQ; } if (model.FPPQNew == null) { cmd.Parameters.Add(new SqlParameter("@m_FPPQNew", SqlDbType.Float, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_FPPQNew", SqlDbType.Float, 0)).Value = model.FPPQNew; } if (model.Remarks == null) { cmd.Parameters.Add(new SqlParameter("@m_Remarks", SqlDbType.NVarChar, 100)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_Remarks", SqlDbType.NVarChar, 100)).Value = model.Remarks; } 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.IsUpdate == null) { cmd.Parameters.Add(new SqlParameter("@m_IsUpdate", SqlDbType.Int, 0)).Value = DBNull.Value; } else { cmd.Parameters.Add(new SqlParameter("@m_IsUpdate", SqlDbType.Int, 0)).Value = model.IsUpdate; } 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(); }