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 } }