/// <summary>
/// 得到一个对象实体
/// </summary>
public Hownet.Model.SampleMateriel GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,MainID,Fabric1,Fabric2,Fabric3,Fabric4,Fabric5,Materiel1,Materiel2,Materiel3,Materiel4,Materiel5,Materiel6,Materiel7,Company1,LH1,Plant1,Company2,LH2,Plant2,SumAmount from SampleMateriel ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Hownet.Model.SampleMateriel model = new Hownet.Model.SampleMateriel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["MainID"].ToString() != "")
{
model.MainID = int.Parse(ds.Tables[0].Rows[0]["MainID"].ToString());
}
model.Fabric1 = ds.Tables[0].Rows[0]["Fabric1"].ToString();
model.Fabric2 = ds.Tables[0].Rows[0]["Fabric2"].ToString();
model.Fabric3 = ds.Tables[0].Rows[0]["Fabric3"].ToString();
model.Fabric4 = ds.Tables[0].Rows[0]["Fabric4"].ToString();
model.Fabric5 = ds.Tables[0].Rows[0]["Fabric5"].ToString();
model.Materiel1 = ds.Tables[0].Rows[0]["Materiel1"].ToString();
model.Materiel2 = ds.Tables[0].Rows[0]["Materiel2"].ToString();
model.Materiel3 = ds.Tables[0].Rows[0]["Materiel3"].ToString();
model.Materiel4 = ds.Tables[0].Rows[0]["Materiel4"].ToString();
model.Materiel5 = ds.Tables[0].Rows[0]["Materiel5"].ToString();
model.Materiel6 = ds.Tables[0].Rows[0]["Materiel6"].ToString();
model.Materiel7 = ds.Tables[0].Rows[0]["Materiel7"].ToString();
model.Company1 = ds.Tables[0].Rows[0]["Company1"].ToString();
model.LH1 = ds.Tables[0].Rows[0]["LH1"].ToString();
model.Plant1 = ds.Tables[0].Rows[0]["Plant1"].ToString();
model.Company2 = ds.Tables[0].Rows[0]["Company2"].ToString();
model.LH2 = ds.Tables[0].Rows[0]["LH2"].ToString();
model.Plant2 = ds.Tables[0].Rows[0]["Plant2"].ToString();
model.SumAmount = ds.Tables[0].Rows[0]["SumAmount"].ToString();
model.A = 1;
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.SampleMateriel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SampleMateriel(");
strSql.Append("MainID,Fabric1,Fabric2,Fabric3,Fabric4,Fabric5,Materiel1,Materiel2,Materiel3,Materiel4,Materiel5,Materiel6,Materiel7,Company1,LH1,Plant1,Company2,LH2,Plant2,SumAmount)");
strSql.Append(" values (");
strSql.Append("@MainID,@Fabric1,@Fabric2,@Fabric3,@Fabric4,@Fabric5,@Materiel1,@Materiel2,@Materiel3,@Materiel4,@Materiel5,@Materiel6,@Materiel7,@Company1,@LH1,@Plant1,@Company2,@LH2,@Plant2,@SumAmount)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MainID", SqlDbType.Int, 4),
new SqlParameter("@Fabric1", SqlDbType.NVarChar, 200),
new SqlParameter("@Fabric2", SqlDbType.NVarChar, 200),
new SqlParameter("@Fabric3", SqlDbType.NVarChar, 200),
new SqlParameter("@Fabric4", SqlDbType.NVarChar, 200),
new SqlParameter("@Fabric5", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel1", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel2", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel3", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel4", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel5", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel6", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel7", SqlDbType.NVarChar, 200),
new SqlParameter("@Company1", SqlDbType.NVarChar, 50),
new SqlParameter("@LH1", SqlDbType.NVarChar, 50),
new SqlParameter("@Plant1", SqlDbType.NVarChar, 50),
new SqlParameter("@Company2", SqlDbType.NVarChar, 50),
new SqlParameter("@LH2", SqlDbType.NVarChar, 50),
new SqlParameter("@Plant2", SqlDbType.NVarChar, 50),
new SqlParameter("@SumAmount", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.MainID;
parameters[1].Value = model.Fabric1;
parameters[2].Value = model.Fabric2;
parameters[3].Value = model.Fabric3;
parameters[4].Value = model.Fabric4;
parameters[5].Value = model.Fabric5;
parameters[6].Value = model.Materiel1;
parameters[7].Value = model.Materiel2;
parameters[8].Value = model.Materiel3;
parameters[9].Value = model.Materiel4;
parameters[10].Value = model.Materiel5;
parameters[11].Value = model.Materiel6;
parameters[12].Value = model.Materiel7;
parameters[13].Value = model.Company1;
parameters[14].Value = model.LH1;
parameters[15].Value = model.Plant1;
parameters[16].Value = model.Company2;
parameters[17].Value = model.LH2;
parameters[18].Value = model.Plant2;
parameters[19].Value = model.SumAmount;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.SampleMateriel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SampleMateriel set ");
strSql.Append("MainID=@MainID,");
strSql.Append("Fabric1=@Fabric1,");
strSql.Append("Fabric2=@Fabric2,");
strSql.Append("Fabric3=@Fabric3,");
strSql.Append("Fabric4=@Fabric4,");
strSql.Append("Fabric5=@Fabric5,");
strSql.Append("Materiel1=@Materiel1,");
strSql.Append("Materiel2=@Materiel2,");
strSql.Append("Materiel3=@Materiel3,");
strSql.Append("Materiel4=@Materiel4,");
strSql.Append("Materiel5=@Materiel5,");
strSql.Append("Materiel6=@Materiel6,");
strSql.Append("Materiel7=@Materiel7,");
strSql.Append("Company1=@Company1,");
strSql.Append("LH1=@LH1,");
strSql.Append("Plant1=@Plant1,");
strSql.Append("Company2=@Company2,");
strSql.Append("LH2=@LH2,");
strSql.Append("Plant2=@Plant2,");
strSql.Append("SumAmount=@SumAmount");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@MainID", SqlDbType.Int, 4),
new SqlParameter("@Fabric1", SqlDbType.NVarChar, 200),
new SqlParameter("@Fabric2", SqlDbType.NVarChar, 200),
new SqlParameter("@Fabric3", SqlDbType.NVarChar, 200),
new SqlParameter("@Fabric4", SqlDbType.NVarChar, 200),
new SqlParameter("@Fabric5", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel1", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel2", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel3", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel4", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel5", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel6", SqlDbType.NVarChar, 200),
new SqlParameter("@Materiel7", SqlDbType.NVarChar, 200),
new SqlParameter("@Company1", SqlDbType.NVarChar, 50),
new SqlParameter("@LH1", SqlDbType.NVarChar, 50),
new SqlParameter("@Plant1", SqlDbType.NVarChar, 50),
new SqlParameter("@Company2", SqlDbType.NVarChar, 50),
new SqlParameter("@LH2", SqlDbType.NVarChar, 50),
new SqlParameter("@Plant2", SqlDbType.NVarChar, 50),
new SqlParameter("@SumAmount", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.MainID;
parameters[2].Value = model.Fabric1;
parameters[3].Value = model.Fabric2;
parameters[4].Value = model.Fabric3;
parameters[5].Value = model.Fabric4;
parameters[6].Value = model.Fabric5;
parameters[7].Value = model.Materiel1;
parameters[8].Value = model.Materiel2;
parameters[9].Value = model.Materiel3;
parameters[10].Value = model.Materiel4;
parameters[11].Value = model.Materiel5;
parameters[12].Value = model.Materiel6;
parameters[13].Value = model.Materiel7;
parameters[14].Value = model.Company1;
parameters[15].Value = model.LH1;
parameters[16].Value = model.Plant1;
parameters[17].Value = model.Company2;
parameters[18].Value = model.LH2;
parameters[19].Value = model.Plant2;
parameters[20].Value = model.SumAmount;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
