/// <summary> /// 更新一条数据 /// </summary> public bool Update(WorkShopSystem.Model.FanXiuDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update FanXiuDetail set "); strSql.Append("time=@time,"); strSql.Append("bengliao=@bengliao,"); strSql.Append("fanpen=@fanpen,"); strSql.Append("zhengxing=@zhengxing,"); strSql.Append("beizhu=@beizhu,"); strSql.Append("jinqikoukepeng=@jinqikoukepeng,"); strSql.Append("falanmianhuashang=@falanmianhuashang,"); strSql.Append("pensha=@pensha,"); strSql.Append("kefanxipin=@kefanxipin,"); strSql.Append("kefanfamei=@kefanfamei,"); strSql.Append("xiaoshakongkefanxiu=@xiaoshakongkefanxiu,"); strSql.Append("louqi=@louqi,"); strSql.Append("liuchengpiaobianhao=@liuchengpiaobianhao"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@time", SqlDbType.DateTime), new SqlParameter("@bengliao", SqlDbType.Decimal, 17), new SqlParameter("@fanpen", SqlDbType.Decimal, 17), new SqlParameter("@zhengxing", SqlDbType.Decimal, 17), new SqlParameter("@beizhu", SqlDbType.NVarChar, 50), new SqlParameter("@jinqikoukepeng", SqlDbType.Decimal, 17), new SqlParameter("@falanmianhuashang", SqlDbType.Decimal, 17), new SqlParameter("@pensha", SqlDbType.Decimal, 17), new SqlParameter("@kefanxipin", SqlDbType.Decimal, 17), new SqlParameter("@kefanfamei", SqlDbType.Decimal, 17), new SqlParameter("@xiaoshakongkefanxiu", SqlDbType.Decimal, 17), new SqlParameter("@louqi", SqlDbType.Decimal, 17), new SqlParameter("@liuchengpiaobianhao", SqlDbType.NVarChar, 30) }; parameters[0].Value = model.time; parameters[1].Value = model.bengliao; parameters[2].Value = model.fanpen; parameters[3].Value = model.zhengxing; parameters[4].Value = model.beizhu; parameters[5].Value = model.jinqikoukepeng; parameters[6].Value = model.falanmianhuashang; parameters[7].Value = model.pensha; parameters[8].Value = model.kefanxipin; parameters[9].Value = model.kefanfamei; parameters[10].Value = model.xiaoshakongkefanxiu; parameters[11].Value = model.louqi; parameters[12].Value = model.liuchengpiaobianhao; int rows = SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WorkShopSystem.Model.FanXiuDetail DataRowToModel(DataRow row) { WorkShopSystem.Model.FanXiuDetail model = new WorkShopSystem.Model.FanXiuDetail(); if (row != null) { if (row["time"] != null && row["time"].ToString() != "") { model.time = DateTime.Parse(row["time"].ToString()); } if (row["bengliao"] != null && row["bengliao"].ToString() != "") { model.bengliao = decimal.Parse(row["bengliao"].ToString()); } if (row["fanpen"] != null && row["fanpen"].ToString() != "") { model.fanpen = decimal.Parse(row["fanpen"].ToString()); } if (row["zhengxing"] != null && row["zhengxing"].ToString() != "") { model.zhengxing = decimal.Parse(row["zhengxing"].ToString()); } if (row["beizhu"] != null) { model.beizhu = row["beizhu"].ToString(); } if (row["jinqikoukepeng"] != null && row["jinqikoukepeng"].ToString() != "") { model.jinqikoukepeng = decimal.Parse(row["jinqikoukepeng"].ToString()); } if (row["falanmianhuashang"] != null && row["falanmianhuashang"].ToString() != "") { model.falanmianhuashang = decimal.Parse(row["falanmianhuashang"].ToString()); } if (row["pensha"] != null && row["pensha"].ToString() != "") { model.pensha = decimal.Parse(row["pensha"].ToString()); } if (row["kefanxipin"] != null && row["kefanxipin"].ToString() != "") { model.kefanxipin = decimal.Parse(row["kefanxipin"].ToString()); } if (row["kefanfamei"] != null && row["kefanfamei"].ToString() != "") { model.kefanfamei = decimal.Parse(row["kefanfamei"].ToString()); } if (row["xiaoshakongkefanxiu"] != null && row["xiaoshakongkefanxiu"].ToString() != "") { model.xiaoshakongkefanxiu = decimal.Parse(row["xiaoshakongkefanxiu"].ToString()); } if (row["louqi"] != null && row["louqi"].ToString() != "") { model.louqi = decimal.Parse(row["louqi"].ToString()); } if (row["liuchengpiaobianhao"] != null) { model.liuchengpiaobianhao = row["liuchengpiaobianhao"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WorkShopSystem.Model.FanXiuDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FanXiuDetail("); strSql.Append("time,bengliao,fanpen,zhengxing,beizhu,jinqikoukepeng,falanmianhuashang,pensha,kefanxipin,kefanfamei,xiaoshakongkefanxiu,louqi,liuchengpiaobianhao)"); strSql.Append(" values ("); strSql.Append("@time,@bengliao,@fanpen,@zhengxing,@beizhu,@jinqikoukepeng,@falanmianhuashang,@pensha,@kefanxipin,@kefanfamei,@xiaoshakongkefanxiu,@louqi,@liuchengpiaobianhao)"); SqlParameter[] parameters = { new SqlParameter("@time", SqlDbType.DateTime), new SqlParameter("@bengliao", SqlDbType.Decimal, 17), new SqlParameter("@fanpen", SqlDbType.Decimal, 17), new SqlParameter("@zhengxing", SqlDbType.Decimal, 17), new SqlParameter("@beizhu", SqlDbType.NVarChar, 50), new SqlParameter("@jinqikoukepeng", SqlDbType.Decimal, 17), new SqlParameter("@falanmianhuashang", SqlDbType.Decimal, 17), new SqlParameter("@pensha", SqlDbType.Decimal, 17), new SqlParameter("@kefanxipin", SqlDbType.Decimal, 17), new SqlParameter("@kefanfamei", SqlDbType.Decimal, 17), new SqlParameter("@xiaoshakongkefanxiu", SqlDbType.Decimal, 17), new SqlParameter("@louqi", SqlDbType.Decimal, 17), new SqlParameter("@liuchengpiaobianhao", SqlDbType.NVarChar, 30) }; parameters[0].Value = model.time; parameters[1].Value = model.bengliao; parameters[2].Value = model.fanpen; parameters[3].Value = model.zhengxing; parameters[4].Value = model.beizhu; parameters[5].Value = model.jinqikoukepeng; parameters[6].Value = model.falanmianhuashang; parameters[7].Value = model.pensha; parameters[8].Value = model.kefanxipin; parameters[9].Value = model.kefanfamei; parameters[10].Value = model.xiaoshakongkefanxiu; parameters[11].Value = model.louqi; parameters[12].Value = model.liuchengpiaobianhao; int rows = SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WorkShopSystem.Model.FanXiuDetail GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 time,bengliao,fanpen,zhengxing,beizhu,jinqikoukepeng,falanmianhuashang,pensha,kefanxipin,kefanfamei,xiaoshakongkefanxiu,louqi,liuchengpiaobianhao from FanXiuDetail "); strSql.Append(" where "); SqlParameter[] parameters = { }; WorkShopSystem.Model.FanXiuDetail model = new WorkShopSystem.Model.FanXiuDetail(); DataTable dt = SqlHelper.ExecuteDataTable(strSql.ToString(), parameters); if (dt.Rows.Count > 0) { return(DataRowToModel(dt.Rows[0])); } else { return(null); } }