public Abnorma GetPageAbt(string ClientID, string EquID, string ProDesc) { Abnorma abnorma = new Abnorma { EquID = 0, ClientID = 0 }; abnorma.ClientID = Convert.ToInt32(ClientID); abnorma.EquID = Convert.ToInt32(EquID); abnorma.ProDesc = ProDesc; abnorma.Livephotos = 0; abnorma.MainteDesc = ""; abnorma.Remark = "机器自报异常"; abnorma.Serious = "否"; abnorma.Solve = "未解决"; abnorma.UpdateTime = new DateTime?(DBHelper.GetDate()); abnorma.AbSta = "未关闭"; return(abnorma); }
public static bool AddAbnorma(Abnorma model) { StringBuilder builder1 = new StringBuilder(); builder1.Append("insert into Abnorma("); builder1.Append("ClientID,EquID,ProDesc,Livephotos,MainteDesc,Livephotos2,Remark,Serious,Solve,AbSta,UpdateTime"); builder1.Append(")"); builder1.Append(" values ("); builder1.Append(model.ClientID + ","); builder1.Append(model.EquID + ","); builder1.Append("'" + model.ProDesc + "',"); builder1.Append(model.Livephotos + ","); builder1.Append("'" + model.MainteDesc + "',"); builder1.Append("'" + model.Livephotos2 + "',"); builder1.Append("'" + model.Remark + "',"); builder1.Append("'" + model.Serious + "',"); builder1.Append("'" + model.Solve + "',"); builder1.Append("'" + model.AbSta + "',"); builder1.Append("'" + model.UpdateTime + "'"); builder1.Append(")"); builder1.Append(";select @@IDENTITY"); return(ExecuteNonQuery(builder1.ToString()) >= 1); }
public Abnorma GetPageAbts(string sNUs, string num) { Abnorma abnorma = new Abnorma { EquID = 0, ClientID = 0 }; DataSet clientAnID = DBHelper.GetClientAnID(sNUs); if (clientAnID.Tables[0].Rows.Count >= 1) { abnorma.EquID = Convert.ToInt32(clientAnID.Tables[0].Rows[0]["ID"].ToString()); abnorma.ClientID = Convert.ToInt32(clientAnID.Tables[0].Rows[0]["ClientID"].ToString()); } abnorma.ProDesc = ""; abnorma.Livephotos = 0; abnorma.MainteDesc = ""; abnorma.Remark = "光源剩余时长大于服务器时长(数值:" + num + ")"; abnorma.Serious = "否"; abnorma.Solve = "未解决"; abnorma.UpdateTime = new DateTime?(DBHelper.GetDate()); abnorma.AbSta = "未关闭"; return(abnorma); }