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