/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Maticsoft.Model.e_Reworks model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_e_Reworks("); strSql.Append("Barcord,ReworkCount,RejectsNum,R_Describe,S_Describe,Result,Date,Operator,Verify,R1,R2,R3,R4,R5)"); strSql.Append(" values ("); strSql.Append("@Barcord,@ReworkCount,@RejectsNum,@R_Describe,@S_Describe,@Result,@Date,@Operator,@Verify,@R1,@R2,@R3,@R4,@R5)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Barcord", SqlDbType.VarBinary, 50), new SqlParameter("@ReworkCount", SqlDbType.VarBinary, 50), new SqlParameter("@RejectsNum", SqlDbType.VarBinary, 50), new SqlParameter("@R_Describe", SqlDbType.Text), new SqlParameter("@S_Describe", SqlDbType.Text), new SqlParameter("@Result", SqlDbType.NVarChar, 50), new SqlParameter("@Date", SqlDbType.DateTime), new SqlParameter("@Operator", SqlDbType.VarBinary, 50), new SqlParameter("@Verify", SqlDbType.VarBinary, 50), new SqlParameter("@R1", SqlDbType.Text), new SqlParameter("@R2", SqlDbType.Text), new SqlParameter("@R3", SqlDbType.Text), new SqlParameter("@R4", SqlDbType.Text), new SqlParameter("@R5", SqlDbType.Text) }; parameters[0].Value = model.Barcord; parameters[1].Value = model.ReworkCount; parameters[2].Value = model.RejectsNum; parameters[3].Value = model.R_Describe; parameters[4].Value = model.S_Describe; parameters[5].Value = model.Result; parameters[6].Value = model.Date; parameters[7].Value = model.Operator; parameters[8].Value = model.Verify; parameters[9].Value = model.R1; parameters[10].Value = model.R2; parameters[11].Value = model.R3; parameters[12].Value = model.R4; parameters[13].Value = model.R5; object obj = dbs.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.e_Reworks GetModel(decimal Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,Barcord,ReworkCount,RejectsNum,R_Describe,S_Describe,Result,Date,Operator,Verify,R1,R2,R3,R4,R5 from tb_e_Reworks "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Decimal) }; parameters[0].Value = Id; Maticsoft.Model.e_Reworks model = new Maticsoft.Model.e_Reworks(); DataSet ds = dbs.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.e_Reworks DataRowToModel(DataRow row) { Maticsoft.Model.e_Reworks model = new Maticsoft.Model.e_Reworks(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = decimal.Parse(row["Id"].ToString()); } if (row["Barcord"] != null && row["Barcord"].ToString() != "") { model.Barcord = (byte[])row["Barcord"]; } if (row["ReworkCount"] != null && row["ReworkCount"].ToString() != "") { model.ReworkCount = (byte[])row["ReworkCount"]; } if (row["RejectsNum"] != null && row["RejectsNum"].ToString() != "") { model.RejectsNum = (byte[])row["RejectsNum"]; } if (row["R_Describe"] != null) { model.R_Describe = row["R_Describe"].ToString(); } if (row["S_Describe"] != null) { model.S_Describe = row["S_Describe"].ToString(); } if (row["Result"] != null) { model.Result = row["Result"].ToString(); } if (row["Date"] != null && row["Date"].ToString() != "") { model.Date = DateTime.Parse(row["Date"].ToString()); } if (row["Operator"] != null && row["Operator"].ToString() != "") { model.Operator = (byte[])row["Operator"]; } if (row["Verify"] != null && row["Verify"].ToString() != "") { model.Verify = (byte[])row["Verify"]; } if (row["R1"] != null) { model.R1 = row["R1"].ToString(); } if (row["R2"] != null) { model.R2 = row["R2"].ToString(); } if (row["R3"] != null) { model.R3 = row["R3"].ToString(); } if (row["R4"] != null) { model.R4 = row["R4"].ToString(); } if (row["R5"] != null) { model.R5 = row["R5"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.e_Reworks model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_e_Reworks set "); strSql.Append("Barcord=@Barcord,"); strSql.Append("ReworkCount=@ReworkCount,"); strSql.Append("RejectsNum=@RejectsNum,"); strSql.Append("R_Describe=@R_Describe,"); strSql.Append("S_Describe=@S_Describe,"); strSql.Append("Result=@Result,"); strSql.Append("Date=@Date,"); strSql.Append("Operator=@Operator,"); strSql.Append("Verify=@Verify,"); strSql.Append("R1=@R1,"); strSql.Append("R2=@R2,"); strSql.Append("R3=@R3,"); strSql.Append("R4=@R4,"); strSql.Append("R5=@R5"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Barcord", SqlDbType.VarBinary, 50), new SqlParameter("@ReworkCount", SqlDbType.VarBinary, 50), new SqlParameter("@RejectsNum", SqlDbType.VarBinary, 50), new SqlParameter("@R_Describe", SqlDbType.Text), new SqlParameter("@S_Describe", SqlDbType.Text), new SqlParameter("@Result", SqlDbType.NVarChar, 50), new SqlParameter("@Date", SqlDbType.DateTime), new SqlParameter("@Operator", SqlDbType.VarBinary, 50), new SqlParameter("@Verify", SqlDbType.VarBinary, 50), new SqlParameter("@R1", SqlDbType.Text), new SqlParameter("@R2", SqlDbType.Text), new SqlParameter("@R3", SqlDbType.Text), new SqlParameter("@R4", SqlDbType.Text), new SqlParameter("@R5", SqlDbType.Text), new SqlParameter("@Id", SqlDbType.Decimal, 9) }; parameters[0].Value = model.Barcord; parameters[1].Value = model.ReworkCount; parameters[2].Value = model.RejectsNum; parameters[3].Value = model.R_Describe; parameters[4].Value = model.S_Describe; parameters[5].Value = model.Result; parameters[6].Value = model.Date; parameters[7].Value = model.Operator; parameters[8].Value = model.Verify; parameters[9].Value = model.R1; parameters[10].Value = model.R2; parameters[11].Value = model.R3; parameters[12].Value = model.R4; parameters[13].Value = model.R5; parameters[14].Value = model.Id; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }