public HoneyWell.Model.Sys_Area SetObjectValue()
{
string tableName = "Sys_Area";
string showField = " top 1 ID";
string strWhere = " and AreaCode='" + nodeValue + "'";
DataTable dt = new BLL.Sys_Public().SelectData(showField, tableName, strWhere).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
nodeId = Utils.ToInt(dt.Rows[0]["ID"].ToString());
}
HoneyWell.Model.Sys_Area area = new HoneyWell.Model.Sys_Area();
area.ID = nodeId;
area.AreaCode = txt_ClassCode.Value.Trim();
area.AreaName = txt_ClassName.Value.Trim();
area.ParentAreaCode = h_ParentCode.Value;
area.AreaLevel = Utils.ToInt(h_ClassLevel.Value);
area.AreaOrder = Utils.ToInt(txt_ClassOrder.Value.Trim());
area.KeyWord = txt_KeyWord.Value.Trim();
area.ModifyUser = GetUserName();
area.ModifyTime = DateTime.Now;
area.MoreCol1 = "";
area.MoreCol2 = "";
return(area);
}
void Sys_Product(HttpContext context)
{
int TCode = Utils.ToInt(StringHelper.NullToStr(context.Request["TCode"]));
int TLevel = Utils.ToInt(StringHelper.NullToStr(context.Request["TLevel"]));
StringBuilder sbType = new StringBuilder();
DataTable dt = new BLL.Sys_Public().SelectData("ID,TName", "Sys_Type", "and TLevel=1 and TCode=" + TCode + " Order by TOrder ").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
DataTable dt1 = new BLL.Sys_Public().SelectData("TCode,TName", "Sys_Type", "and TLevel=" + TLevel + " and ParentId=" + dt.Rows[0]["ID"] + " Order by TOrder ").Tables[0];
if (dt1 != null && dt1.Rows.Count > 0)
{
sbType.Append("<option value='0'>==请选择==</option>");
foreach (DataRow dr in dt1.Rows)
{
sbType.Append("<option value=" + StringHelper.NullToStr(dr["TCode"]) + ">" + StringHelper.NullToStr(dr["TName"]) + "</option>");
}
}
else
{
sbType.Append("<option value='0'>==请选择==</option>");
}
}
else
{
sbType.Append("<option value='0'>==请选择==</option>");
}
context.Response.Write(sbType.ToString());
}
/// <summary>
/// 初始化大类-更新
/// </summary>
void PtypeMainUpdate()
{
DataSet ds = new BLL.Sys_Public().SelectData("TCode,TName", "Sys_Type", "and ParentId=0 Order by TOrder");
DataTable dt = new DataTable();
string str_selected = "";
StringBuilder sbType = new StringBuilder();
if (ds != null)
{
dt = ds.Tables[0];
}
//拼接HTML-信息类型
if (PTypeMain == "")
{
str_selected = "selected=\"selected\"";
}
sbType.Append("<option value='0' " + str_selected + ">==请选择==</option>");
foreach (DataRow dr in dt.Rows)
{
if (Utils.ToString(StringHelper.NullToStr(dr["TCode"])) == PTypeMain)
{
sbType.Append("<option value=" + StringHelper.NullToStr(dr["TCode"]) + " selected=\"selected\">");
sbType.Append("" + StringHelper.NullToStr(dr["TName"]) + "");
sbType.Append("</option>");
}
else
{
sbType.Append("<option value=" + StringHelper.NullToStr(dr["TCode"]) + " >");
sbType.Append("" + StringHelper.NullToStr(dr["TName"]) + "");
sbType.Append("</option>");
}
}
StrClass1 = sbType.ToString();
}
public void BindData()
{
if (nodeText != "")
{
if (nodeValue != "000000")
{
string tableName = "Sys_Area";
string showField = " top 1 ID";
string strWhere = " and AreaCode='" + nodeValue + "'";
DataTable dt = new BLL.Sys_Public().SelectData(showField, tableName, strWhere).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
nodeId = Utils.ToInt(dt.Rows[0]["ID"].ToString());
}
}
try
{
HoneyWell.Model.Sys_Area area = new HoneyWell.BLL.Sys_Area().GetModel(nodeId);
txt_ClassCode.Value = area.AreaCode;
txt_ClassName.Value = area.AreaName;
txt_ClassOrder.Value = area.AreaOrder.ToString();
txt_KeyWord.Value = area.KeyWord;
h_ParentCode.Value = area.ParentAreaCode;
h_ClassLevel.Value = area.AreaLevel.ToString();
}
catch (Exception e)
{
Response.Write(e.Message);
}
}
}
public void BindData()
{
if (nodeValue != "000000")
{
string tableName = "Sys_Area";
string showField = " top 1 ID";
string strWhere = " and AreaCode='" + nodeValue + "'";
DataTable dt = new BLL.Sys_Public().SelectData(showField, tableName, strWhere).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
nodeId = Utils.ToInt(dt.Rows[0]["ID"].ToString());
}
}
if (nodeId > 0)
{
HoneyWell.Model.Sys_Area area = new HoneyWell.BLL.Sys_Area().GetModel(nodeId);
h_ClassLevel.Value = area.AreaLevel.ToString();
lab_ParentName.InnerHtml = area.AreaName;
}
else
{
h_ClassLevel.Value = "0";
lab_ParentName.InnerHtml = nodeText;
}
}
public string GetName(string Code)
{
string name = "";
DataTable dt = new BLL.Sys_Public().SelectData("CName", "Sys_Coupon", "and CCode='" + Code + "'").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
name = dt.Rows[0]["CName"].ToString();
}
return(name);
}
void pageBind()
{
string strWhere = "and Phone='" + Phone + "'";
string tableName = "Sys_Receipt";
string showField = "RName,RPhone,Province,City,Area,RAddress,RZipCode";
string orderField = "ID";
int count = 0;
DataSet ds = new BLL.Sys_Public().GetList(tableName, showField, orderField, MyPager.Pagesize, MyPager.Pageindex + 1, 0, strWhere, out count);
rptLoop.DataSource = ds;
rptLoop.DataBind();
MyPager.Count = count;
}
void BindModel()
{
DataTable dt = new BLL.Sys_Public().SelectData("ID", "Sys_Receipt", "and Phone='" + Phone + "'").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
BLL.Sys_Receipt sys_BLL = new BLL.Sys_Receipt();
Model.Sys_Receipt sys_Model = sys_BLL.GetModel(Utils.ToInt(dt.Rows[0]["ID"].ToString()));
Phone = sys_Model.Phone;
RName = sys_Model.RName;
RPhone = sys_Model.RPhone;
GetArea(sys_Model.Province, sys_Model.City, sys_Model.Area);
RZipCode = sys_Model.RZipCode;
}
}
//收货地址信息
public void GetArea(string Province, string City, string Area)
{
DataTable dt1 = new BLL.Sys_Public().SelectData("AreaName", "Sys_Area", "and AreaCode=" + Province + "").Tables[0];
if (dt1 != null && dt1.Rows.Count > 0)
{
StrArea += dt1.Rows[0]["AreaName"].ToString();
}
DataTable dt2 = new BLL.Sys_Public().SelectData("AreaName", "Sys_Area", "and AreaCode=" + City + "").Tables[0];
if (dt2 != null && dt2.Rows.Count > 0)
{
StrArea += "--" + dt2.Rows[0]["AreaName"].ToString();
}
DataTable dt3 = new BLL.Sys_Public().SelectData("AreaName", "Sys_Area", "and AreaCode=" + Area + "").Tables[0];
if (dt3 != null && dt3.Rows.Count > 0)
{
StrArea += "--" + dt3.Rows[0]["AreaName"].ToString();
}
}
/// <summary>
/// 初始化大类-新增
/// </summary>
void PtypeMainAdd()
{
DataSet ds = new BLL.Sys_Public().SelectData("TCode,TName", "Sys_Type", "and ParentId=0 Order by TOrder");
DataTable dt = new DataTable();
StringBuilder sbType = new StringBuilder();
if (ds != null)
{
dt = ds.Tables[0];
}
//拼接HTML
sbType.Append("<option value='0'>==请选择==</option>");
foreach (DataRow dr in dt.Rows)
{
sbType.Append("<option value=" + StringHelper.NullToStr(dr["TCode"]) + " >");
sbType.Append("" + StringHelper.NullToStr(dr["TName"]) + "");
sbType.Append("</option>");
}
StrClass1 = sbType.ToString();
}
/// <summary>
/// 初始化小类-更新
/// </summary>
void PtypeSmallUpdate()
{
DataTable dt = new BLL.Sys_Public().SelectData("ID,TName", "Sys_Type", "and TLevel=1 and TCode='" + PTypeMain + "' Order by TOrder").Tables[0];
StringBuilder sbType = new StringBuilder();
if (dt != null && dt.Rows.Count > 0)
{
DataSet ds1 = new BLL.Sys_Public().SelectData("TCode,TName", "Sys_Type", "and TLevel=2 and ParentId=" + dt.Rows[0]["ID"] + " Order by TOrder");
DataTable dt1 = new DataTable();
string str_selected = "";
if (ds1 != null)
{
dt1 = ds1.Tables[0];
}
//拼接HTML-信息类型
if (PTypeMain == "")
{
str_selected = "selected=\"selected\"";
sbType.Append("<option value='0' " + str_selected + ">==请选择==</option>");
}
foreach (DataRow dr in dt1.Rows)
{
if (Utils.ToString(StringHelper.NullToStr(dr["TCode"])) == PTypeSmall)
{
sbType.Append("<option value=" + StringHelper.NullToStr(dr["TCode"]) + " selected=\"selected\">");
sbType.Append("" + StringHelper.NullToStr(dr["TName"]) + "");
sbType.Append("</option>");
}
else
{
sbType.Append("<option value=" + StringHelper.NullToStr(dr["TCode"]) + " >");
sbType.Append("" + StringHelper.NullToStr(dr["TName"]) + "");
sbType.Append("</option>");
}
}
}
StrClass2 = sbType.ToString();
}
protected void btnDel_Click(object sender, EventArgs e)
{
int result = 0;
string tableName = "Sys_Area";
string showField = " top 1 ID";
string strWhere = " and AreaCode='" + nodeValue + "'";
DataTable dt = new BLL.Sys_Public().SelectData(showField, tableName, strWhere).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
nodeId = Utils.ToInt(dt.Rows[0]["ID"].ToString());
}
if (nodeId > 0)
{
HoneyWell.Model.Sys_Area info = new HoneyWell.BLL.Sys_Area().GetModel(nodeId);
HoneyWell.Model.Sys_Logs logs = new HoneyWell.Model.Sys_Logs();
logs.ID = 0;
logs.DutyId = Utils.ToInt(GetDutyId());
logs.LoginName = GetUserName();
logs.TitleName = "区域管理";
logs.Depicts = "删除区域信息,名称为：" + info.AreaName + "";
logs.CreateTime = DateTime.Now;
logs.IpAddress = Request.UserHostAddress;
logs.MoreCol1 = "";
logs.MoreCol2 = "";
new HoneyWell.BLL.Sys_Logs().Add(logs);
result = new HoneyWell.BLL.Sys_Public().Delete("Sys_Area", " ID=" + nodeId + "");
}
if (result > 0)
{
ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');parent.location='sys_Area_Tree.aspx'", true);
}
}
public string GetType(string Code)
{
string name = "";
DataTable dt = new BLL.Sys_Public().SelectData("CType", "Sys_Coupon", "and CCode='" + Code + "'").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
switch (dt.Rows[0]["CType"].ToString())
{
case "1":
name = "抵扣券";
break;
case "2":
name = "折扣券";
break;
case "3":
name = "现金券";
break;
}
}
return(name);
}
void Sys_Member_Manage(HttpContext context)
{
#region 处理请求参数
string Id = context.Request["Id"];
int pkid = 0;
if (!string.IsNullOrEmpty(Id))
{
pkid = Convert.ToInt32(Id);
}
int DutyId = StringHelper.NullToInt(context.Request["DutyId"]);
string AdminUser = StringHelper.NullToStr(context.Request["AdminUser"]);
string AdminPassWord = StringHelper.NullToStr(context.Request["AdminPassWord"]);
string AdminPassWordOld = StringHelper.NullToStr(context.Request["AdminPassWordOld"]);
string Remark = StringHelper.NullToStr(context.Request["Remark"]);
#endregion
string jsonRet = "";
string retMsg = "";
UserInfo user = new UserInfo();
if (pkid < 1)
{
#region 添加操作
//判断用户名是否重复
DataSet ds = new BLL.Sys_Public().SelectData("top 1 ID,AUserName", "Sys_Admin", " and AUserName='******'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
retMsg = "您输入的用户名已存在，请重新输入！";
jsonRet = "{retMsg:\"" + retMsg + "\"}";
context.Response.Write(retMsg);
context.Response.End();
}
Model.Sys_Admin sys_Model = new Model.Sys_Admin();
BLL.Sys_Admin sys_BLL = new BLL.Sys_Admin();
sys_Model.DutyID = DutyId;
sys_Model.AUserName = AdminUser;
sys_Model.TrueName = "";
sys_Model.Remark = Remark;
sys_Model.APassWord = Encrypt.MakeSecuritySHA(AdminPassWord);
sys_Model.CreateTime = DateTime.Now.ToLocalTime();
sys_Model.ModifyTime = DateTime.Now.ToLocalTime();
sys_Model.MoreCol1 = "";
sys_Model.MoreCol2 = "";
int ret = sys_BLL.Add(sys_Model);
if (ret > 0)
{
retMsg = "添加成功";
jsonRet = "{retMsg:\"" + retMsg + "\"}";
}
else
{
retMsg = "添加失败";
jsonRet = "{retMsg:\"" + retMsg + "\"}";
}
context.Response.Write(retMsg);
context.Response.End();
#endregion
}
else
{
#region 更新操作
Model.Sys_Admin sys_Model = new BLL.Sys_Admin().GetModel(pkid);
BLL.Sys_Admin sys_BLL = new BLL.Sys_Admin();
sys_Model.ID = pkid;
sys_Model.DutyID = DutyId;
sys_Model.AUserName = AdminUser;
sys_Model.TrueName = "";
sys_Model.Remark = Remark;
if (AdminPassWord != "")
{
sys_Model.APassWord = Encrypt.MakeSecuritySHA(AdminPassWord);
}
else
{
sys_Model.APassWord = AdminPassWordOld;
}
sys_Model.ModifyTime = DateTime.Now.ToLocalTime();
sys_Model.MoreCol1 = "";
sys_Model.MoreCol2 = "";
bool ret = sys_BLL.Update(sys_Model);
if (ret == true)
{
string tableName1 = "Sys_Admin";
string sqlWhere1 = " and AUserName='******' ";
sqlWhere1 += " and APassWord='******'";
string showField1 = "top 1 Id,DutyID";
DataTable dt1 = new BLL.Sys_Public().SelectData(showField1, tableName1, sqlWhere1).Tables[0];
if (dt1 != null && dt1.Rows.Count > 0)
{
HttpCookie cookie = new HttpCookie("Fadmin");
cookie["DutyId"] = dt1.Rows[0]["DutyID"].ToString();
cookie["UserName"] = AdminUser;
cookie["PassWord"] = AdminPassWord;
HttpContext.Current.Response.Cookies.Add(cookie);
Model.Sys_Logs logs = new Model.Sys_Logs();
logs.ID = 0;
logs.DutyId = Utils.ToInt(dt1.Rows[0]["DutyID"].ToString());
logs.LoginName = AdminUser;
logs.TitleName = "用户中心";
logs.Depicts = "用户密码修改,会员名为：" + AdminUser + "";
logs.CreateTime = DateTime.Now;
logs.IpAddress = HttpContext.Current.Request.UserHostAddress;
logs.MoreCol1 = "";
logs.MoreCol2 = "";
new BLL.Sys_Logs().Add(logs);
}
retMsg = "更新成功";
jsonRet = "{retMsg:\"" + retMsg + "\"}";
}
else
{
retMsg = "更新失败";
jsonRet = "{retMsg:\"" + retMsg + "\"}";
}
context.Response.Write(retMsg);
context.Response.End();
#endregion
}
}
