/// <summary> /// 获取门店信息 /// </summary> /// <param name="siteId">门店编号</param> /// <returns>门店信息对象</returns> public virtual TBSite Get(string siteId) { TBSite tbSite = null; try { string strSQL = "select * from TBSite where siteId=@siteId"; Param param = new Param(); param.Clear(); param.Add("@siteId", siteId); db.Open(); ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param); if (dr.Read()) { tbSite = ReadData(dr); } dr.Close(); } catch (Exception e) { throw e; } finally { db.Close(); } return(tbSite); }
/// <summary> /// 加载指定快开厅信息 /// <param name="siteId">快开厅编号</param> /// </summary> public void Load(string siteId) { try { TBSite tbSite = tbSiteDAO.Get(siteId); tbSite.status = "1".Equals(tbSite.status) ? "on" : "off"; WebJson.ToJson(context, tbSite); } catch (Exception e) { Message.error(context, e.Message); } }
/// <summary> /// 获取快开厅信息 /// <param name="siteId">快开厅编号</param> /// </summary> /// <returns>快开厅信息对象</returns> public TBSite Get(string siteId) { TBSite tbSite = new TBSite(); try { tbSite = tbSiteDAO.Get(siteId); } catch (Exception e) { Message.error(context, e.Message); } return(tbSite); }
/// <summary> /// 修改 /// </summary> /// <param name="user">用户对象</param> public void Audit(TBSite tbSite) { try { tbSiteDAO.Audit(tbSite); Message.success(context, "审核操作成功"); loginSession.Log(tbSite.siteName + "[" + tbSite.siteId + "]快开厅审核操作成功"); } catch (Exception e) { Message.error(context, "快开厅审核失败"); loginSession.Log(e.Message); } }
/// <summary> /// 修改门店信息 /// </summary> /// <param name="tbSite">门店信息</param> public virtual void Edit(TBSite tbSite) { try { db.Open(); Edit(db, tbSite); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 增加快开厅信息 /// <param name="tbSite">快开厅信息</param> /// </summary> public void Add(TBSite tbSite) { try { db.Open(); Add(db, tbSite); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 读取快开厅信息信息 /// <param name="dr">记录指针</param> /// </summary> /// <returns>快开厅信息对象</returns> private TBSite ReadData(ComDataReader dr) { TBSite tbSite = new TBSite(); tbSite.siteId = dr["siteId"].ToString(); //快开厅编号 tbSite.agentId = dr["agentId"].ToString(); //代理商编号 tbSite.siteName = dr["siteName"].ToString(); //快开厅名称 tbSite.address = dr["address"].ToString(); //详细地址 tbSite.contact = dr["contact"].ToString(); //联系人 tbSite.telephone = dr["telephone"].ToString(); //手机号码 tbSite.auditStatus = dr["auditStatus"].ToString(); //审批状态 tbSite.status = dr["status"].ToString(); //使用状态 tbSite.remark = dr["remark"].ToString(); //备注说明 tbSite.specialArea = double.Parse(dr["specialArea"].ToString()); //专营面积 return(tbSite); }
/// <summary> /// 修改快开厅信息 /// <param name="data">数据库连接</param> /// <param name="tbSite">快开厅信息</param> /// </summary> public void Edit(DataAccess data, TBSite tbSite) { string strSQL = "update TBSite set agentId=:agentId,siteName=:siteName,address=:address,contact=:contact,telephone=:telephone,status=:status,auditStatus=:auditStatus,remark=:remark where siteId=:siteId"; Param param = new Param(); param.Clear(); param.Add(":agentId", tbSite.agentId); //代理商编号 param.Add(":siteName", tbSite.siteName); //快开厅名称 param.Add(":address", tbSite.address); //详细地址 param.Add(":contact", tbSite.contact); //联系人 param.Add(":telephone", tbSite.telephone); //手机号码 param.Add(":status", tbSite.status); //使用状态 param.Add(":auditStatus", tbSite.auditStatus); //审核状态 param.Add(":remark", tbSite.remark); //备注说明 param.Add(":siteId", tbSite.siteId); //快开厅编号 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
private DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接 #region 新增代码 /// <summary> /// 增加快开厅信息 /// <param name="data">数据库连接</param> /// <param name="tbSite">快开厅信息</param> /// </summary> public void Add(DataAccess data, TBSite tbSite) { string strSQL = "insert into TBSite (siteId,agentId,siteName,address,contact,telephone,auditStatus,status,remark) values (:siteId,:agentId,:siteName,:address,:contact,:telephone,:auditStatus,:status,:remark)"; Param param = new Param(); param.Clear(); param.Add(":siteId", tbSite.siteId); //快开厅编号 param.Add(":agentId", tbSite.agentId); //代理商编号 param.Add(":siteName", tbSite.siteName); //快开厅名称 param.Add(":address", tbSite.address); //详细地址 param.Add(":contact", tbSite.contact); //联系人 param.Add(":telephone", tbSite.telephone); //手机号码 param.Add(":auditStatus", tbSite.auditStatus); //审批状态 param.Add(":status", "0"); //使用状态 param.Add(":remark", tbSite.remark); //备注说明 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 修改快开厅信息 /// <param name="data">数据库连接</param> /// <param name="tbSite">快开厅信息</param> /// </summary> public override void Edit(DataAccess data, TBSite tbSite) { string strSQL = "update TBSite set siteName=@siteName,address=@address,contact=@contact,pointRule=@pointRule,telephone=@telephone,status=@status,auditStatus=@auditStatus,specialArea=@specialArea,remark=@remark where siteId=@siteId"; Param param = new Param(); param.Clear(); param.Add("@siteName", tbSite.siteName); //快开厅名称 param.Add("@address", tbSite.address); //详细地址 param.Add("@contact", tbSite.contact); //联系人 param.Add("@pointRule", tbSite.pointRule); //积分/元 param.Add("@telephone", tbSite.telephone); //手机号码 param.Add("@status", tbSite.status); //使用状态 param.Add("@auditStatus", tbSite.auditStatus); //审核状态 param.Add("@remark", tbSite.remark); //备注说明 param.Add("@siteId", tbSite.siteId); //快开厅编号 param.Add("@specialArea", tbSite.specialArea); //专营面积 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 修改门店信息 /// </summary> /// <param name="data">数据库连接</param> /// <param name="tbSite">门店信息</param> public virtual void Edit(DataAccess data, TBSite tbSite) { string strSQL = "update TBSite set agentId=@agentId,siteName=@siteName,specialArea=@specialArea,address=@address,contact=@contact,telephone=@telephone,auditStatus=@auditStatus,status=@status,remark=@remark,pointRule=@pointRule where siteId=@siteId"; Param param = new Param(); param.Clear(); param.Add("@agentId", tbSite.agentId); //代理商编号 param.Add("@siteName", tbSite.siteName); //门店名称 param.Add("@specialArea", tbSite.specialArea); //专营面积 param.Add("@address", tbSite.address); //详细地址 param.Add("@contact", tbSite.contact); //联系人 param.Add("@telephone", tbSite.telephone); //手机号码 param.Add("@auditStatus", tbSite.auditStatus); //审批状态 param.Add("@status", tbSite.status); //使用状态 param.Add("@remark", tbSite.remark); //备注说明 param.Add("@pointRule", tbSite.pointRule); //积分规则 param.Add("@siteId", tbSite.siteId); //门店编号 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 增加快开厅信息 /// <param name="data">数据库连接</param> /// <param name="tbSite">快开厅信息</param> /// </summary> public override void Add(DataAccess data, TBSite tbSite) { string strSQL = "insert into TBSite (siteId,agentId,siteName,address,contact,pointRule,telephone,auditStatus,status,specialArea,remark) values (@siteId,@agentId,@siteName,@address,@contact,@pointRule,@telephone,@auditStatus,@status,@specialArea,@remark)"; Param param = new Param(); param.Clear(); param.Add("@siteId", tbSite.siteId); //快开厅编号 param.Add("@agentId", tbSite.agentId); //代理商编号 param.Add("@siteName", tbSite.siteName); //快开厅名称 param.Add("@address", tbSite.address); //详细地址 param.Add("@contact", tbSite.contact); //联系人 param.Add("@pointRule", tbSite.pointRule); //积分/元 param.Add("@telephone", tbSite.telephone); //手机号码 param.Add("@auditStatus", tbSite.auditStatus); //审批状态 param.Add("@status", "0"); //使用状态 param.Add("@specialArea", tbSite.specialArea); //专营面积 param.Add("@remark", tbSite.remark); //备注说明 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 读取门店信息信息 /// </summary> /// <param name="dr">记录指针</param> /// <returns>门店信息对象</returns> protected virtual TBSite ReadData(ComDataReader dr) { TBSite tbSite = new TBSite(); tbSite.siteId = dr["siteId"].ToString(); //门店编号 tbSite.agentId = dr["agentId"].ToString(); //代理商编号 tbSite.siteName = dr["siteName"].ToString(); //门店名称 tbSite.specialArea = double.Parse(dr["specialArea"].ToString()); //专营面积 tbSite.address = dr["address"].ToString(); //详细地址 tbSite.contact = dr["contact"].ToString(); //联系人 tbSite.telephone = dr["telephone"].ToString(); //手机号码 tbSite.auditStatus = dr["auditStatus"].ToString(); //审批状态 tbSite.status = dr["status"].ToString(); //使用状态 tbSite.remark = dr["remark"].ToString(); //备注说明 tbSite.pointRule = int.Parse(dr["pointRule"].ToString()); //积分规则 tbSite.description = dr["description"].ToString(); // tbSite.picture = dr["picture"].ToString(); //门店图片 tbSite.servicesPhone = dr["servicesPhone"].ToString(); //门店图片 return(tbSite); }
/// <summary> /// 增加快开厅信息 /// <param name="tbSite">快开厅信息</param> /// </summary> public void Add(TBSite tbSite) { //判断名称是否重复 if (tbSiteDAO.Exist("siteName", tbSite.siteName)) { Message.error(context, "名称重复请重新输入!"); return; } try { tbSite.siteId = commonDao.GetMaxNo("TBSite", "", 6); tbSite.status = tbSite.status == null ? "0" : "1"; tbSiteDAO.Add(tbSite); Message.success(context, "快开厅信息增加成功"); loginSession.Log(tbSite.siteName + "快开厅信息增加成功"); } catch (Exception e) { Message.error(context, "快开厅信息增加失败"); loginSession.Log(e.Message); } }
/// <summary> /// 修改快开厅信息 /// <param name="tbSite">快开厅信息</param> /// </summary> public void Edit(TBSite tbSite) { //判断是否帐号重复 List <TBSite> list = tbSiteDAO.GetList("siteName", tbSite.siteName); if (list.Count > 0 && !tbSite.siteId.Equals(list[0].siteId)) { Message.error(context, "名称重复请重新输入!"); return; } try { tbSite.status = tbSite.status == null ? "0" : "1"; tbSiteDAO.Edit(tbSite); Message.success(context, "快开厅信息修改成功"); loginSession.Log(tbSite.siteName + "[" + tbSite.siteId + "]快开厅信息修改成功"); } catch (Exception e) { Message.error(context, "快开厅信息修改失败"); loginSession.Log(e.Message); } }
/// <summary> /// 审核修改审核状态 /// </summary> /// <param name="tbSite"></param> public void Audit(TBSite tbSite) { string strSQL = "update TBSite set auditStatus=@auditStatus,remark=@remark,status=@status where siteId =@siteId"; Param param = new Param(); param.Clear(); param.Add("@siteId", tbSite.siteId); param.Add("@auditStatus", tbSite.auditStatus); param.Add("@status", tbSite.status); param.Add("@remark", tbSite.remark); try { db.Open(); db.ExecuteNonQuery(CommandType.Text, strSQL, param); } catch (Exception e) { throw e; } finally { db.Close(); } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "SiteOam"); if (!loginUser.Pass)//权限验证 { return; } SiteBLL bll = new SiteBLL(context, loginUser); if (context.Request["action"] == "gridLoad") { //加载DataGrid int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); string siteId = context.Request["siteId"]; string siteName = context.Request["siteName"]; string auditStatus = context.Request["auditStatus"]; bll.LoadGrid(page, rows, siteId, siteName, auditStatus); } else if (context.Request["action"] == "agentListLoad") { //加载代理商列表 bll.AgentCombobox(); } else if (context.Request["action"] == "auditListLoad") { //加载审核状态列表 bll.AuditCombobox(); } else if (context.Request["action"] == "load") { //加载信息 bll.Load(context.Request["siteId"]); } else if (context.Request["action"] == "add") { //增加 TBSite tbSite = new TBSite(); tbSite.siteId = context.Request["siteId"]; tbSite.siteName = context.Request["siteName"]; tbSite.agentId = context.Request["agentId"]; tbSite.contact = context.Request["contact"]; tbSite.address = context.Request["address"]; tbSite.telephone = context.Request["telephone"]; tbSite.status = "0"; tbSite.auditStatus = ((int)AuditStauts.NotAudit).ToString(); tbSite.remark = context.Request["remark"]; bll.Add(tbSite); } else if (context.Request["action"] == "edit") { //修改 TBSite tbSite = new TBSite(); tbSite.siteId = context.Request["siteId"]; tbSite.siteName = context.Request["siteName"]; tbSite.agentId = context.Request["agentId"]; tbSite.contact = context.Request["contact"]; tbSite.address = context.Request["address"]; tbSite.telephone = context.Request["telephone"]; tbSite.status = context.Request["status"]; tbSite.auditStatus = ((int)AuditStauts.AuditSucces).ToString(); tbSite.remark = context.Request["remark"]; bll.Edit(tbSite); } else if (context.Request["action"] == "audit") { //审核 TBSite tbSite = new TBSite(); tbSite.siteId = context.Request["siteId"]; tbSite.auditStatus = context.Request["auditStatus"]; if (tbSite.auditStatus == ((int)AuditStauts.AuditSucces).ToString()) { tbSite.status = "1"; } else { tbSite.status = "0"; } tbSite.remark = context.Request["remark"]; bll.Audit(tbSite); } else if (context.Request["action"] == "delete") { //删除 string siteId = context.Request["siteId"]; bll.Delete(siteId); } } catch (Exception e) { Message.error(context, e.Message); } }