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