/// <summary> /// 增加一条数据 /// </summary> public int Add(Hotel_app.Model.Xxfmx_zbmx model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Xxfmx_zbmx("); strSql.Append("yydh,qymc,lsbh,drbh,xfdr,xrbh,xfxr,xftm,xfmx,mxbh,zb_sl,zb_zt,zb_sj,zb_czy,shsc,zb_jjje,zb_Total_cb)"); strSql.Append(" values ("); strSql.Append("@yydh,@qymc,@lsbh,@drbh,@xfdr,@xrbh,@xfxr,@xftm,@xfmx,@mxbh,@zb_sl,@zb_zt,@zb_sj,@zb_czy,@shsc,@zb_jjje,@zb_Total_cb)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@yydh", SqlDbType.VarChar, 50), new SqlParameter("@qymc", SqlDbType.VarChar, 50), new SqlParameter("@lsbh", SqlDbType.VarChar, 100), new SqlParameter("@drbh", SqlDbType.VarChar, 50), new SqlParameter("@xfdr", SqlDbType.VarChar, 50), new SqlParameter("@xrbh", SqlDbType.VarChar, 50), new SqlParameter("@xfxr", SqlDbType.VarChar, 50), new SqlParameter("@xftm", SqlDbType.VarChar, 50), new SqlParameter("@xfmx", SqlDbType.VarChar, 100), new SqlParameter("@mxbh", SqlDbType.VarChar, 50), new SqlParameter("@zb_sl", SqlDbType.Decimal, 9), new SqlParameter("@zb_zt", SqlDbType.VarChar, 100), new SqlParameter("@zb_sj", SqlDbType.DateTime), new SqlParameter("@zb_czy", SqlDbType.VarChar, 50), new SqlParameter("@shsc", SqlDbType.Bit, 1), new SqlParameter("@zb_jjje", SqlDbType.Decimal, 9), new SqlParameter("@zb_Total_cb", SqlDbType.Decimal, 9) }; parameters[0].Value = model.yydh; parameters[1].Value = model.qymc; parameters[2].Value = model.lsbh; parameters[3].Value = model.drbh; parameters[4].Value = model.xfdr; parameters[5].Value = model.xrbh; parameters[6].Value = model.xfxr; parameters[7].Value = model.xftm; parameters[8].Value = model.xfmx; parameters[9].Value = model.mxbh; parameters[10].Value = model.zb_sl; parameters[11].Value = model.zb_zt; parameters[12].Value = model.zb_sj; parameters[13].Value = model.zb_czy; parameters[14].Value = model.shsc; parameters[15].Value = model.zb_jjje; parameters[16].Value = model.zb_Total_cb; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hotel_app.Model.Xxfmx_zbmx model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Xxfmx_zbmx set "); strSql.Append("yydh=@yydh,"); strSql.Append("qymc=@qymc,"); strSql.Append("lsbh=@lsbh,"); strSql.Append("drbh=@drbh,"); strSql.Append("xfdr=@xfdr,"); strSql.Append("xrbh=@xrbh,"); strSql.Append("xfxr=@xfxr,"); strSql.Append("xftm=@xftm,"); strSql.Append("xfmx=@xfmx,"); strSql.Append("mxbh=@mxbh,"); strSql.Append("zb_sl=@zb_sl,"); strSql.Append("zb_zt=@zb_zt,"); strSql.Append("zb_sj=@zb_sj,"); strSql.Append("zb_czy=@zb_czy,"); strSql.Append("shsc=@shsc,"); strSql.Append("zb_jjje=@zb_jjje,"); strSql.Append("zb_Total_cb=@zb_Total_cb"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@yydh", SqlDbType.VarChar, 50), new SqlParameter("@qymc", SqlDbType.VarChar, 50), new SqlParameter("@lsbh", SqlDbType.VarChar, 100), new SqlParameter("@drbh", SqlDbType.VarChar, 50), new SqlParameter("@xfdr", SqlDbType.VarChar, 50), new SqlParameter("@xrbh", SqlDbType.VarChar, 50), new SqlParameter("@xfxr", SqlDbType.VarChar, 50), new SqlParameter("@xftm", SqlDbType.VarChar, 50), new SqlParameter("@xfmx", SqlDbType.VarChar, 100), new SqlParameter("@mxbh", SqlDbType.VarChar, 50), new SqlParameter("@zb_sl", SqlDbType.Decimal, 9), new SqlParameter("@zb_zt", SqlDbType.VarChar, 100), new SqlParameter("@zb_sj", SqlDbType.DateTime), new SqlParameter("@zb_czy", SqlDbType.VarChar, 50), new SqlParameter("@shsc", SqlDbType.Bit, 1), new SqlParameter("@zb_jjje", SqlDbType.Decimal, 9), new SqlParameter("@zb_Total_cb", SqlDbType.Decimal, 9), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.yydh; parameters[1].Value = model.qymc; parameters[2].Value = model.lsbh; parameters[3].Value = model.drbh; parameters[4].Value = model.xfdr; parameters[5].Value = model.xrbh; parameters[6].Value = model.xfxr; parameters[7].Value = model.xftm; parameters[8].Value = model.xfmx; parameters[9].Value = model.mxbh; parameters[10].Value = model.zb_sl; parameters[11].Value = model.zb_zt; parameters[12].Value = model.zb_sj; parameters[13].Value = model.zb_czy; parameters[14].Value = model.shsc; parameters[15].Value = model.zb_jjje; parameters[16].Value = model.zb_Total_cb; parameters[17].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Hotel_app.Model.Xxfmx_zbmx GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,yydh,qymc,lsbh,drbh,xfdr,xrbh,xfxr,xftm,xfmx,mxbh,zb_sl,zb_zt,zb_sj,zb_czy,shsc,zb_jjje,zb_Total_cb from Xxfmx_zbmx "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Hotel_app.Model.Xxfmx_zbmx model = new Hotel_app.Model.Xxfmx_zbmx(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["yydh"] != null && ds.Tables[0].Rows[0]["yydh"].ToString() != "") { model.yydh = ds.Tables[0].Rows[0]["yydh"].ToString(); } if (ds.Tables[0].Rows[0]["qymc"] != null && ds.Tables[0].Rows[0]["qymc"].ToString() != "") { model.qymc = ds.Tables[0].Rows[0]["qymc"].ToString(); } if (ds.Tables[0].Rows[0]["lsbh"] != null && ds.Tables[0].Rows[0]["lsbh"].ToString() != "") { model.lsbh = ds.Tables[0].Rows[0]["lsbh"].ToString(); } if (ds.Tables[0].Rows[0]["drbh"] != null && ds.Tables[0].Rows[0]["drbh"].ToString() != "") { model.drbh = ds.Tables[0].Rows[0]["drbh"].ToString(); } if (ds.Tables[0].Rows[0]["xfdr"] != null && ds.Tables[0].Rows[0]["xfdr"].ToString() != "") { model.xfdr = ds.Tables[0].Rows[0]["xfdr"].ToString(); } if (ds.Tables[0].Rows[0]["xrbh"] != null && ds.Tables[0].Rows[0]["xrbh"].ToString() != "") { model.xrbh = ds.Tables[0].Rows[0]["xrbh"].ToString(); } if (ds.Tables[0].Rows[0]["xfxr"] != null && ds.Tables[0].Rows[0]["xfxr"].ToString() != "") { model.xfxr = ds.Tables[0].Rows[0]["xfxr"].ToString(); } if (ds.Tables[0].Rows[0]["xftm"] != null && ds.Tables[0].Rows[0]["xftm"].ToString() != "") { model.xftm = ds.Tables[0].Rows[0]["xftm"].ToString(); } if (ds.Tables[0].Rows[0]["xfmx"] != null && ds.Tables[0].Rows[0]["xfmx"].ToString() != "") { model.xfmx = ds.Tables[0].Rows[0]["xfmx"].ToString(); } if (ds.Tables[0].Rows[0]["mxbh"] != null && ds.Tables[0].Rows[0]["mxbh"].ToString() != "") { model.mxbh = ds.Tables[0].Rows[0]["mxbh"].ToString(); } if (ds.Tables[0].Rows[0]["zb_sl"] != null && ds.Tables[0].Rows[0]["zb_sl"].ToString() != "") { model.zb_sl = decimal.Parse(ds.Tables[0].Rows[0]["zb_sl"].ToString()); } if (ds.Tables[0].Rows[0]["zb_zt"] != null && ds.Tables[0].Rows[0]["zb_zt"].ToString() != "") { model.zb_zt = ds.Tables[0].Rows[0]["zb_zt"].ToString(); } if (ds.Tables[0].Rows[0]["zb_sj"] != null && ds.Tables[0].Rows[0]["zb_sj"].ToString() != "") { model.zb_sj = DateTime.Parse(ds.Tables[0].Rows[0]["zb_sj"].ToString()); } if (ds.Tables[0].Rows[0]["zb_czy"] != null && ds.Tables[0].Rows[0]["zb_czy"].ToString() != "") { model.zb_czy = ds.Tables[0].Rows[0]["zb_czy"].ToString(); } if (ds.Tables[0].Rows[0]["shsc"] != null && ds.Tables[0].Rows[0]["shsc"].ToString() != "") { if ((ds.Tables[0].Rows[0]["shsc"].ToString() == "1") || (ds.Tables[0].Rows[0]["shsc"].ToString().ToLower() == "true")) { model.shsc = true; } else { model.shsc = false; } } if (ds.Tables[0].Rows[0]["zb_jjje"] != null && ds.Tables[0].Rows[0]["zb_jjje"].ToString() != "") { model.zb_jjje = decimal.Parse(ds.Tables[0].Rows[0]["zb_jjje"].ToString()); } if (ds.Tables[0].Rows[0]["zb_Total_cb"] != null && ds.Tables[0].Rows[0]["zb_Total_cb"].ToString() != "") { model.zb_Total_cb = decimal.Parse(ds.Tables[0].Rows[0]["zb_Total_cb"].ToString()); } return(model); } else { return(null); } }
//id,yydh,qymc,lsbh,lksj,czsj,czy,bz,drbh,xfdr,xrbh,xfmx,mxbh,zb_sl,shsc //id,yydh,qymc,lsbh,lksj,czsj,czy,bz,drbh,xfdr,xrbh,xfxr,xfmx,mxbh,zb_sl,shsc public string Xxfmx_zbmx_add_edit(string id, string yydh, string qymc, string lsbh, string drbh, string xfdr, string xrbh, string xfxr, string xfmx, string mxbh, string xftm, string zb_sj, string zb_czy, string zb_sl, string zb_zt, string add_edit_delete, string xxzs, string dj) { //id,yydh,qymc,lsbh,drbh,xfdr,xrbh,xfxr,xftm,xfmx,mxbh,zb_sl,zb_zt,zb_sj,zb_czy,shsc string s = common_file.common_app.get_failure; BLL.Xxfmx_zbmx B_Xxfmx_zbmx = new Hotel_app.BLL.Xxfmx_zbmx(); Model.Xxfmx_zbmx M_Xxfmx_zbmx = new Hotel_app.Model.Xxfmx_zbmx(); decimal strzbsl = Get_lksl(mxbh, zb_sl, lsbh); string strzbzt = common_file.common_app.zb_zt_kj; if (strzbsl > 0) { strzbzt = common_file.common_app.zb_zt_zj; } if (xxzs == common_file.common_app.xxzs_xxvalue) { } if (xxzs == common_file.common_app.xxzs_zsvalue) { } if (add_edit_delete == common_file.common_app.get_add) { M_Xxfmx_zbmx.yydh = yydh; M_Xxfmx_zbmx.qymc = qymc; M_Xxfmx_zbmx.lsbh = lsbh; M_Xxfmx_zbmx.drbh = drbh; M_Xxfmx_zbmx.xfdr = xfdr; M_Xxfmx_zbmx.xrbh = xrbh; M_Xxfmx_zbmx.mxbh = mxbh; M_Xxfmx_zbmx.xfmx = xfmx; M_Xxfmx_zbmx.zb_czy = zb_czy; M_Xxfmx_zbmx.zb_sj = Convert.ToDateTime(zb_sj); M_Xxfmx_zbmx.zb_sl = strzbsl; M_Xxfmx_zbmx.zb_zt = strzbzt; M_Xxfmx_zbmx.xfxr = xfxr; M_Xxfmx_zbmx.xftm = xftm; decimal dj_0 = 0; try { dj_0 = decimal.Parse(dj); } catch { dj_0 = 0; } M_Xxfmx_zbmx.zb_jjje = dj_0; M_Xxfmx_zbmx.zb_Total_cb = strzbsl * dj_0; if (B_Xxfmx_zbmx.Add(M_Xxfmx_zbmx) > 0) { s = common_file.common_app.get_suc; } } else { if (add_edit_delete == common_file.common_app.get_edit) { M_Xxfmx_zbmx = B_Xxfmx_zbmx.GetModel(Convert.ToInt32(id)); M_Xxfmx_zbmx.yydh = yydh; M_Xxfmx_zbmx.qymc = qymc; M_Xxfmx_zbmx.lsbh = lsbh; M_Xxfmx_zbmx.drbh = drbh; M_Xxfmx_zbmx.xfdr = xfdr; M_Xxfmx_zbmx.xrbh = xrbh; M_Xxfmx_zbmx.mxbh = mxbh; M_Xxfmx_zbmx.xfmx = xfmx; M_Xxfmx_zbmx.zb_czy = zb_czy; M_Xxfmx_zbmx.zb_sj = Convert.ToDateTime(zb_sj); M_Xxfmx_zbmx.zb_sl = strzbsl; M_Xxfmx_zbmx.zb_zt = strzbzt; M_Xxfmx_zbmx.xfxr = xfxr; M_Xxfmx_zbmx.xftm = xftm; M_Xxfmx_zbmx.id = int.Parse(id); if (B_Xxfmx_zbmx.Update(M_Xxfmx_zbmx)) { s = common_file.common_app.get_suc; } } else if (add_edit_delete == common_file.common_app.get_delete) { if (id != "") { //Update_xfmx_kcsl_add(mxbh, Convert.ToDecimal(zb_sl)); B_Xxfmx_zbmx.Delete(Convert.ToInt32(id)); s = common_file.common_app.get_suc; } } } return(s); }