/// <summary>
/// 得到一个对象实体
/// </summary>
public WorkShopSystem.Model.CommonWorkShopRecord GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 time,yazhujihao,maopeihao,muhao,liuchengpiaobianhao,banci,jihuashengchanshu,shengchanzongshu,jishuqishu,baofeizongshu,baofeilv,fanxiuzongshu,fanxiulv,xianhao,gongxu,workshoptype,gonghao,isdel,yazhuquexian,cuopifengquexian,pinjianquexian,jijiaquexian from CommonWorkShopRecord ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
WorkShopSystem.Model.CommonWorkShopRecord model = new WorkShopSystem.Model.CommonWorkShopRecord();
DataTable ds = SqlHelper.ExecuteDataTable(strSql.ToString(), parameters);
if (ds.Rows.Count > 0)
{
return(DataRowToModel(ds.Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WorkShopSystem.Model.CommonWorkShopRecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CommonWorkShopRecord set ");
strSql.Append("time=@time,");
strSql.Append("yazhujihao=@yazhujihao,");
strSql.Append("maopeihao=@maopeihao,");
strSql.Append("muhao=@muhao,");
strSql.Append("liuchengpiaobianhao=@liuchengpiaobianhao,");
strSql.Append("banci=@banci,");
strSql.Append("jihuashengchanshu=@jihuashengchanshu,");
strSql.Append("shengchanzongshu=@shengchanzongshu,");
strSql.Append("jishuqishu=@jishuqishu,");
strSql.Append("baofeizongshu=@baofeizongshu,");
strSql.Append("baofeilv=@baofeilv,");
strSql.Append("fanxiuzongshu=@fanxiuzongshu,");
strSql.Append("fanxiulv=@fanxiulv,");
strSql.Append("xianhao=@xianhao,");
strSql.Append("gongxu=@gongxu,");
strSql.Append("workshoptype=@workshoptype,");
strSql.Append("gonghao=@gonghao,");
strSql.Append("isdel=@isdel,");
strSql.Append("yazhuquexian=@yazhuquexian,");
strSql.Append("cuopifengquexian=@cuopifengquexian,");
strSql.Append("pinjianquexian=@pinjianquexian,");
strSql.Append("jijiaquexian=@jijiaquexian");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@time", SqlDbType.DateTime),
new SqlParameter("@yazhujihao", SqlDbType.NVarChar, 50),
new SqlParameter("@maopeihao", SqlDbType.NVarChar, 50),
new SqlParameter("@muhao", SqlDbType.NVarChar, 50),
new SqlParameter("@liuchengpiaobianhao", SqlDbType.NVarChar, 50),
new SqlParameter("@banci", SqlDbType.NVarChar, 50),
new SqlParameter("@jihuashengchanshu", SqlDbType.Decimal, 17),
new SqlParameter("@shengchanzongshu", SqlDbType.Decimal, 17),
new SqlParameter("@jishuqishu", SqlDbType.Decimal, 17),
new SqlParameter("@baofeizongshu", SqlDbType.Decimal, 17),
new SqlParameter("@baofeilv", SqlDbType.Decimal, 17),
new SqlParameter("@fanxiuzongshu", SqlDbType.Decimal, 17),
new SqlParameter("@fanxiulv", SqlDbType.Decimal, 17),
new SqlParameter("@xianhao", SqlDbType.NVarChar, 50),
new SqlParameter("@gongxu", SqlDbType.NVarChar, 50),
new SqlParameter("@workshoptype", SqlDbType.Decimal, 17),
new SqlParameter("@gonghao", SqlDbType.NVarChar, 50),
new SqlParameter("@isdel", SqlDbType.Decimal, 17),
new SqlParameter("@yazhuquexian", SqlDbType.Decimal, 17),
new SqlParameter("@cuopifengquexian", SqlDbType.Decimal, 17),
new SqlParameter("@pinjianquexian", SqlDbType.Decimal, 17),
new SqlParameter("@jijiaquexian", SqlDbType.Decimal, 17)
};
parameters[0].Value = model.time;
parameters[1].Value = model.yazhujihao;
parameters[2].Value = model.maopeihao;
parameters[3].Value = model.muhao;
parameters[4].Value = model.liuchengpiaobianhao;
parameters[5].Value = model.banci;
parameters[6].Value = model.jihuashengchanshu;
parameters[7].Value = model.shengchanzongshu;
parameters[8].Value = model.jishuqishu;
parameters[9].Value = model.baofeizongshu;
parameters[10].Value = model.baofeilv;
parameters[11].Value = model.fanxiuzongshu;
parameters[12].Value = model.fanxiulv;
parameters[13].Value = model.xianhao;
parameters[14].Value = model.gongxu;
parameters[15].Value = model.workshoptype;
parameters[16].Value = model.gonghao;
parameters[17].Value = model.isdel;
parameters[18].Value = model.yazhuquexian;
parameters[19].Value = model.cuopifengquexian;
parameters[20].Value = model.pinjianquexian;
parameters[21].Value = model.jijiaquexian;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WorkShopSystem.Model.CommonWorkShopRecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CommonWorkShopRecord(");
strSql.Append("time,yazhujihao,maopeihao,muhao,liuchengpiaobianhao,banci,jihuashengchanshu,shengchanzongshu,jishuqishu,baofeizongshu,baofeilv,fanxiuzongshu,fanxiulv,xianhao,gongxu,workshoptype,gonghao,isdel,yazhuquexian,cuopifengquexian,pinjianquexian,jijiaquexian)");
strSql.Append(" values (");
strSql.Append("@time,@yazhujihao,@maopeihao,@muhao,@liuchengpiaobianhao,@banci,@jihuashengchanshu,@shengchanzongshu,@jishuqishu,@baofeizongshu,@baofeilv,@fanxiuzongshu,@fanxiulv,@xianhao,@gongxu,@workshoptype,@gonghao,@isdel,@yazhuquexian,@cuopifengquexian,@pinjianquexian,@jijiaquexian)");
SqlParameter[] parameters =
{
new SqlParameter("@time", SqlDbType.DateTime),
new SqlParameter("@yazhujihao", SqlDbType.NVarChar, 50),
new SqlParameter("@maopeihao", SqlDbType.NVarChar, 50),
new SqlParameter("@muhao", SqlDbType.NVarChar, 50),
new SqlParameter("@liuchengpiaobianhao", SqlDbType.NVarChar, 50),
new SqlParameter("@banci", SqlDbType.NVarChar, 50),
new SqlParameter("@jihuashengchanshu", SqlDbType.Decimal, 17),
new SqlParameter("@shengchanzongshu", SqlDbType.Decimal, 17),
new SqlParameter("@jishuqishu", SqlDbType.Decimal, 17),
new SqlParameter("@baofeizongshu", SqlDbType.Decimal, 17),
new SqlParameter("@baofeilv", SqlDbType.Decimal, 17),
new SqlParameter("@fanxiuzongshu", SqlDbType.Decimal, 17),
new SqlParameter("@fanxiulv", SqlDbType.Decimal, 17),
new SqlParameter("@xianhao", SqlDbType.NVarChar, 50),
new SqlParameter("@gongxu", SqlDbType.NVarChar, 50),
new SqlParameter("@workshoptype", SqlDbType.Decimal, 17),
new SqlParameter("@gonghao", SqlDbType.NVarChar, 50),
new SqlParameter("@isdel", SqlDbType.Decimal, 17),
new SqlParameter("@yazhuquexian", SqlDbType.Decimal, 17),
new SqlParameter("@cuopifengquexian", SqlDbType.Decimal, 17),
new SqlParameter("@pinjianquexian", SqlDbType.Decimal, 17),
new SqlParameter("@jijiaquexian", SqlDbType.Decimal, 17)
};
parameters[0].Value = model.time;
parameters[1].Value = model.yazhujihao;
parameters[2].Value = model.maopeihao;
parameters[3].Value = model.muhao;
parameters[4].Value = model.liuchengpiaobianhao;
parameters[5].Value = model.banci;
parameters[6].Value = model.jihuashengchanshu;
parameters[7].Value = model.shengchanzongshu;
parameters[8].Value = model.jishuqishu;
parameters[9].Value = model.baofeizongshu;
parameters[10].Value = model.baofeilv;
parameters[11].Value = model.fanxiuzongshu;
parameters[12].Value = model.fanxiulv;
parameters[13].Value = model.xianhao;
parameters[14].Value = model.gongxu;
parameters[15].Value = model.workshoptype;
parameters[16].Value = model.gonghao;
parameters[17].Value = model.isdel;
parameters[18].Value = model.yazhuquexian;
parameters[19].Value = model.cuopifengquexian;
parameters[20].Value = model.pinjianquexian;
parameters[21].Value = model.jijiaquexian;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WorkShopSystem.Model.CommonWorkShopRecord DataRowToModel(DataRow row)
{
WorkShopSystem.Model.CommonWorkShopRecord model = new WorkShopSystem.Model.CommonWorkShopRecord();
if (row != null)
{
if (row["time"] != null && row["time"].ToString() != "")
{
model.time = DateTime.Parse(row["time"].ToString());
}
if (row["yazhujihao"] != null)
{
model.yazhujihao = row["yazhujihao"].ToString();
}
if (row["maopeihao"] != null)
{
model.maopeihao = row["maopeihao"].ToString();
}
if (row["muhao"] != null)
{
model.muhao = row["muhao"].ToString();
}
if (row["liuchengpiaobianhao"] != null)
{
model.liuchengpiaobianhao = row["liuchengpiaobianhao"].ToString();
}
if (row["banci"] != null)
{
model.banci = row["banci"].ToString();
}
if (row["jihuashengchanshu"] != null && row["jihuashengchanshu"].ToString() != "")
{
model.jihuashengchanshu = decimal.Parse(row["jihuashengchanshu"].ToString());
}
if (row["shengchanzongshu"] != null && row["shengchanzongshu"].ToString() != "")
{
model.shengchanzongshu = decimal.Parse(row["shengchanzongshu"].ToString());
}
if (row["jishuqishu"] != null && row["jishuqishu"].ToString() != "")
{
model.jishuqishu = decimal.Parse(row["jishuqishu"].ToString());
}
if (row["baofeizongshu"] != null && row["baofeizongshu"].ToString() != "")
{
model.baofeizongshu = decimal.Parse(row["baofeizongshu"].ToString());
}
if (row["baofeilv"] != null && row["baofeilv"].ToString() != "")
{
model.baofeilv = decimal.Parse(row["baofeilv"].ToString());
}
if (row["fanxiuzongshu"] != null && row["fanxiuzongshu"].ToString() != "")
{
model.fanxiuzongshu = decimal.Parse(row["fanxiuzongshu"].ToString());
}
if (row["fanxiulv"] != null && row["fanxiulv"].ToString() != "")
{
model.fanxiulv = decimal.Parse(row["fanxiulv"].ToString());
}
if (row["xianhao"] != null)
{
model.xianhao = row["xianhao"].ToString();
}
if (row["gongxu"] != null)
{
model.gongxu = row["gongxu"].ToString();
}
if (row["workshoptype"] != null && row["workshoptype"].ToString() != "")
{
model.workshoptype = decimal.Parse(row["workshoptype"].ToString());
}
if (row["gonghao"] != null)
{
model.gonghao = row["gonghao"].ToString();
}
if (row["isdel"] != null && row["isdel"].ToString() != "")
{
model.isdel = int.Parse(row["isdel"].ToString());
}
if (row["yazhuquexian"] != null && row["yazhuquexian"].ToString() != "")
{
model.yazhuquexian = decimal.Parse(row["yazhuquexian"].ToString());
}
if (row["cuopifengquexian"] != null && row["cuopifengquexian"].ToString() != "")
{
model.cuopifengquexian = decimal.Parse(row["cuopifengquexian"].ToString());
}
if (row["pinjianquexian"] != null && row["pinjianquexian"].ToString() != "")
{
model.pinjianquexian = decimal.Parse(row["pinjianquexian"].ToString());
}
if (row["jijiaquexian"] != null && row["jijiaquexian"].ToString() != "")
{
model.jijiaquexian = decimal.Parse(row["jijiaquexian"].ToString());
}
}
return(model);
}
