/// <summary> /// 更新一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int update(Model.problem_handle_record model) { string strSql = "UPDATE problem_handle_record SET MasterID=@MasterID,Status=@Status,Start_Date=@Start_Date," + "End_Date=@End_Date,AOI=@AOI,CLN=@CLN,COA=@COA,DEV=@DEV,DHC=@DHC,DUV=@DUV," + "EXP=@EXP,OVN=@OVN,PHC=@PHC,SMA=@SMA,`ALL`=@ALL,Is_New=@Is_New," + "Problem_Machine_Name=@Problem_Machine_Name,Source_Case_ID=@Source_Case_ID WHERE ID=@ID"; MySqlParameter[] parameters = { new MySqlParameter("@MasterID", MySqlDbType.VarChar, 255), new MySqlParameter("@Status", MySqlDbType.VarChar, 255), new MySqlParameter("@Start_Date", MySqlDbType.DateTime), new MySqlParameter("@End_Date", MySqlDbType.DateTime), new MySqlParameter("@AOI", MySqlDbType.VarChar, 255), new MySqlParameter("@CLN", MySqlDbType.VarChar, 255), new MySqlParameter("@COA", MySqlDbType.VarChar, 255), new MySqlParameter("@DEV", MySqlDbType.VarChar, 255), new MySqlParameter("@DHC", MySqlDbType.VarChar, 255), new MySqlParameter("@DUV", MySqlDbType.VarChar, 255), new MySqlParameter("@EXP", MySqlDbType.VarChar, 255), new MySqlParameter("@OVN", MySqlDbType.VarChar, 255), new MySqlParameter("@PHC", MySqlDbType.VarChar, 255), new MySqlParameter("@SMA", MySqlDbType.VarChar, 255), new MySqlParameter("@ALL", MySqlDbType.VarChar, 255), new MySqlParameter("@Is_New", MySqlDbType.VarChar, 10), new MySqlParameter("@Problem_Machine_Name", MySqlDbType.VarChar, 255), new MySqlParameter("@Source_Case_ID", MySqlDbType.Int16), new MySqlParameter("@ID", MySqlDbType.Int32) }; parameters[0].Value = model.MasterID; parameters[1].Value = model.Status; parameters[2].Value = model.Start_Date; parameters[3].Value = model.End_Date; parameters[4].Value = model.AOI; parameters[5].Value = model.CLN; parameters[6].Value = model.COA; parameters[7].Value = model.DEV; parameters[8].Value = model.DHC; parameters[9].Value = model.DUV; parameters[10].Value = model.EXP; parameters[11].Value = model.OVN; parameters[12].Value = model.PHC; parameters[13].Value = model.SMA; parameters[14].Value = model.ALL; parameters[15].Value = model.Is_New; parameters[16].Value = model.Problem_Machine_Name; parameters[17].Value = model.Source_Case_ID; parameters[18].Value = model.Id; object obj = Utility.MySqlHelper.ExecuteTxtScalar(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public int add(Model.problem_handle_record model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into problem_handle_record("); strSql.Append("MasterID,Status,Start_Date,End_Date,AOI,CLN,COA,DEV,DHC,"); strSql.Append("DUV,EXP,OVN,PHC,SMA,`ALL`,Is_New,Problem_Machine_Name,Source_Case_ID)"); strSql.Append(" values ("); strSql.Append("@MasterID,@Status,@Start_Date,@End_Date,@AOI,@CLN,@COA,@DEV,@DHC,"); strSql.Append("@DUV, @EXP, @OVN, @PHC, @SMA, @ALL, @Is_New, @Problem_Machine_Name, @Source_Case_ID)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@MasterID", MySqlDbType.VarChar, 255), new MySqlParameter("@Status", MySqlDbType.VarChar, 255), new MySqlParameter("@Start_Date", MySqlDbType.DateTime), new MySqlParameter("@End_Date", MySqlDbType.DateTime), new MySqlParameter("@AOI", MySqlDbType.VarChar, 255), new MySqlParameter("@CLN", MySqlDbType.VarChar, 255), new MySqlParameter("@COA", MySqlDbType.VarChar, 255), new MySqlParameter("@DEV", MySqlDbType.VarChar, 255), new MySqlParameter("@DHC", MySqlDbType.VarChar, 255), new MySqlParameter("@DUV", MySqlDbType.VarChar, 255), new MySqlParameter("@EXP", MySqlDbType.VarChar, 255), new MySqlParameter("@OVN", MySqlDbType.VarChar, 255), new MySqlParameter("@PHC", MySqlDbType.VarChar, 255), new MySqlParameter("@SMA", MySqlDbType.VarChar, 255), new MySqlParameter("@ALL", MySqlDbType.VarChar, 255), new MySqlParameter("@Is_New", MySqlDbType.VarChar, 10), new MySqlParameter("@Problem_Machine_Name", MySqlDbType.VarChar, 255), new MySqlParameter("@Source_Case_ID", MySqlDbType.Int16) }; parameters[0].Value = model.MasterID; parameters[1].Value = model.Status; parameters[2].Value = model.Start_Date; parameters[3].Value = model.End_Date; parameters[4].Value = model.AOI; parameters[5].Value = model.CLN; parameters[6].Value = model.COA; parameters[7].Value = model.DEV; parameters[8].Value = model.DHC; parameters[9].Value = model.DUV; parameters[10].Value = model.EXP; parameters[11].Value = model.OVN; parameters[12].Value = model.PHC; parameters[13].Value = model.SMA; parameters[14].Value = model.ALL; parameters[15].Value = model.Is_New; parameters[16].Value = model.Problem_Machine_Name; parameters[17].Value = model.Source_Case_ID; object obj = Utility.MySqlHelper.ExecuteTxtScalar(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }