/// <summary>
/// 得到一个对象实体
/// </summary>
public WorkShopSystem.Model.JiJiaQueXianDetail GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 time,cnctiaojipin,falanmianyashang,falanmianhuahenpengshang,hmianyashang,jinqikoukepeng,shangzhouchengkongkepeng,daowen,kongjingchaocha,shuiyin,zangwu,jiagongbuliang,shakong,liewen,bengque,feihua,feipeng,qipi,zazhi,nianmo,maopeifamei,yanghuafahei,luodi,qita,lamo,xiankawai,chouyangshu,gonghao,feijiagongmianaokeng,lvxue,type,liuchengpiaobianhao from JiJiaQueXianDetail ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
WorkShopSystem.Model.JiJiaQueXianDetail model = new WorkShopSystem.Model.JiJiaQueXianDetail();
DataTable ds = SqlHelper.ExecuteDataTable(strSql.ToString(), parameters);
if (ds.Rows.Count > 0)
{
return(DataRowToModel(ds.Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WorkShopSystem.Model.JiJiaQueXianDetail DataRowToModel(DataRow row)
{
WorkShopSystem.Model.JiJiaQueXianDetail model = new WorkShopSystem.Model.JiJiaQueXianDetail();
if (row != null)
{
if (row["time"] != null && row["time"].ToString() != "")
{
model.time = DateTime.Parse(row["time"].ToString());
}
if (row["cnctiaojipin"] != null && row["cnctiaojipin"].ToString() != "")
{
model.cnctiaojipin = decimal.Parse(row["cnctiaojipin"].ToString());
}
if (row["falanmianyashang"] != null && row["falanmianyashang"].ToString() != "")
{
model.falanmianyashang = decimal.Parse(row["falanmianyashang"].ToString());
}
if (row["falanmianhuahenpengshang"] != null && row["falanmianhuahenpengshang"].ToString() != "")
{
model.falanmianhuahenpengshang = decimal.Parse(row["falanmianhuahenpengshang"].ToString());
}
if (row["hmianyashang"] != null && row["hmianyashang"].ToString() != "")
{
model.hmianyashang = decimal.Parse(row["hmianyashang"].ToString());
}
if (row["jinqikoukepeng"] != null && row["jinqikoukepeng"].ToString() != "")
{
model.jinqikoukepeng = decimal.Parse(row["jinqikoukepeng"].ToString());
}
if (row["shangzhouchengkongkepeng"] != null && row["shangzhouchengkongkepeng"].ToString() != "")
{
model.shangzhouchengkongkepeng = decimal.Parse(row["shangzhouchengkongkepeng"].ToString());
}
if (row["daowen"] != null && row["daowen"].ToString() != "")
{
model.daowen = decimal.Parse(row["daowen"].ToString());
}
if (row["kongjingchaocha"] != null && row["kongjingchaocha"].ToString() != "")
{
model.kongjingchaocha = decimal.Parse(row["kongjingchaocha"].ToString());
}
if (row["shuiyin"] != null && row["shuiyin"].ToString() != "")
{
model.shuiyin = decimal.Parse(row["shuiyin"].ToString());
}
if (row["zangwu"] != null && row["zangwu"].ToString() != "")
{
model.zangwu = decimal.Parse(row["zangwu"].ToString());
}
if (row["jiagongbuliang"] != null && row["jiagongbuliang"].ToString() != "")
{
model.jiagongbuliang = decimal.Parse(row["jiagongbuliang"].ToString());
}
if (row["shakong"] != null && row["shakong"].ToString() != "")
{
model.shakong = decimal.Parse(row["shakong"].ToString());
}
if (row["liewen"] != null && row["liewen"].ToString() != "")
{
model.liewen = decimal.Parse(row["liewen"].ToString());
}
if (row["bengque"] != null && row["bengque"].ToString() != "")
{
model.bengque = decimal.Parse(row["bengque"].ToString());
}
if (row["feihua"] != null && row["feihua"].ToString() != "")
{
model.feihua = decimal.Parse(row["feihua"].ToString());
}
if (row["feipeng"] != null && row["feipeng"].ToString() != "")
{
model.feipeng = decimal.Parse(row["feipeng"].ToString());
}
if (row["qipi"] != null && row["qipi"].ToString() != "")
{
model.qipi = decimal.Parse(row["qipi"].ToString());
}
if (row["zazhi"] != null && row["zazhi"].ToString() != "")
{
model.zazhi = decimal.Parse(row["zazhi"].ToString());
}
if (row["nianmo"] != null && row["nianmo"].ToString() != "")
{
model.nianmo = decimal.Parse(row["nianmo"].ToString());
}
if (row["maopeifamei"] != null && row["maopeifamei"].ToString() != "")
{
model.maopeifamei = decimal.Parse(row["maopeifamei"].ToString());
}
if (row["yanghuafahei"] != null && row["yanghuafahei"].ToString() != "")
{
model.yanghuafahei = decimal.Parse(row["yanghuafahei"].ToString());
}
if (row["luodi"] != null && row["luodi"].ToString() != "")
{
model.luodi = decimal.Parse(row["luodi"].ToString());
}
if (row["qita"] != null && row["qita"].ToString() != "")
{
model.qita = decimal.Parse(row["qita"].ToString());
}
if (row["lamo"] != null && row["lamo"].ToString() != "")
{
model.lamo = decimal.Parse(row["lamo"].ToString());
}
if (row["xiankawai"] != null && row["xiankawai"].ToString() != "")
{
model.xiankawai = decimal.Parse(row["xiankawai"].ToString());
}
if (row["chouyangshu"] != null && row["chouyangshu"].ToString() != "")
{
model.chouyangshu = decimal.Parse(row["chouyangshu"].ToString());
}
if (row["gonghao"] != null)
{
model.gonghao = row["gonghao"].ToString();
}
if (row["feijiagongmianaokeng"] != null && row["feijiagongmianaokeng"].ToString() != "")
{
model.feijiagongmianaokeng = decimal.Parse(row["feijiagongmianaokeng"].ToString());
}
if (row["lvxue"] != null && row["lvxue"].ToString() != "")
{
model.lvxue = decimal.Parse(row["lvxue"].ToString());
}
if (row["type"] != null && row["type"].ToString() != "")
{
model.type = int.Parse(row["type"].ToString());
}
if (row["liuchengpiaobianhao"] != null)
{
model.liuchengpiaobianhao = row["liuchengpiaobianhao"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WorkShopSystem.Model.JiJiaQueXianDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into JiJiaQueXianDetail(");
strSql.Append("time,cnctiaojipin,falanmianyashang,falanmianhuahenpengshang,hmianyashang,jinqikoukepeng,shangzhouchengkongkepeng,daowen,kongjingchaocha,shuiyin,zangwu,jiagongbuliang,shakong,liewen,bengque,feihua,feipeng,qipi,zazhi,nianmo,maopeifamei,yanghuafahei,luodi,qita,lamo,xiankawai,chouyangshu,gonghao,feijiagongmianaokeng,lvxue,type,liuchengpiaobianhao)");
strSql.Append(" values (");
strSql.Append("@time,@cnctiaojipin,@falanmianyashang,@falanmianhuahenpengshang,@hmianyashang,@jinqikoukepeng,@shangzhouchengkongkepeng,@daowen,@kongjingchaocha,@shuiyin,@zangwu,@jiagongbuliang,@shakong,@liewen,@bengque,@feihua,@feipeng,@qipi,@zazhi,@nianmo,@maopeifamei,@yanghuafahei,@luodi,@qita,@lamo,@xiankawai,@chouyangshu,@gonghao,@feijiagongmianaokeng,@lvxue,@type,@liuchengpiaobianhao)");
SqlParameter[] parameters =
{
new SqlParameter("@time", SqlDbType.DateTime),
new SqlParameter("@cnctiaojipin", SqlDbType.Decimal, 17),
new SqlParameter("@falanmianyashang", SqlDbType.Decimal, 17),
new SqlParameter("@falanmianhuahenpengshang", SqlDbType.Decimal, 17),
new SqlParameter("@hmianyashang", SqlDbType.Decimal, 17),
new SqlParameter("@jinqikoukepeng", SqlDbType.Decimal, 17),
new SqlParameter("@shangzhouchengkongkepeng", SqlDbType.Decimal, 17),
new SqlParameter("@daowen", SqlDbType.Decimal, 17),
new SqlParameter("@kongjingchaocha", SqlDbType.Decimal, 17),
new SqlParameter("@shuiyin", SqlDbType.Decimal, 17),
new SqlParameter("@zangwu", SqlDbType.Decimal, 17),
new SqlParameter("@jiagongbuliang", SqlDbType.Decimal, 17),
new SqlParameter("@shakong", SqlDbType.Decimal, 17),
new SqlParameter("@liewen", SqlDbType.Decimal, 17),
new SqlParameter("@bengque", SqlDbType.Decimal, 17),
new SqlParameter("@feihua", SqlDbType.Decimal, 17),
new SqlParameter("@feipeng", SqlDbType.Decimal, 17),
new SqlParameter("@qipi", SqlDbType.Decimal, 17),
new SqlParameter("@zazhi", SqlDbType.Decimal, 17),
new SqlParameter("@nianmo", SqlDbType.Decimal, 17),
new SqlParameter("@maopeifamei", SqlDbType.Decimal, 17),
new SqlParameter("@yanghuafahei", SqlDbType.Decimal, 17),
new SqlParameter("@luodi", SqlDbType.Decimal, 17),
new SqlParameter("@qita", SqlDbType.Decimal, 17),
new SqlParameter("@lamo", SqlDbType.Decimal, 17),
new SqlParameter("@xiankawai", SqlDbType.Decimal, 17),
new SqlParameter("@chouyangshu", SqlDbType.Decimal, 17),
new SqlParameter("@gonghao", SqlDbType.NVarChar, 30),
new SqlParameter("@feijiagongmianaokeng", SqlDbType.Decimal, 17),
new SqlParameter("@lvxue", SqlDbType.Decimal, 17),
new SqlParameter("@type", SqlDbType.Decimal, 17),
new SqlParameter("@liuchengpiaobianhao", SqlDbType.NVarChar, 30)
};
parameters[0].Value = model.time;
parameters[1].Value = model.cnctiaojipin;
parameters[2].Value = model.falanmianyashang;
parameters[3].Value = model.falanmianhuahenpengshang;
parameters[4].Value = model.hmianyashang;
parameters[5].Value = model.jinqikoukepeng;
parameters[6].Value = model.shangzhouchengkongkepeng;
parameters[7].Value = model.daowen;
parameters[8].Value = model.kongjingchaocha;
parameters[9].Value = model.shuiyin;
parameters[10].Value = model.zangwu;
parameters[11].Value = model.jiagongbuliang;
parameters[12].Value = model.shakong;
parameters[13].Value = model.liewen;
parameters[14].Value = model.bengque;
parameters[15].Value = model.feihua;
parameters[16].Value = model.feipeng;
parameters[17].Value = model.qipi;
parameters[18].Value = model.zazhi;
parameters[19].Value = model.nianmo;
parameters[20].Value = model.maopeifamei;
parameters[21].Value = model.yanghuafahei;
parameters[22].Value = model.luodi;
parameters[23].Value = model.qita;
parameters[24].Value = model.lamo;
parameters[25].Value = model.xiankawai;
parameters[26].Value = model.chouyangshu;
parameters[27].Value = model.gonghao;
parameters[28].Value = model.feijiagongmianaokeng;
parameters[29].Value = model.lvxue;
parameters[30].Value = model.type;
parameters[31].Value = model.liuchengpiaobianhao;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WorkShopSystem.Model.JiJiaQueXianDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update JiJiaQueXianDetail set ");
strSql.Append("time=@time,");
strSql.Append("cnctiaojipin=@cnctiaojipin,");
strSql.Append("falanmianyashang=@falanmianyashang,");
strSql.Append("falanmianhuahenpengshang=@falanmianhuahenpengshang,");
strSql.Append("hmianyashang=@hmianyashang,");
strSql.Append("jinqikoukepeng=@jinqikoukepeng,");
strSql.Append("shangzhouchengkongkepeng=@shangzhouchengkongkepeng,");
strSql.Append("daowen=@daowen,");
strSql.Append("kongjingchaocha=@kongjingchaocha,");
strSql.Append("shuiyin=@shuiyin,");
strSql.Append("zangwu=@zangwu,");
strSql.Append("jiagongbuliang=@jiagongbuliang,");
strSql.Append("shakong=@shakong,");
strSql.Append("liewen=@liewen,");
strSql.Append("bengque=@bengque,");
strSql.Append("feihua=@feihua,");
strSql.Append("feipeng=@feipeng,");
strSql.Append("qipi=@qipi,");
strSql.Append("zazhi=@zazhi,");
strSql.Append("nianmo=@nianmo,");
strSql.Append("maopeifamei=@maopeifamei,");
strSql.Append("yanghuafahei=@yanghuafahei,");
strSql.Append("luodi=@luodi,");
strSql.Append("qita=@qita,");
strSql.Append("lamo=@lamo,");
strSql.Append("xiankawai=@xiankawai,");
strSql.Append("chouyangshu=@chouyangshu,");
strSql.Append("gonghao=@gonghao,");
strSql.Append("feijiagongmianaokeng=@feijiagongmianaokeng,");
strSql.Append("lvxue=@lvxue,");
strSql.Append("type=@type,");
strSql.Append("liuchengpiaobianhao=@liuchengpiaobianhao");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@time", SqlDbType.DateTime),
new SqlParameter("@cnctiaojipin", SqlDbType.Decimal, 17),
new SqlParameter("@falanmianyashang", SqlDbType.Decimal, 17),
new SqlParameter("@falanmianhuahenpengshang", SqlDbType.Decimal, 17),
new SqlParameter("@hmianyashang", SqlDbType.Decimal, 17),
new SqlParameter("@jinqikoukepeng", SqlDbType.Decimal, 17),
new SqlParameter("@shangzhouchengkongkepeng", SqlDbType.Decimal, 17),
new SqlParameter("@daowen", SqlDbType.Decimal, 17),
new SqlParameter("@kongjingchaocha", SqlDbType.Decimal, 17),
new SqlParameter("@shuiyin", SqlDbType.Decimal, 17),
new SqlParameter("@zangwu", SqlDbType.Decimal, 17),
new SqlParameter("@jiagongbuliang", SqlDbType.Decimal, 17),
new SqlParameter("@shakong", SqlDbType.Decimal, 17),
new SqlParameter("@liewen", SqlDbType.Decimal, 17),
new SqlParameter("@bengque", SqlDbType.Decimal, 17),
new SqlParameter("@feihua", SqlDbType.Decimal, 17),
new SqlParameter("@feipeng", SqlDbType.Decimal, 17),
new SqlParameter("@qipi", SqlDbType.Decimal, 17),
new SqlParameter("@zazhi", SqlDbType.Decimal, 17),
new SqlParameter("@nianmo", SqlDbType.Decimal, 17),
new SqlParameter("@maopeifamei", SqlDbType.Decimal, 17),
new SqlParameter("@yanghuafahei", SqlDbType.Decimal, 17),
new SqlParameter("@luodi", SqlDbType.Decimal, 17),
new SqlParameter("@qita", SqlDbType.Decimal, 17),
new SqlParameter("@lamo", SqlDbType.Decimal, 17),
new SqlParameter("@xiankawai", SqlDbType.Decimal, 17),
new SqlParameter("@chouyangshu", SqlDbType.Decimal, 17),
new SqlParameter("@gonghao", SqlDbType.NVarChar, 30),
new SqlParameter("@feijiagongmianaokeng", SqlDbType.Decimal, 17),
new SqlParameter("@lvxue", SqlDbType.Decimal, 17),
new SqlParameter("@type", SqlDbType.Decimal, 17),
new SqlParameter("@liuchengpiaobianhao", SqlDbType.NVarChar, 30)
};
parameters[0].Value = model.time;
parameters[1].Value = model.cnctiaojipin;
parameters[2].Value = model.falanmianyashang;
parameters[3].Value = model.falanmianhuahenpengshang;
parameters[4].Value = model.hmianyashang;
parameters[5].Value = model.jinqikoukepeng;
parameters[6].Value = model.shangzhouchengkongkepeng;
parameters[7].Value = model.daowen;
parameters[8].Value = model.kongjingchaocha;
parameters[9].Value = model.shuiyin;
parameters[10].Value = model.zangwu;
parameters[11].Value = model.jiagongbuliang;
parameters[12].Value = model.shakong;
parameters[13].Value = model.liewen;
parameters[14].Value = model.bengque;
parameters[15].Value = model.feihua;
parameters[16].Value = model.feipeng;
parameters[17].Value = model.qipi;
parameters[18].Value = model.zazhi;
parameters[19].Value = model.nianmo;
parameters[20].Value = model.maopeifamei;
parameters[21].Value = model.yanghuafahei;
parameters[22].Value = model.luodi;
parameters[23].Value = model.qita;
parameters[24].Value = model.lamo;
parameters[25].Value = model.xiankawai;
parameters[26].Value = model.chouyangshu;
parameters[27].Value = model.gonghao;
parameters[28].Value = model.feijiagongmianaokeng;
parameters[29].Value = model.lvxue;
parameters[30].Value = model.type;
parameters[31].Value = model.liuchengpiaobianhao;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
