/// <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));
}
}
