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