/// <summary> /// 增加一条数据 /// </summary> public int Add(Hotel_app.Model.Xxfmx_lkmx model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Xxfmx_lkmx("); strSql.Append("yydh,qymc,lsbh,lksj,czsj,czy,bz,drbh,xfdr,xrbh,xfxr,xftm,xfmx,mxbh,xfsl,shsc,jjdj,Total_cb)"); strSql.Append(" values ("); strSql.Append("@yydh,@qymc,@lsbh,@lksj,@czsj,@czy,@bz,@drbh,@xfdr,@xrbh,@xfxr,@xftm,@xfmx,@mxbh,@xfsl,@shsc,@jjdj,@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, 50), new SqlParameter("@lksj", SqlDbType.DateTime), new SqlParameter("@czsj", SqlDbType.DateTime), new SqlParameter("@czy", SqlDbType.VarChar, 50), new SqlParameter("@bz", SqlDbType.VarChar, 250), 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("@xfsl", SqlDbType.Decimal, 9), new SqlParameter("@shsc", SqlDbType.Bit, 1), new SqlParameter("@jjdj", SqlDbType.Decimal, 5), new SqlParameter("@Total_cb", SqlDbType.Decimal, 5) }; parameters[0].Value = model.yydh; parameters[1].Value = model.qymc; parameters[2].Value = model.lsbh; parameters[3].Value = model.lksj; parameters[4].Value = model.czsj; parameters[5].Value = model.czy; parameters[6].Value = model.bz; parameters[7].Value = model.drbh; parameters[8].Value = model.xfdr; parameters[9].Value = model.xrbh; parameters[10].Value = model.xfxr; parameters[11].Value = model.xftm; parameters[12].Value = model.xfmx; parameters[13].Value = model.mxbh; parameters[14].Value = model.xfsl; parameters[15].Value = model.shsc; parameters[16].Value = model.jjdj; parameters[17].Value = model.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_lkmx model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Xxfmx_lkmx set "); strSql.Append("yydh=@yydh,"); strSql.Append("qymc=@qymc,"); strSql.Append("lsbh=@lsbh,"); strSql.Append("lksj=@lksj,"); strSql.Append("czsj=@czsj,"); strSql.Append("czy=@czy,"); strSql.Append("bz=@bz,"); 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("xfsl=@xfsl,"); strSql.Append("shsc=@shsc,"); strSql.Append("jjdj=@jjdj,"); strSql.Append("Total_cb=@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, 50), new SqlParameter("@lksj", SqlDbType.DateTime), new SqlParameter("@czsj", SqlDbType.DateTime), new SqlParameter("@czy", SqlDbType.VarChar, 50), new SqlParameter("@bz", SqlDbType.VarChar, 250), 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("@xfsl", SqlDbType.Decimal, 9), new SqlParameter("@shsc", SqlDbType.Bit, 1), new SqlParameter("@jjdj", SqlDbType.Decimal, 5), new SqlParameter("@Total_cb", SqlDbType.Decimal, 5), 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.lksj; parameters[4].Value = model.czsj; parameters[5].Value = model.czy; parameters[6].Value = model.bz; parameters[7].Value = model.drbh; parameters[8].Value = model.xfdr; parameters[9].Value = model.xrbh; parameters[10].Value = model.xfxr; parameters[11].Value = model.xftm; parameters[12].Value = model.xfmx; parameters[13].Value = model.mxbh; parameters[14].Value = model.xfsl; parameters[15].Value = model.shsc; parameters[16].Value = model.jjdj; parameters[17].Value = model.Total_cb; parameters[18].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_lkmx GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,yydh,qymc,lsbh,lksj,czsj,czy,bz,drbh,xfdr,xrbh,xfxr,xftm,xfmx,mxbh,xfsl,shsc,jjdj,Total_cb from Xxfmx_lkmx "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Hotel_app.Model.Xxfmx_lkmx model = new Hotel_app.Model.Xxfmx_lkmx(); 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]["lksj"] != null && ds.Tables[0].Rows[0]["lksj"].ToString() != "") { model.lksj = DateTime.Parse(ds.Tables[0].Rows[0]["lksj"].ToString()); } if (ds.Tables[0].Rows[0]["czsj"] != null && ds.Tables[0].Rows[0]["czsj"].ToString() != "") { model.czsj = DateTime.Parse(ds.Tables[0].Rows[0]["czsj"].ToString()); } if (ds.Tables[0].Rows[0]["czy"] != null && ds.Tables[0].Rows[0]["czy"].ToString() != "") { model.czy = ds.Tables[0].Rows[0]["czy"].ToString(); } if (ds.Tables[0].Rows[0]["bz"] != null && ds.Tables[0].Rows[0]["bz"].ToString() != "") { model.bz = ds.Tables[0].Rows[0]["bz"].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]["xfsl"] != null && ds.Tables[0].Rows[0]["xfsl"].ToString() != "") { model.xfsl = decimal.Parse(ds.Tables[0].Rows[0]["xfsl"].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]["jjdj"] != null && ds.Tables[0].Rows[0]["jjdj"].ToString() != "") { model.jjdj = decimal.Parse(ds.Tables[0].Rows[0]["jjdj"].ToString()); } if (ds.Tables[0].Rows[0]["Total_cb"] != null && ds.Tables[0].Rows[0]["Total_cb"].ToString() != "") { model.Total_cb = decimal.Parse(ds.Tables[0].Rows[0]["Total_cb"].ToString()); } return(model); } else { return(null); } }
//id,yydh,qymc,lsbh,lksj,czsj,czy,bz,drbh,xfdr,xrbh,xfmx,mxbh,xfsl,shsc //id,yydh,qymc,lsbh,lksj,czsj,czy,bz,drbh,xfdr,xrbh,xfxr,xfmx,mxbh,xfsl,shsc public string Xxfmx_lkmx_add_edit(string id, string yydh, string qymc, string lsbh, string lksj, string czsj, string czy, string bz, string drbh, string xfdr, string xrbh, string xfxr, string xfmx, string mxbh, string xfsl, string xftm, string add_edit_delete, string xxzs, string dj) { string s = common_file.common_app.get_failure; BLL.Xxfmx_lkmx B_Xxfmx_lkmx = new Hotel_app.BLL.Xxfmx_lkmx(); Model.Xxfmx_lkmx M_Xxfmx_lkmx = new Hotel_app.Model.Xxfmx_lkmx(); 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_lkmx.yydh = yydh; M_Xxfmx_lkmx.qymc = qymc; M_Xxfmx_lkmx.drbh = drbh; M_Xxfmx_lkmx.xfdr = xfdr; M_Xxfmx_lkmx.xrbh = xrbh; M_Xxfmx_lkmx.mxbh = mxbh; M_Xxfmx_lkmx.xfmx = xfmx; M_Xxfmx_lkmx.bz = bz; M_Xxfmx_lkmx.czsj = Convert.ToDateTime(czsj); M_Xxfmx_lkmx.czy = czy; M_Xxfmx_lkmx.lksj = Convert.ToDateTime(lksj); M_Xxfmx_lkmx.lsbh = lsbh; M_Xxfmx_lkmx.xfsl = Get_lksl(mxbh, xfsl, lsbh); M_Xxfmx_lkmx.xfxr = xfxr; M_Xxfmx_lkmx.xftm = xftm; decimal dj_0 = 0; try { dj_0 = decimal.Parse(dj); } catch { dj_0 = 0; } M_Xxfmx_lkmx.jjdj = dj_0; M_Xxfmx_lkmx.Total_cb = Get_lksl(mxbh, xfsl, lsbh) * dj_0; if (B_Xxfmx_lkmx.Add(M_Xxfmx_lkmx) > 0) { s = common_file.common_app.get_suc; } } else { if (add_edit_delete == common_file.common_app.get_edit) { M_Xxfmx_lkmx = B_Xxfmx_lkmx.GetModel(Convert.ToInt32(id)); M_Xxfmx_lkmx.yydh = yydh; M_Xxfmx_lkmx.qymc = qymc; M_Xxfmx_lkmx.drbh = drbh; M_Xxfmx_lkmx.xfdr = xfdr; M_Xxfmx_lkmx.xrbh = xrbh; M_Xxfmx_lkmx.mxbh = mxbh; M_Xxfmx_lkmx.xfmx = xfmx; M_Xxfmx_lkmx.bz = bz; M_Xxfmx_lkmx.czsj = Convert.ToDateTime(czsj); M_Xxfmx_lkmx.czy = czy; M_Xxfmx_lkmx.lksj = Convert.ToDateTime(lksj); M_Xxfmx_lkmx.lsbh = lsbh; M_Xxfmx_lkmx.xfsl = decimal.Parse(xfsl);// Get_lksl(mxbh, xfsl, lsbh); M_Xxfmx_lkmx.xfxr = xfxr; M_Xxfmx_lkmx.xftm = xftm; M_Xxfmx_lkmx.id = int.Parse(id); if (B_Xxfmx_lkmx.Update(M_Xxfmx_lkmx)) { 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(xfsl)); B_Xxfmx_lkmx.Delete(Convert.ToInt32(id)); s = common_file.common_app.get_suc; } } } return(s); }