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