protected void Save_Click(object sender, EventArgs e) { Hashtable ht = new Hashtable(); ht = ControlBindHelper.GetWebControls(this.Page); if (!IsEdit) { ht["UID"] = this._key; } string id = IsEdit ? this._key : ""; bool IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("EnterpriseFinance", "UID", id, ht); if (IsOk) { ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>layer.msg('保存成功!');setTimeout('OpenClose()','2000');</script>"); } else { ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>layer.msg('保存失败!');</script>"); } }
private void InitParentId() { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT MaterialType_ID,\r\n MaterialType_Name+' - '+CASE ParentId WHEN '0' THEN '父节' ELSE '子节' END AS MaterialType_Name\r\n FROM MMS_MaterialType WHERE DeleteMark = 1 ORDER BY SortCode ASC"); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql); if (!string.IsNullOrEmpty(this._key)) { if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["MaterialType_ID"].ToString() == this._key) { dt.Rows.RemoveAt(i); } } } } ControlBindHelper.BindHtmlSelect(dt, this.ParentId, "MaterialType_Name", "MaterialType_ID", "物资类型 - 父节"); }
/// <summary> /// 绑定数据源 /// </summary> private void DataBindGrid() { int count = 0; StringBuilder strSql = new StringBuilder("SELECT Recyclebin_ID,Recyclebin_EventField,Recyclebin_Name,CreateUserName,CreateDate,Recyclebin_Remark FROM Base_Recyclebin WHERE 1=1"); IList <SqlParam> IList_param = new List <SqlParam>(); if (BeginBuilTime.Value != "" || endBuilTime.Value != "") { strSql.Append(" and CreateDate >= @BeginBuilTime"); strSql.Append(" and CreateDate <= @endBuilTime"); IList_param.Add(new SqlParam("@BeginBuilTime", CommonHelper.GetDateTime(BeginBuilTime.Value))); IList_param.Add(new SqlParam("@endBuilTime", CommonHelper.GetDateTime(endBuilTime.Value).AddDays(1))); } strSql.Append(" and CreateUserId = @CreateUserId"); IList_param.Add(new SqlParam("@CreateUserId", RequestSession.GetSessionUser().UserId)); strSql.Append(" and Recyclebin_Name = @Recyclebin_Name"); IList_param.Add(new SqlParam("@Recyclebin_Name", _Recyclebin_Name)); DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), IList_param.ToArray(), "CreateDate", "Desc", PageControl1.PageIndex, PageControl1.PageSize, ref count); ControlBindHelper.BindRepeaterList(dt, rp_Item); this.PageControl1.RecordCount = Convert.ToInt32(count); }
/// <summary> /// 确认事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Accept_Click(object sender, EventArgs e) { bool IsOk = false; bpms_tablecolumns = ControlBindHelper.GetWebControls <BPMS_TableColumns>(this.Page); bpms_tablecolumns.MenuId = _Menu_Id; bpms_tablecolumns.IsPublic = IsPublic.Checked ? 1 : 0; bpms_tablecolumns.IsHidden = IsHidden.Checked ? 1 : 0; bpms_tablecolumns.Enabled = Enabled.Checked ? 1 : 0; bpms_tablecolumns.AllowEdit = AllowEdit.Checked ? 1 : 0; bpms_tablecolumns.AllowDelete = AllowDelete.Checked ? 1 : 0; if (!string.IsNullOrEmpty(_key))//判断是否编辑 { bpms_tablecolumns.TableColumnsId = _key; bpms_tablecolumns.ModifyDate = DateTime.Now; bpms_tablecolumns.ModifyUserId = RequestSession.GetSessionUser().UserId; bpms_tablecolumns.ModifyUserName = RequestSession.GetSessionUser().UserName; IsOk = bpms_tablecolumnsibll.Update(bpms_tablecolumns); if (IsOk) { ShowMsgHelper.AlertCallback(MessageHelper.MSG0006); } } else { bpms_tablecolumns.TableColumnsId = CommonHelper.GetGuid; bpms_tablecolumns.CreateUserId = RequestSession.GetSessionUser().UserId; bpms_tablecolumns.CreateUserName = RequestSession.GetSessionUser().UserName; IsOk = bpms_tablecolumnsibll.Insert(bpms_tablecolumns); if (IsOk) { ShowMsgHelper.AlertCallback(MessageHelper.MSG0005); } } if (!IsOk) { ShowMsgHelper.Alert_Error(MessageHelper.MSG0022); } }
/// <summary> /// 得到一个对象实体 /// </summary> public void InitControl() { ParentId.Value = _ParentId; ParentName.Value = _ParentName; if (!string.IsNullOrEmpty(_key)) { bpms_sysmenu = bpms_sysmenuibll.GetEntity(_key); ControlBindHelper.SetWebControls(this.Page, bpms_sysmenu); if (bpms_sysmenu.Img != "") { Img_Menu_Img.Src = "/Themes/Images/32/" + bpms_sysmenu.Img; } //获取上级菜单信息 bpms_sysmenu = bpms_sysmenuibll.GetEntity(bpms_sysmenu.ParentId); ParentName.Value = bpms_sysmenu.FullName; if (ParentId.Value == "0") { ParentName.Value = "父节点"; } } }
private void DataBindGrid() { int count = 0; if (dtExport.Rows.Count > 0) { for (int i = dtExport.Rows.Count - 1; i >= 0; i--) { dtExport.Rows.RemoveAt(i); } } txtJoinDate = tb_BeginDate.Text; txtOutDate = tb_EndDate.Text; if (txtJoinDate != "" || txtOutDate != "") { string sql = "select User_Name,USER_ID from Base_UserInfo where (join_date<='" + txtOutDate + "' and (out_date is null or out_date='1900-01-01' or out_date>='" + txtJoinDate + "'))"; StringBuilder sb_sql = new StringBuilder(sql); DataTable dt = DataFactory.SqlDataBase().GetPageList(sql, null, "User_Name", "asc", PageControl1.PageIndex, PageControl1.PageSize, ref count); ControlBindHelper.BindRepeaterList(dt, rp_Item); this.PageControl1.RecordCount = Convert.ToInt32(count); } }
private void InitData() { Hashtable ht = DataFactory.SqlDataBase().GetHashtableById("User_Photo", "Card_ID", this._key); if (ht.Count > 0 && ht != null) { string _d1 = "/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAAeAAD/4QMraHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjMtYzAxMSA2Ni4xNDU2NjEsIDIwMTIvMDIvMDYtMTQ6NTY6MjcgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcD0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLyIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bXA6Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDUzYgKFdpbmRvd3MpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOjkzOUM0QkU4NUIyMDExRTdBRjk1OTIwNUI5Q0FDQzhEIiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOjkzOUM0QkU5NUIyMDExRTdBRjk1OTIwNUI5Q0FDQzhEIj4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6OTM5QzRCRTY1QjIwMTFFN0FGOTU5MjA1QjlDQUNDOEQiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6OTM5QzRCRTc1QjIwMTFFN0FGOTU5MjA1QjlDQUNDOEQiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz7/7gAOQWRvYmUAZMAAAAAB/9sAhAAQCwsLDAsQDAwQFw8NDxcbFBAQFBsfFxcXFxcfHhcaGhoaFx4eIyUnJSMeLy8zMy8vQEBAQEBAQEBAQEBAQEBAAREPDxETERUSEhUUERQRFBoUFhYUGiYaGhwaGiYwIx4eHh4jMCsuJycnLis1NTAwNTVAQD9AQEBAQEBAQEBAQED/wAARCAB4AKADASIAAhEBAxEB/8QAaQABAAMBAQEAAAAAAAAAAAAAAAIDBAEFBwEBAAAAAAAAAAAAAAAAAAAAABAAAgIBAgUBBwUBAAAAAAAAAAERAgMhBDFBURITcWGBsdFSMxSRoSIyI1MRAQAAAAAAAAAAAAAAAAAAAAD/2gAMAwEAAhEDEQA/APoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEXaqcNpPoBIAAADjtVcWl6gdBw6AAIq9G3VWTa4qQJAja9K/2slPVwdTTUrVAdAAAAAAAAI2fbV24wmyRXmyPHjdkpYGX83L0r+/zKb3d7Oz4ss89f+VP0KrPus3CU8lwAuW8ypJRXT1+Zq2+V5aOzUNONDGs1UkvHRxzg0bXN3t07VVLXQDSefu/vv0R6B5+7++/d8ANW1a8FZfX4lspnmVxZLKa1bXVIv2uLLXLLq6qNZA1Zb+PHa3Th6mGtnjoslf7NtOz1jQs3t27KnJakKvIsVfFOs90KdZ+QEMmS+Rp3ctEqbjLSqrV6LhoVt2tbXWzLVfcpQu6F7ANeC9r4la3EtKNrbK6vyTx0kvAAAAAABG9qVq3eO3nJIqz4nlp2pw05QGPNkpdxSirVc4SbK2mnDUM24dpWj7r/wArclyKNxju81oq3PDT2AVUt47y6p9a2RvwZMV1/mlV81EHL7emSq7tLJcUQptXjreHNrVaXIDRK6mDdfffu+BH8fN9DH4+b6GBs2rXgrr1+JbK6nnfj5voZ2u3zdy/i1rxA17mlXitZqWlozNs2/K4+lmvOm8V0tXBl2dbeVuNEgK3jqnDyJXXHjE+pGzvVw7T6OTTl2bbdqPjrDM18d6OLVaA37fu8Ne5y+OpaQxOzx1dtLRqTAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//Z"; if (ht.Contains("SID01")) { string _ID01 = ht["SID01"].ToString().Trim(); this.ViewState["SID01"] = _ID01; SID01Data = string.Format("data:image/jpg;base64,{0}", string.IsNullOrEmpty(_ID01) ? _d1 : _ID01); } if (ht.Contains("SID02")) { string _ID02 = ht["SID02"].ToString().Trim(); this.ViewState["SID02"] = _ID02; SID02Data = string.Format("data:image/jpg;base64,{0}", string.IsNullOrEmpty(_ID02) ? _d1 : _ID02); } ControlBindHelper.SetWebControls(this.Page, ht); } }
/// <summary> /// 加载数据列表 /// </summary> public void DBind() { string strWhere = " 1=1"; if (this.ddlVillageCode.SelectedValue != "-1") { strWhere += " and VillageCode='" + this.ddlVillageCode.SelectedValue + "'"; } if (this.ddlIsForbid.SelectedValue != "-1") { strWhere += " and IsForbid ='" + ddlIsForbid.SelectedValue + "'"; } if (this.txtCollCode.Text.Trim() != "") { strWhere += " and CollCode like '%" + this.txtCollCode.Text.Trim().Replace("'", "''") + "%'"; } if (this.txtCollName.Text.Trim() != "") { strWhere += " and CollName like '%" + this.txtCollName.Text.Trim().Replace("'", "''") + "%'"; } ControlBindHelper.GridViewPagerBindByRowNum(this.anp_Colliery, "VSYS_CollieryNet", strWhere, " IsForbid asc,CollCode desc", this.gdv_Colliery); }
protected void Save_Click(object sender, EventArgs e) { Hashtable ht = new Hashtable(); ht = ControlBindHelper.GetWebControls(this.Page); ht["Property_Control_ID"] = 0; if (!string.IsNullOrEmpty(this._key)) { ht["ModifyDate"] = DateTime.Now; ht["ModifyUserId"] = RequestSession.GetSessionUser().UserId; ht["ModifyUserName"] = RequestSession.GetSessionUser().UserName; } else { ht["Property_ID"] = CommonHelper.GetGuid; ht["CreateUserId"] = RequestSession.GetSessionUser().UserId; ht["CreateUserName"] = RequestSession.GetSessionUser().UserName; } bool IsOk = DataFactory.SqlDataBase ().Submit_AddOrEdit("Base_AppendProperty", "Property_ID", this._key, ht); if (IsOk) { ShowMsgHelper.AlertMsg("操作成功!"); } else { ShowMsgHelper.Alert_Error("操作失败!"); } }
private bool SaveData() { Hashtable ht = new Hashtable(); ht = ControlBindHelper.GetWebControls(this.Page); if (string.IsNullOrEmpty(this.UG_Card_ID.Value.Trim()) || string.IsNullOrEmpty(this.Card_ID) || string.IsNullOrEmpty(this.UG_Card_Name.Value.Trim())) { ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>layer.msg('信息不完整!');</script>"); return(false); } if (!string.IsNullOrEmpty(this._key)) { ht.Remove("UG_CARD_ID"); ht.Remove("UG_CARD_NAME"); ht["ModifyDate"] = DateTime.Now.ToString(); } else { ht["Ord"] = 2; ht["Card_Id"] = this.Card_ID; } bool IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Base_User_Guarantee", "Card_ID", this._key, ht); if (IsOk) { // string Url = PageHelper.UrlEncrypt(this.Card_ID); // ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>self.location='User_Guardian2.aspx?Card_ID=" + Url + "';</script>"); ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>layer.msg('保存成功!')</script>"); return(true); } else { ShowMsgHelper.Alert_Error("操作失败!"); return(false); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Save_Click(object sender, EventArgs e) { Hashtable ht = new Hashtable(); ht = ControlBindHelper.GetWebControls(this.Page); if (ParentId.Value == "") { ht["ParentId"] = "0"; ht["Menu_Type"] = 1; } else { ht["Menu_Type"] = 2; } if (!string.IsNullOrEmpty(_key)) { ht["ModifyDate"] = DateTime.Now; ht["ModifyUserId"] = RequestSession.GetSessionUser().UserId; ht["ModifyUserName"] = RequestSession.GetSessionUser().UserName; } else { ht["Menu_Id"] = CommonHelper.GetGuid; ht["CreateUserId"] = RequestSession.GetSessionUser().UserId; ht["CreateUserName"] = RequestSession.GetSessionUser().UserName; } bool IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Base_SysMenu", "Menu_Id", _key, ht); if (IsOk) { CacheHelper.RemoveAllCache(); ShowMsgHelper.AlertMsg("Success!"); } else { ShowMsgHelper.Alert_Error("Error!"); } }
protected void Save_Click(object sender, EventArgs e) { Hashtable ht = new Hashtable(); ht = ControlBindHelper.GetWebControls(this.Page); ht.Remove("acceptLevel"); ht["acceptLevel"] = StringHelper.FormatTextArea(this.acceptLevel.Value); if (string.IsNullOrEmpty(this._key)) { ht["ID"] = CommonHelper.GetGuid; } bool IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Specialty", "ID", this._key, ht); if (IsOk) { ShowMsgHelper.ParmAlertMsg("操作成功!"); } else { ShowMsgHelper.Alert_Error("操作失败!"); } }
private void InitData() { string sql = "select * from Base_ATS_LeaveSetting"; StringBuilder sb_sql = new StringBuilder(sql); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql); LeaveID.DataSource = dt; LeaveID.DataTextField = "LeaveName"; LeaveID.DataValueField = "id"; LeaveID.DataBind(); Hashtable ht = DataFactory.SqlDataBase().GetHashtableById("Base_PerLeaveApply", "id", _key); if (ht.Count > 0 && ht != null) { ControlBindHelper.SetWebControls(this.Page, ht); strUserID = EmpID.Text; EmpID.Text = GetNameFromID(EmpID.Text); //lab_CreateDate.Text = ""; BeginDate.Text = Convert.ToDateTime(BeginDate.Text).ToString("yyyy-MM-dd"); EndDate.Text = Convert.ToDateTime(EndDate.Text).ToString("yyyy-MM-dd"); } }
protected void Page_Load(object sender, EventArgs e) { _Table_Name = Server.UrlDecode(Request["tableCode"]);//表名 if (!IsPostBack) { string str = "SELECT * FROM " + _Table_Name; txtSql.Value = str; DataTable dt = DataFactory.SqlHelper().GetDataTableBySQL(new StringBuilder(str)); if (dt.Rows.Count != 0) { ControlBindHelper.BindGridViewList(dt, Grid); } else { dt = new DataTable(); dt.Columns.Add("消息提示", Type.GetType("System.String")); DataRow row = dt.NewRow(); row["消息提示"] = "没有找到您要的相关数据"; dt.Rows.Add(row); ControlBindHelper.BindGridViewList(dt, Grid); } } }
private void DataBindGrid() { int count = 0; StringBuilder SqlWhere = new StringBuilder(); IList <SqlParam> IList_param = new List <SqlParam>(); //if (!string.IsNullOrEmpty(this.newsTypeID.Value)) //{ // SqlWhere.AppendFormat(" AND newsTypeID='{0}' ", this.newsTypeID.Value); //} if (!string.IsNullOrEmpty(this.txt_Search.Value)) { SqlWhere.Append(" AND title like @obj "); IList_param.Add(new SqlParam("@obj", '%' + this.txt_Search.Value.Trim() + '%')); } DataTable dt = this.peridal.GetNewsListPage(SqlWhere, IList_param, this.PageControl1.PageIndex, this.PageControl1.PageSize, ref count); ControlBindHelper.BindRepeaterList(dt, this.rp_Item); this.PageControl1.RecordCount = Convert.ToInt32(count); this.PageControl1.PageChecking(); }
/// <summary> /// 绑定数据源 /// </summary> private void DataBindGrid() { int count = 0; StringBuilder SqlWhere = new StringBuilder(); IList <SqlParam> IList_param = new List <SqlParam>(); if (BeginBuilTime.Value != "" || endBuilTime.Value != "") { SqlWhere.Append(" and Sys_LoginLog_Time >= @BeginBuilTime"); SqlWhere.Append(" and Sys_LoginLog_Time <= @endBuilTime"); IList_param.Add(new SqlParam("@BeginBuilTime", CommonHelper.GetDateTime(BeginBuilTime.Value))); IList_param.Add(new SqlParam("@endBuilTime", CommonHelper.GetDateTime(endBuilTime.Value).AddDays(1))); } if (txt_Search.Value != "") { SqlWhere.Append(" and SYS_USER = @SYS_USER"); IList_param.Add(new SqlParam("@SYS_USER", txt_Search.Value)); } DataTable dt = user_idao.GetSysLoginLogPage(SqlWhere, IList_param, PageControl1.PageIndex, PageControl1.PageSize, ref count); ControlBindHelper.BindRepeaterList(dt, rp_Item); this.PageControl1.RecordCount = Convert.ToInt32(count); }
/// <summary> /// 绑定数据源 /// </summary> private void DataBindGrid() { VehicleModelManager vModelManage = new VehicleModelManager(); int count = 0; StringBuilder SqlWhere = new StringBuilder(); IList <SqlParam> IList_param = new List <SqlParam>(); if (!string.IsNullOrEmpty(txtTitle.Value)) { SqlWhere.Append(" and ArticleName like @ArticleName "); IList_param.Add(new SqlParam("@ArticleName", '%' + txtTitle.Value + '%')); } if (!string.IsNullOrEmpty(selCatelog.Value)) { SqlWhere.Append(" and CategoryID=@CategoryID "); IList_param.Add(new SqlParam("@CategoryID", selCatelog.Value)); } DataTable dt = articleManager.GetDataPage(SqlWhere, IList_param, PageControl1.PageIndex, PageControl1.PageSize, ref count); ControlBindHelper.BindRepeaterList(dt, rp_Item); this.PageControl1.RecordCount = Convert.ToInt32(count); }
protected void ddl_parentOrgID_SelectedIndexChanged(object sender, EventArgs e) { if (this.ddl_parentOrgID.SelectedValue == "") { this.ddl_TypeCode.Visible = false; tdTypeCode.Visible = false; spanStar.Visible = false; } else { string strOrgType = new IndustryPlatform.BLL.SYS_Organization().GetModel(this.ddl_parentOrgID.SelectedValue).OrgType; if (strOrgType == "1") { lblTypeCode.Text = "选择磅房:"; ControlBindHelper.DropDownListBind(this.ddl_TypeCode, "TT_Room", "RoomName", "RoomCode", "IsForbid='0'", "请选择磅房", ""); } else if (strOrgType == "2") { lblTypeCode.Text = "选择煤矿:"; ControlBindHelper.DropDownListBind(this.ddl_TypeCode, "Sys_Colliery", "CollName", "CollCode", "IsForbid='0'", "请选择煤矿", ""); } if (strOrgType == "1" || strOrgType == "2") { this.ddl_TypeCode.Visible = true; tdTypeCode.Visible = true; spanStar.Visible = true; } else { this.tdTypeCode.Visible = false; this.ddl_TypeCode.Visible = false; spanStar.Visible = false; this.ddl_TypeCode.Items.Clear(); this.ddl_TypeCode.Items.Add(new ListItem("1", "")); } } }
/// <summary> /// 确认事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Accept_Click(object sender, EventArgs e) { bool IsOk = false; bpms_roles = ControlBindHelper.GetWebControls <BPMS_Roles>(this.Page); bpms_roles.Enabled = Enabled.Checked ? 1 : 0; bpms_roles.AllowEdit = AllowEdit.Checked ? 1 : 0; bpms_roles.AllowDelete = AllowDelete.Checked ? 1 : 0; if (!string.IsNullOrEmpty(_key))//判断是否编辑 { bpms_roles.RoleId = _key; bpms_roles.ModifyDate = DateTime.Now; bpms_roles.ModifyUserId = RequestSession.GetSessionUser().UserId; bpms_roles.ModifyUserName = RequestSession.GetSessionUser().UserName; IsOk = bpms_rolesibll.Update(bpms_roles); if (IsOk) { ShowMsgHelper.AlertParmCallback(MessageHelper.MSG0006); } } else { bpms_roles.OrganizationId = _OrganizationId; bpms_roles.RoleId = CommonHelper.GetGuid; bpms_roles.CreateUserId = RequestSession.GetSessionUser().UserId; bpms_roles.CreateUserName = RequestSession.GetSessionUser().UserName; IsOk = bpms_rolesibll.Insert(bpms_roles); if (IsOk) { ShowMsgHelper.AlertParmCallback(MessageHelper.MSG0005); } } if (!IsOk) { ShowMsgHelper.Alert_Error(MessageHelper.MSG0022); } }
public void AddOrUpdate(HttpContext context) { SqlServerHelper helper = new SqlServerHelper(); var pkValue = context.Request["jdid"]; var caseId = context.Request["CaseId"]; var typeId = context.Request["typeId"]; var nameId = context.Request["nameId"]; var ht = ControlBindHelper.GetWebControlsValue(context, 16, 3); if (string.IsNullOrEmpty(pkValue)) { ht["jdid"] = Guid.NewGuid().ToString(); if (helper.InsertByHashtable("TB_Chufajuedingshu31", ht) > 0) { if (caseDBO.CheckCaseState(caseId, nameId, typeId)) { Message.success(context, "交通行政处罚决定书增加成功"); } } else { Message.success(context, "交通行政处罚决定书增加失败"); } } else { if (helper.UpdateByHashtable("TB_Chufajuedingshu31", "jdid", pkValue, ht) > 0) { Message.success(context, "交通行政处罚决定书修改成功"); } else { Message.success(context, "交通行政处罚决定书修改失败"); } } }
private void Binddata() { DataTable dt = new SqlServerHelper().GetDataTable("waterUserType", "", "waterUserTypeId"); ControlBindHelper.BindComboBoxData(this.waterUserTypeId, dt, "waterUserTypeName", "waterUserTypeId"); DataTable dt2 = new SqlServerHelper().GetDataTable("waterUserHouseType", "", "waterUserHouseTypeID"); ControlBindHelper.BindComboBoxData(this.waterUserHouseType, dt2, "waterUserHouseType", "waterUserHouseTypeID"); if (string.IsNullOrEmpty(key)) { userName.Text = strRealName; } else { Hashtable ht = new SqlServerHelper().GetHashtableById("Meter_Install_Peccant", "SingleID", key); new SqlServerHelper().BindHashTableToForm(ht, this.groupBox6.Controls); Btn_Submit.Enabled = FlowFunction.IsAllowEdit(taskid); waterUserNO.Enabled = false; waterUserNO.ReadOnly = true; } }
private void InitData() { Hashtable ht = DataFactory.SqlDataBase().GetHashtableById("MMS_FixedAassets", "id", this._key); if (ht.Count > 0 && ht != null) { ControlBindHelper.SetWebControls(this.Page, ht); } foreach (DictionaryEntry element in ht) { string name = (string)element.Key; if (name == "FA_Type") { this._FA_Type = (string)element.Value.ToString().Trim(); } if (name == "FA_Status") { this._Status = (string)element.Value.ToString().Trim(); } } }
/// <summary> /// 节点位置下拉框绑定 /// </summary> /// <param name="projectid"></param> /// <returns></returns> private void InitParentId() { StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT Menu_Id, Menu_Name+' - '+CASE Menu_Type WHEN '1' THEN '父节' WHEN '2' THEN '子节' END AS Menu_Name FROM Base_SysMenu WHERE DeleteMark = 1 AND Menu_Type != 3 ORDER BY SortCode ASC"); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql); if (!string.IsNullOrEmpty(_key)) { if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Menu_Id"].ToString() == _key) { dt.Rows.RemoveAt(i); } } } } ControlBindHelper.BindHtmlSelect(dt, ParentId, "Menu_Name", "Menu_Id", "模块菜单 - 父节"); }
/// <summary> /// 节点位置下拉框绑定 /// </summary> /// <param name="projectid"></param> /// <returns></returns> private void InitParentId() { StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT Organization_ID, Organization_Name+' - '+CASE ParentId WHEN '0' THEN '父节' ELSE '子节' END AS Organization_Name FROM Base_Organization WHERE DeleteMark = 1 ORDER BY SortCode ASC"); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql); if (!string.IsNullOrEmpty(_key)) { if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Organization_ID"].ToString() == _key) { dt.Rows.RemoveAt(i); } } } } ControlBindHelper.BindHtmlSelect(dt, ParentId, "Organization_Name", "Organization_ID", "部门信息 - 父节"); }
protected void Save_Click(object sender, EventArgs e) { Hashtable ht = new Hashtable(); ht = ControlBindHelper.GetWebControls(this.Page); ht["EmpID"] = _key; string sql = "select * from Base_LeaveConsole where EmpID='" + _key + "' "; StringBuilder sb_sql = new StringBuilder(sql); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql); if (dt.Rows.Count != 0 && dt.Rows[0].ItemArray[0].ToString() != "") { int IsOk = DataFactory.SqlDataBase().UpdateByHashtable("Base_LeaveConsole", "EmpID", _key, ht); if (IsOk > 0) { ShowMsgHelper.AlertMsg("Success!"); } else { ShowMsgHelper.Alert_Error("Error!"); } } else { int IsOk = DataFactory.SqlDataBase().InsertByHashtable("Base_LeaveConsole", ht); if (IsOk > 0) { ShowMsgHelper.AlertMsg("Success!"); } else { ShowMsgHelper.Alert_Error("Error!"); } } }
protected void Save_Click(object sender, EventArgs e) { btnTravelDays_Click(null, null); DateTimeFormatInfo dtFormat = new System.Globalization.DateTimeFormatInfo(); dtFormat.ShortDatePattern = "yyyy/MM/dd"; if ((Convert.ToDateTime(BeginDate.Text, dtFormat) > Convert.ToDateTime(EndDate.Text, dtFormat)) || (Convert.ToDateTime(BeginDate.Text, dtFormat) == Convert.ToDateTime(EndDate.Text, dtFormat) && BeginFlag.Value == "0" && EndFlag.Value == "0")) { ShowMsgHelper.Alert_Error("Date Error"); } else { Hashtable ht = new Hashtable(); ht = ControlBindHelper.GetWebControls(this.Page); //ht["EmpID"] = txt_EmpID; //ht["CreateDate"] = CreateDate.Text; //ht["ApprovalFlag"] = 0; if (int_AppFlag == 3) { ht["ApprovalFlag"] = 1; } //ht["NextApprover"] = txt_NextApprover; ht["FilesAdd"] = txt_FilesAdd; ht["TravelDays"] = TravelDays.Text; int IsOk = DataFactory.SqlDataBase().UpdateByHashtable("Base_PerTravelApply", "id", _key, ht); if (IsOk > 0) { ShowMsgHelper.AlertMsg("Success!"); } else { ShowMsgHelper.Alert_Error("Error!"); } } }
/// <summary> /// 绑定数据源 /// </summary> private void DataBindGrid() { int count = 0; StringBuilder SqlWhere = new StringBuilder(); IList <SqlParam> IList_param = new List <SqlParam>(); if (!string.IsNullOrEmpty(txt_Search.Value)) { SqlWhere.Append(" and U." + Searchwhere.Value + " like @obj "); IList_param.Add(new SqlParam("@obj", '%' + txt_Search.Value.Trim() + '%')); } if (_Organization_ID == null || _Organization_ID.Length > 40) { _Organization_ID = null; } if (!string.IsNullOrEmpty(_Organization_ID)) { SqlWhere.Append(" AND S.Organization_ID IN(" + _Organization_ID + ")"); } DataTable dt = user_idao.GetUserInfoPage(SqlWhere, IList_param, PageControl1.PageIndex, PageControl1.PageSize, ref count); ControlBindHelper.BindRepeaterList(dt, rp_Item); this.PageControl1.RecordCount = Convert.ToInt32(count); }
public void InitBasicUserInfo() { Hashtable ht = DataFactory.SqlDataBase().GetHashtableById("Base_UserInfo", "User_ID", this._key); if (ht.Count > 0 && ht != null) { ControlBindHelper.SetWebControls(this.Page, ht); if (ht["USER_SEX"].ToString() == "1") { this.User_Sex.Text = "男士"; } else { this.User_Sex.Text = "女士"; } if (ht["DELETEMARK"].ToString() == "2") { this.DeleteMark.Text = "正常"; } else { if (ht["DELETEMARK"].ToString() == "3") { this.DeleteMark.Text = "停用"; } else { if (ht["DELETEMARK"].ToString() == "1") { this.DeleteMark.Text = "未授权"; } } } this.AppendProperty_value.Value = this.systemidao.GetPropertyInstancepk(this.Property_Function, this._key); } }
protected void Save_Click(object sender, EventArgs e) { Hashtable ht = new Hashtable(); if (string.IsNullOrEmpty(this.Card_Name.Value.Trim()) || string.IsNullOrEmpty(this.Card_ID.Value.Trim()) || string.IsNullOrEmpty(this.U_Age.Value.Trim())) { ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>layer.msg('信息不完整!');</script>"); return; } if (!string.IsNullOrEmpty(this._key)) { ht["ModifyDate"] = DateTime.Now.ToString(); ht["U_Address"] = this.U_Address.Value.Trim(); ht["U_Tel"] = this.U_Tel.Value.Trim(); ht["U_Zip"] = this.U_Zip.Value.Trim(); } else { ht = ControlBindHelper.GetWebControls(this.Page); ht["User_ID"] = RequestSession.GetSessionUser().UserId.ToString(); ht["User_Name"] = RequestSession.GetSessionUser().UserName.ToString(); } bool IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Base_User", "Card_ID", this._key, ht); if (IsOk) { string Url = PageHelper.UrlEncrypt(this.Card_ID.Value.Trim()); ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>self.location='User_Extra.aspx?Card_ID=" + Url + "';</script>"); } else { ShowMsgHelper.Alert_Error("操作失败!"); } }
private void DataBindGrid() { DataTable dt = this.system_idao.GetBackup_Restore_Log_List(); ControlBindHelper.BindRepeaterList(dt, this.rp_Item); }