public void GetRoleRightListByUserID() { int UserID = base.GetInt("UserID", 0); SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@UserID", UserID, TypeCode.Int32) }; string querySqlCode = "QueryRoleRightListByUserID_Param"; try { DataSet dataSet = CommonRight.Instance.ExcuteQuerySql(querySqlCode, conditions); dataSet = this.MergeUserRoleRightState(dataSet); DataSet dataSet2 = new DataSet(); dataSet2.Merge(dataSet.Tables[0]); dataSet2.Merge(dataSet.Tables[1]); dataSet2.Merge(dataSet.Tables[2]); string msg = JsonHelperFont.Instance.DataSetToJSON(dataSet2); this.OutPutMessage(msg); } catch (Exception ex) { this.OutPutMessage(ex.Message); } }
public virtual DataSet ExcuteQuerySqlX(string AppSettingKey, string QuerySqlCode, params SqlConditionInfo[] conditions) { string connectionString = PEIS.DBUtility.PubConstant.GetConnectionString(AppSettingKey); DataSet result; if (string.IsNullOrEmpty(connectionString)) { result = null; } else { string text = string.Empty; try { string[] sqlSentence = this.GetSqlSentence(QuerySqlCode); if (sqlSentence.Length > 0) { text = sqlSentence[0].ToString(); } if (!string.IsNullOrEmpty(text) && conditions != null) { for (int i = 0; i < conditions.Length; i++) { SqlConditionInfo sqlConditionInfo = conditions[i]; if (sqlConditionInfo != null) { string text2 = sqlConditionInfo.ParamValue.ToString(); if (!string.IsNullOrEmpty(text2)) { string text3 = sqlConditionInfo.ParamName; if (text3.IndexOf("@") == -1) { text3 = "@" + text3; } if (text3 == "@CustomerExamState") { try { int num = int.Parse(text2); } catch (Exception var_7_FE) { } } text = text.Replace(text3, Util.GetStr(sqlConditionInfo)); } } } } result = DbHelperSQL.Query(connectionString, text); return(result); } catch (Exception ex) { Log4J.Instance.Error("通用查询语句(不分页) Exception:" + ex.Message + " Sql:" + Secret.AES.Encrypt(text)); } result = null; } return(result); }
public void DeleteRightNodeItem() { int @int = base.GetInt("txtRightID", 0); int num = 0; int num2 = 0; SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@RightID", @int, TypeCode.Int32) }; string querySqlCode = "QueryRightUsedCount_Param"; try { DataSet dataSet = CommonRight.Instance.ExcuteQuerySql(querySqlCode, conditions); num = int.Parse(dataSet.Tables[0].Rows[0][0].ToString()); num += int.Parse(dataSet.Tables[1].Rows[0][0].ToString()); num2 = int.Parse(dataSet.Tables[2].Rows[0][0].ToString()); } catch (Exception ex) { } int num3; if (num > 0) { num3 = -1; } else if (num2 > 0) { num3 = -2; } else { num3 = (PEIS.BLL.SYSRight.Instance.Delete(@int) ? 1 : 0); if (num3 > 0) { Log4J.Instance.Info(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",删除权限 ID:", @int })); } else { Log4J.Instance.Error(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",删除权限失败 ID:", @int })); } } this.OutPutMessage(num3.ToString()); }
public void GetUserMenuRightSectionList() { int num = 1; try { num = int.Parse(BaseConfig.MenuModuleType); } catch (Exception ex) { num = 1; } SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@UserID", this.LoginUserModel.UserID, TypeCode.Int32), new SqlConditionInfo("@MenuLevel", num, TypeCode.Int16) }; string querySqlCode = "QueryUserMenuRightSectionList_Param"; try { DataSet ds = CommonRight.Instance.ExcuteQuerySql(querySqlCode, conditions); string msg = JsonHelperFont.Instance.DataSetToJSON(ds); this.OutPutMessage(msg); } catch (Exception ex) { this.OutPutMessage(ex.Message); } }
public void GetSingleSectionUserInfo() { int @int = base.GetInt("ID_User", 0); SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@ID_User", @int, TypeCode.Int32) }; string querySqlCode = "QuerySingleSectionUserInfo_Param"; try { DataSet dataSet = CommonUser.Instance.ExcuteQuerySql(querySqlCode, conditions); if (dataSet != null && dataSet.Tables[0].Rows.Count > 0) { dataSet.Tables[0].Columns.Add("SignatureCodeBase64"); foreach (DataRow dataRow in dataSet.Tables[0].Rows) { if (!Convert.IsDBNull(dataRow["Signature"])) { dataRow["SignatureCodeBase64"] = Convert.ToBase64String((byte[])dataRow["Signature"]); dataRow["Signature"] = null; } } dataSet.Tables[0].AcceptChanges(); } string msg = JsonHelperFont.Instance.DataSetToJSON(dataSet); this.OutPutMessage(msg); } catch (Exception ex) { this.OutPutMessage(ex.Message); } }
public void GetSectionUserList() { int @int = base.GetInt("pageIndex", 0); int int2 = base.GetInt("pageSize", 10); int int3 = base.GetInt("SelectedSectionID", 0); int totalCount = 0; int num = 0; string text = base.GetString("SearchUserKeyword").Trim(); SqlConditionInfo[] array = null; string pageCode = "QueryPagesSectionUserListParam"; if (!string.IsNullOrEmpty(text) && int3 <= 0) { array = new SqlConditionInfo[1]; pageCode = "QueryPagesSectionUserListParamByName"; array[0] = new SqlConditionInfo("@UserName", text, TypeCode.String); array[0].Blur = 3; array[0].Place = 2; } if (int3 > 0 && string.IsNullOrEmpty(text)) { array = new SqlConditionInfo[1]; pageCode = "QueryPagesUserListParamBySection"; array[0] = new SqlConditionInfo("@ID_Section", int3, TypeCode.Int32); array[0].Place = 2; } if (int3 > 0 && !string.IsNullOrEmpty(text)) { array = new SqlConditionInfo[2]; pageCode = "QueryPagesUserListParamByNameAndSection"; array[0] = new SqlConditionInfo("@UserName", text, TypeCode.String); array[0].Blur = 3; array[0].Place = 2; array[1] = new SqlConditionInfo("@ID_Section", int3, TypeCode.Int32); array[1].Place = 2; } DataTable page = CommonUser.Instance.GetPage(pageCode, @int, int2, out totalCount, out num, array); if (page != null && page.Rows.Count > 0) { page.Columns.Add("SignatureCodeBase64"); foreach (DataRow dataRow in page.Rows) { if (!Convert.IsDBNull(dataRow["Signature"])) { dataRow["SignatureCodeBase64"] = Convert.ToBase64String((byte[])dataRow["Signature"]); dataRow["Signature"] = null; } } page.AcceptChanges(); } string msg = JsonHelperFont.Instance.DataTableToJSON(page, totalCount); this.OutPutMessage(msg); }
public override void ReplaceContent(ref VelocityContext vltContext) { vltContext.Put("pageTitle", "修改[" + base.GetString("CustomerName").ToLower() + "]客户档案"); int @int = base.GetInt("ID_ArcCustomer", -1); if (@int > -1) { string pageCode = "QueryCustomerManageListInfoPagesParam"; SqlConditionInfo[] array = new SqlConditionInfo[] { new SqlConditionInfo("@ID_ArcCustomer", @int, TypeCode.Int16) }; array[0].Place = 3; int num = 0; int pageIndex = 0; int pageSize = 10; int num2 = 1; DataTable page = CommonRegiste.Instance.GetPage(pageCode, pageIndex, pageSize, out num, out num2, array); if (page.Rows.Count > 0) { int count = page.Columns.Count; if (page.Columns.Contains("Photo")) { page.Columns.Add("Base64Photo"); page.Columns.Add("FilePath"); foreach (DataRow dataRow in page.Rows) { if (!Convert.IsDBNull(dataRow["Photo"])) { dataRow["Base64Photo"] = Convert.ToBase64String((byte[])dataRow["Photo"]); } vltContext.Put("ID_ArcCustomer", dataRow["ID_ArcCustomer"].ToString()); vltContext.Put("CustomerName", dataRow["CustomerName"].ToString()); vltContext.Put("Gender", dataRow["ID_Gender"].ToString()); vltContext.Put("GenderName", dataRow["GenderName"].ToString()); vltContext.Put("IDCard", dataRow["IDCard"].ToString()); vltContext.Put("BirthDay", dataRow["BirthDay"].ToString()); vltContext.Put("MobileNo", dataRow["MobileNo"].ToString()); vltContext.Put("Base64Photo", dataRow["Base64Photo"].ToString()); vltContext.Put("ID_Marriage", dataRow["ID_Marriage"].ToString()); vltContext.Put("MarriageName", dataRow["MarriageName"].ToString()); vltContext.Put("NationID", dataRow["NationID"].ToString()); vltContext.Put("NationName", dataRow["NationName"].ToString()); } } this.Session["CustomerManage"] = page; } } }
public void PrintCoverReport() { string text = base.GetString("ID_Customer").Trim(); string querySqlCode = "CustomerReportPrintCoverInfoPagesParam"; SqlConditionInfo[] array = new SqlConditionInfo[1]; if (!string.IsNullOrEmpty(text)) { array[0] = new SqlConditionInfo("@ID_Customer", text, TypeCode.Int32); array[0].Blur = 4; } DataTable dataTable = CommonReport.Instance.ExcuteQuerySql(querySqlCode, array).Tables[0]; string msg = JsonHelperFont.Instance.DataTableToJSON(dataTable, dataTable.Rows.Count); this.OutPutMessage(msg); }
DataTable ICommonSubScribe.GetPage(string pageCode, int pageIndex, int pageSize, out int recordCount, out int pageCount, params SqlConditionInfo[] conditions) { DataTable result; try { string[] sqlSentence = this.GetSqlSentence(pageCode); string indexField = sqlSentence[0]; string text = sqlSentence[1]; string text2 = sqlSentence[2]; string text3 = sqlSentence[3]; if (conditions != null) { for (int i = 0; i < conditions.Length; i++) { SqlConditionInfo sqlConditionInfo = conditions[i]; if (sqlConditionInfo != null) { string text4 = sqlConditionInfo.ParamValue.ToString(); if (!string.IsNullOrEmpty(text4) && !(text4 == "-1")) { string text5 = sqlConditionInfo.ParamName; if (text5.IndexOf("@") == -1) { text5 = "@" + text5; } text2 += Util.GetConvertParam2Where(sqlConditionInfo); text2 = text2.Replace(text5, Util.GetStr(sqlConditionInfo)); text3 = text3.Replace(sqlConditionInfo.ParamName, sqlConditionInfo.ParamValue.ToString()); text = text.Replace(text5, Util.GetStr(sqlConditionInfo)); } } } } result = Pagination.ProcPage(text, text2, indexField, text3, pageIndex, pageSize, out recordCount, out pageCount); } catch (SqlException ex) { throw ex; } catch (Exception ex2) { throw new Exception("用于分页的SQL语句无效," + ex2.Message); } return(result); }
public DataSet GetCustomerManageReport(string ID_Customer) { SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@ID_Customer", ID_Customer, System.TypeCode.String) }; DataSet result = null; string querySqlCode = "QueryCustomerReportManage_Param"; try { result = CommonReport.Instance.ExcuteQuerySql(querySqlCode, conditions); } catch (System.Exception var_3_33) { } return(result); }
public void GetCustomerDiseaseLevelInform() { long @int = base.GetInt64("CustomerID", 0L); string querySqlCode = "QueryCust_DiseaseLevelInform_Param"; SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@ID_Customer", @int, TypeCode.Int64) }; if (@int > 0L) { DataSet ds = CommonCustExam.Instance.ExcuteQuerySql(querySqlCode, conditions); string msg = JsonHelperFont.Instance.DataSetToJSON(ds); this.OutPutMessage(msg); } else { this.OutPutMessage(""); } }
public void GetUserAssignedRoleRightItemList() { int @int = base.GetInt("UserID", 0); SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@ID_User", @int, TypeCode.Int32) }; string querySqlCode = "QueryUserAssignedRoleRightItemList_Param"; try { DataSet ds = CommonRight.Instance.ExcuteQuerySql(querySqlCode, conditions); string msg = JsonHelperFont.Instance.DataSetToJSON(ds); this.OutPutMessage(msg); } catch (Exception e) { this.OutPutMessage(""); } }
public void GetSingleNatRoleInfo() { int @int = base.GetInt("ID_Role", 0); SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@ID_Role", @int, TypeCode.Int32) }; string querySqlCode = "QuerySingleNatRole_Param"; try { DataSet ds = CommonConfig.Instance.ExcuteQuerySql(querySqlCode, conditions); string msg = JsonHelperFont.Instance.DataSetToJSON(ds); this.OutPutMessage(msg); } catch (Exception e) { this.OutPutMessage(""); } }
public void GetUserList() { int @int = base.GetInt("pageIndex", 0); int int2 = base.GetInt("pageSize", 10); int totalCount = 0; int num = 0; string text = base.GetString("SearchUserKeyword").Trim(); string pageCode = "QueryPagesUserListParam"; SqlConditionInfo[] array = new SqlConditionInfo[1]; if (!string.IsNullOrEmpty(text)) { pageCode = "QueryPagesUserListParamByName"; array[0] = new SqlConditionInfo("@UserName", text, TypeCode.String); array[0].Blur = 3; array[0].Place = 2; } DataTable page = CommonUser.Instance.GetPage(pageCode, @int, int2, out totalCount, out num, array); string msg = JsonHelperFont.Instance.DataTableToJSON(page, totalCount); this.OutPutMessage(msg); }
public static string GetStrByType(SqlConditionInfo info) { TypeCode paramType = info.ParamType; string result; if (paramType != TypeCode.Char) { switch (paramType) { case TypeCode.DateTime: result = "'" + info.ParamValue + "'"; return(result); case TypeCode.String: goto IL_3B; } result = info.ParamValue.ToString(); return(result); } IL_3B: result = "'" + Input.Filter((string)info.ParamValue) + "'"; return(result); }
public int ISCanReadReport(string ID_Customer) { int result = 0; SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@ID_Customer", ID_Customer, System.TypeCode.String) }; DataSet dataSet = null; string querySqlCode = "QueryISCanReadReport_Param"; try { dataSet = CommonReport.Instance.ExcuteQuerySql(querySqlCode, conditions); } catch (System.Exception var_4_35) { } if (dataSet.Tables[0].Rows.Count > 0) { result = int.Parse(dataSet.Tables[0].Rows[0]["SecurityLevel"].ToString()); } return(result); }
public static string GetStr(SqlConditionInfo info) { string result; switch (info.Blur) { case 1: result = "'%" + info.ParamValue + "'"; break; case 2: result = "'" + info.ParamValue + "%'"; break; case 3: result = "'%" + info.ParamValue + "%'"; break; default: result = Util.GetStrByType(info); break; } return(result); }
public void ViewReport() { string text = base.GetString("ID_Customer").Trim(); string text2 = base.GetString("modelName").Trim().ToLower(); int @int = base.GetInt("pageIndex", 1); int int2 = base.GetInt("pageSize", 10); int totalCount = 0; int num = 0; string pageCode = "CustomerReportPriViewInfoPagesParam"; SqlConditionInfo[] array = null; if (text != string.Empty) { array = new SqlConditionInfo[] { new SqlConditionInfo("@ID_Customer", text, TypeCode.Int32) }; array[0].Blur = 4; } DataTable page = CommonReport.Instance.GetPage(pageCode, @int, int2, out totalCount, out num, array); string msg = JsonHelperFont.Instance.DataTableToJSON(page, totalCount); this.OutPutMessage(msg); }
public void SaveRoleNodeItem() { int num = 0; int @int = base.GetInt("type", 0); int int2 = base.GetInt("txtRoleID", 0); string @string = base.GetString("txtRoleName"); int int3 = base.GetInt("txtDispOrder", 0); int int4 = base.GetInt("IsLockedRole", 0); string string2 = base.GetString("currRightIDsStr"); switch (@int) { case 1: case 2: break; default: num = -2; break; } if (num >= 0) { PEIS.Model.SysRole sysRole = new PEIS.Model.SysRole(); if (@int == 2) { if (int2 > 0) { sysRole = PEIS.BLL.SysRole.Instance.GetModel(int2); } sysRole.RoleID = int2; } sysRole.RoleName = Input.URLDecode(@string); sysRole.DispOrder = int3; sysRole.Is_Locked = int4; sysRole.OperatorID = new int?(this.LoginUserModel.UserID); sysRole.CreateDate = new DateTime?(DateTime.Now); SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@RoleName", sysRole.RoleName, TypeCode.String) }; string querySqlCode = "QueryRoleNameInfo_Param"; try { DataSet dataSet = CommonRight.Instance.ExcuteQuerySql(querySqlCode, conditions); int count = dataSet.Tables[0].Rows.Count; switch (@int) { case 1: if (count > 0) { num = -1; } else { sysRole.Is_DefaultRole = new int?(0); num = PEIS.BLL.SysRole.Instance.Add(sysRole); if (num > 0) { Log4J.Instance.Info(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",新增角色 角色名称:", sysRole.RoleName, ",ID_Role:", num })); } else { Log4J.Instance.Error(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",新增角色失败 角色名称:", sysRole.RoleName, ",ID_Role:", num })); } } break; case 2: if (count > 0 && int.Parse(dataSet.Tables[0].Rows[0][0].ToString()) != sysRole.RoleID) { num = -1; } else { num = (PEIS.BLL.SysRole.Instance.Update(sysRole) ? 1 : 0); if (num > 0) { Log4J.Instance.Info(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",修改角色 角色名称:", sysRole.RoleName, ",ID_Role:", sysRole.RoleID })); } else { Log4J.Instance.Error(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",修改角色失败 角色名称:", sysRole.RoleName, ",ID_Role:", sysRole.RoleID })); } } break; default: num = -2; break; } if (num > 0) { int iD_Role; if (@int == 2) { iD_Role = int2; } else { iD_Role = num; } num = 1 + CommonRight.Instance.OperateRoleRight(iD_Role, string2, this.LoginUserModel.UserID, sysRole.CreateDate.Value); } } catch (Exception ex) { Log4J.Instance.Error(string.Concat(new string[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",角色 错误信息:", ex.Message })); num = 0; } } this.OutPutMessage(num.ToString()); }
public void QueryCustDiseaseLevelList() { string @string = base.GetString("CustomerID"); int @int = base.GetInt("flag", -1); int int2 = base.GetInt("IsInformed", -1); int int3 = base.GetInt("MinLevel", -1); int int4 = base.GetInt("MaxLevel", -1); string text = base.Server.HtmlDecode(base.GetString("BeginExamDate")); string text2 = base.Server.HtmlDecode(base.GetString("EndExamDate")); string text3 = text.Replace("-", string.Empty); string text4 = text2.Replace("-", string.Empty); if (!string.IsNullOrEmpty(text)) { text += " 00:00:00"; } if (!string.IsNullOrEmpty(text2)) { text2 += " 23:59:59"; } int int5 = base.GetInt("pageIndex", 0); int int6 = base.GetInt("pageSize", 10); int totalCount = 0; int num = 0; string pageCode = "QueryCustDiseaseLevelPagesParam"; SqlConditionInfo[] array = new SqlConditionInfo[8]; if (!string.IsNullOrEmpty(@string)) { array[0] = new SqlConditionInfo("@ID_Customer", @string, TypeCode.Int32); array[0].Place = 3; } else { if (int2 >= 0) { array[1] = new SqlConditionInfo("@Is_DiseaseLevelInformed", int2, TypeCode.Int32); array[1].Place = 3; } if (int3 >= 0) { array[2] = new SqlConditionInfo("@DiseaseLevel", int3, TypeCode.Int32); array[2].ParamOper = ">="; array[2].Place = 3; } if (int4 >= 0) { array[3] = new SqlConditionInfo("@DiseaseLevel", int4, TypeCode.Int32); array[3].ParamOper = "<="; array[3].Place = 3; } if (!string.IsNullOrEmpty(text) && Input.IsDate(text)) { array[4] = new SqlConditionInfo("@OperateDate", text, TypeCode.DateTime); array[4].ParamOper = ">="; array[4].Place = 3; } if (!string.IsNullOrEmpty(text2) && Input.IsDate(text2)) { array[5] = new SqlConditionInfo("@OperateDate", text2, TypeCode.DateTime); array[5].ParamOper = "<="; array[5].Place = 3; } } DataTable page = CommonCustExam.Instance.GetPage(pageCode, int5, int6, out totalCount, out num, array); foreach (DataRow dataRow in page.Rows) { if (dataRow["OperateDate"] != null && !string.IsNullOrEmpty(dataRow["OperateDate"].ToString())) { dataRow["OperateDate"] = Convert.ToDateTime(dataRow["OperateDate"].ToString()).ToString("yyyy-MM-dd HH:mm"); } if (dataRow["DiseaseLevelInformedDate"] != null && !string.IsNullOrEmpty(dataRow["DiseaseLevelInformedDate"].ToString())) { dataRow["DiseaseLevelInformedDate"] = Convert.ToDateTime(dataRow["DiseaseLevelInformedDate"].ToString()).ToString("yyyy-MM-dd HH:mm"); } if (dataRow["CheckedDate"] != null && !string.IsNullOrEmpty(dataRow["CheckedDate"].ToString())) { dataRow["CheckedDate"] = Convert.ToDateTime(dataRow["CheckedDate"].ToString()).ToString("yyyy-MM-dd HH:mm"); } } page.AcceptChanges(); string msg = JsonHelperFont.Instance.DataTableToJSON(page, totalCount); this.OutPutMessage(msg); }
public void SaveRoleInfo() { int RoleID = base.GetInt("RoleID", 0); string text = base.GetString("RoleName"); text = Input.URLDecode(text); int int2 = base.GetInt("DispOrder", 500); int arg_47_0 = (base.GetInt("Is_DefaultRole", 0) == 1) ? 1 : 0; string text2 = base.GetString("Remark"); text2 = Input.URLDecode(text2); SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@RoleName", text, TypeCode.String) }; string querySqlCode = "QueryRoleNameIsExis_Param"; try { DataSet dataSet = CommonConfig.Instance.ExcuteQuerySql(querySqlCode, conditions); if (dataSet != null && dataSet.Tables[0].Rows.Count > 0) { if (RoleID <= 0 || dataSet.Tables[0].Rows.Count != 1 || int.Parse(dataSet.Tables[0].Rows[0][0].ToString()) != RoleID) { this.OutPutMessage("-1".ToString()); return; } } } catch (Exception ex) { return; } PEIS.Model.SysRole sysRole; if (RoleID <= 0) { sysRole = new PEIS.Model.SysRole(); } else { sysRole = PEIS.BLL.SysRole.Instance.GetModel(RoleID); } sysRole.RoleID = RoleID; if (RoleID <= 0) { sysRole.CreateDate = new DateTime?(DateTime.Now); } sysRole.RoleName = text; sysRole.DispOrder = int2; sysRole.Remark = text2; sysRole.OperatorID = new int?(this.LoginUserModel.UserID); int num = CommonConfig.Instance.SaveRole(sysRole); int num2 = (RoleID > 0) ? RoleID : num; string text3 = (RoleID > 0) ? "修改" : "新增"; if (num > 0) { Log4J.Instance.Info(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",", text3, "角色 名称:", text, ",编号:", num2 })); } else { Log4J.Instance.Error(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",", text3, "角色失败 名称:", text, ",编号:", num2 })); } this.OutPutMessage(num.ToString()); }
public void GetInformerOrReceiptReport() { string text = base.GetString("ID_Team").Trim().ToLower(); string a = base.GetString("SearchType").Trim().ToLower(); string text2 = base.GetString("IDCard").Trim(); string text3 = base.GetString("ID_Customer").Trim(); string a2 = base.GetString("modelName").Trim().ToLower(); int @int = base.GetInt("pageIndex", 1); int int2 = base.GetInt("pageSize", 10); int totalCount = 0; int num = 0; int num2 = 7; string pageCode = string.Empty; if (a2 == "informer") { int.TryParse(UiConfig.ReportOutDays, out num2); pageCode = "CustomerInformerPagesParam"; } else if (a2 == "receipt") { pageCode = "CustomerReceiptPagesParam"; } SqlConditionInfo[] array = new SqlConditionInfo[6]; if (!string.IsNullOrEmpty(text3)) { array[0] = new SqlConditionInfo("@ID_Customer", text3, TypeCode.Int32); array[0].Blur = 4; } array[1] = new SqlConditionInfo("@SecurityLevel", this.SecurityLevel, TypeCode.Int32); array[1].Place = 2; array[2] = new SqlConditionInfo("@ReportOutDays", num2, TypeCode.Int32); array[2].Place = 2; if (!string.IsNullOrEmpty(text2)) { array[3] = new SqlConditionInfo("@IDCard", text2, TypeCode.String); array[3].Blur = 4; } if (!(a == "0")) { if (a == "1") { array[4] = new SqlConditionInfo("@Is_Team", 0, TypeCode.Int32); array[4].Blur = 4; } else if (a == "2") { array[4] = new SqlConditionInfo("@Is_Team", 1, TypeCode.Int32); array[4].Blur = 4; if (text != "-1") { array[5] = new SqlConditionInfo("@ID_Team", text, TypeCode.Int32); array[5].Blur = 4; } } } DataTable page = CommonReport.Instance.GetPage(pageCode, @int, int2, out totalCount, out num, array); string msg = JsonHelperFont.Instance.DataTableToJSON(page, totalCount); this.OutPutMessage(msg); }
public void GetCustomerManageList() { int @int = base.GetInt("ID_ArcCustomer", -1); int int2 = base.GetInt("pageIndex", 1); int int3 = base.GetInt("pageSize", 10); string text = Input.URLDecode(base.GetString("CustomerName").Trim().ToLower()); string text2 = base.GetString("Gender").Trim().ToLower(); string text3 = base.GetString("IDCard").Trim().ToLower(); string text4 = base.GetString("Birthday").Trim().ToLower(); int totalCount = 0; int num = 0; string pageCode = "QueryCustomerManageListInfoPagesParam"; SqlConditionInfo[] array = new SqlConditionInfo[5]; if (@int > -1) { array[4] = new SqlConditionInfo("@ID_ArcCustomer", @int, TypeCode.Int16); array[4].Place = 3; } else { if (!string.IsNullOrEmpty(text)) { array[0] = new SqlConditionInfo("@CustomerName", text, TypeCode.String); array[0].Blur = 3; array[0].Place = 3; } if (!string.IsNullOrEmpty(text2)) { if (text2 != "-1") { array[1] = new SqlConditionInfo("@ID_Gender", text2, TypeCode.String); array[1].Place = 3; } } if (!string.IsNullOrEmpty(text3)) { array[2] = new SqlConditionInfo("@IDCard", text3, TypeCode.String); array[2].Blur = 3; array[2].Place = 3; } if (!string.IsNullOrEmpty(text4)) { array[3] = new SqlConditionInfo("@BirthDay", text4, TypeCode.String); array[3].Place = 3; } } DataTable page = CommonRegiste.Instance.GetPage(pageCode, int2, int3, out totalCount, out num, array); if (page.Rows.Count > 0) { int count = page.Columns.Count; if (page.Columns.Contains("Photo")) { page.Columns.Add("Base64Photo"); page.Columns.Add("FilePath"); foreach (DataRow dataRow in page.Rows) { if (!Convert.IsDBNull(dataRow["Photo"])) { dataRow["Base64Photo"] = Convert.ToBase64String((byte[])dataRow["Photo"]); } } } } string msg = JsonHelperFont.Instance.DataTableToJSON(page, totalCount); this.OutPutMessage(msg); }
public void SaveRightNodeItem() { int num = 0; int @int = base.GetInt("type", 0); int num2 = base.GetInt("txtRightID", 0); int num3 = base.GetInt("txtCurrentLevel", 0); string @string = base.GetString("txtRightName"); string string2 = base.GetString("txtRightCode"); int value = base.GetInt("txtParentRightID", 0); int int2 = base.GetInt("txtDispOrder", 0); int int3 = base.GetInt("IsLockedRight", 0); switch (@int) { case 1: num3 = 1; value = 0; num2 = 0; break; case 2: num3++; value = num2; num2 = 0; break; case 3: break; default: num = -2; break; } if (num >= 0) { PEIS.Model.SYSRight sysRight = new PEIS.Model.SYSRight(); sysRight.RightID = num2; sysRight.RightLevel = new int?(num3); sysRight.RightName = Input.URLDecode(@string); sysRight.RightCode = Input.URLDecode(string2); sysRight.DispOrder = int2; sysRight.Is_Locked = int3; sysRight.OperatorID = new int?(this.LoginUserModel.UserID); sysRight.CreateDate = DateTime.Now; sysRight.ParentID = new int?(value); SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@RightCode", sysRight.RightCode, TypeCode.String) }; string querySqlCode = "QueryRightCodeInfo_Param"; try { DataSet dataSet = CommonRight.Instance.ExcuteQuerySql(querySqlCode, conditions); int count = dataSet.Tables[0].Rows.Count; switch (@int) { case 1: case 2: if (count > 0) { num = -1; } else { num = PEIS.BLL.SYSRight.Instance.Add(sysRight); if (num > 0) { Log4J.Instance.Info(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",新增权限 权限名称:", sysRight.RightName, ",ID:", num, ",权限值:", sysRight.RightCode })); } else { Log4J.Instance.Error(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",新增权限失败 权限名称:", sysRight.RightName, ",ID:", num, ",权限值:", sysRight.RightCode })); } } break; case 3: if (count > 0 && int.Parse(dataSet.Tables[0].Rows[0][0].ToString()) != sysRight.RightID) { num = -1; } else { num = (PEIS.BLL.SYSRight.Instance.Update(sysRight) ? 1 : 0); if (num > 0) { Log4J.Instance.Info(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",修改权限 权限名称:", sysRight.RightName, ",ID:", sysRight.RightID, ",权限值:", sysRight.RightCode })); } else { Log4J.Instance.Error(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",修改权限失败 权限名称:", sysRight.RightName, ",ID:", sysRight.RightID, ",权限值:", sysRight.RightCode })); } } break; default: num = -2; break; } } catch (Exception ex) { num = 0; } } this.OutPutMessage(num.ToString()); }
public virtual DataTable GetPage(string pageCode, int pageIndex, int pageSize, out int recordCount, out int pageCount, params SqlConditionInfo[] conditions) { string text = string.Empty; string text2 = string.Empty; string text3 = string.Empty; string text4 = string.Empty; DataTable result; try { string[] sqlSentence = this.GetSqlSentence(pageCode); text = sqlSentence[0]; text2 = sqlSentence[1]; text3 = sqlSentence[2]; text4 = sqlSentence[3]; text3 += " as A where 1=1 "; if (conditions != null) { for (int i = 0; i < conditions.Length; i++) { SqlConditionInfo sqlConditionInfo = conditions[i]; if (sqlConditionInfo != null) { string text5 = sqlConditionInfo.ParamValue.ToString(); string text6 = sqlConditionInfo.ParamName; if (sqlConditionInfo.IsSelf) { text3 = text3.Replace(text6, sqlConditionInfo.ParamName.Replace("@", string.Empty)); } if (!string.IsNullOrEmpty(text5) && !(text5 == "-1")) { if (text6.IndexOf("@") == -1) { text6 = "@" + text6; } if (sqlConditionInfo.Place != 2) { text3 += Util.GetConvertParam2Where(sqlConditionInfo); } text3 = text3.Replace(text6, Util.GetStr(sqlConditionInfo)); text4 = text4.Replace(sqlConditionInfo.ParamName, sqlConditionInfo.ParamValue.ToString()); text2 = text2.Replace(text6, Util.GetStr(sqlConditionInfo)); } } } } result = Pagination.ProcPage(text2, text3, text, text4, pageIndex, pageSize, out recordCount, out pageCount); } catch (SqlException ex) { Log4J.Instance.Error(string.Concat(new object[] { "通用查询语句(分页) Exception:", ex.Message, " AllFields:", Secret.AES.Encrypt(text2), ", TablesAndWhere:", Secret.AES.Encrypt(text3), ", IndexField:", text, ", pageIndex:", pageIndex, ", pageSize:", pageSize })); throw ex; } catch (Exception ex2) { Log4J.Instance.Error(string.Concat(new object[] { "通用查询语句(分页) Exception:", ex2.Message, " AllFields:", Secret.AES.Encrypt(text2), ", TablesAndWhere:", Secret.AES.Encrypt(text3), ", IndexField:", text, ", pageIndex:", pageIndex, ", pageSize:", pageSize })); throw new Exception("用于分页的SQL语句无效," + ex2.Message); } return(result); }
public static string GetConvertParam2Where(SqlConditionInfo con) { string text = string.Empty; if (con.Blur == 1 || con.Blur == 2 || con.Blur == 3) { text = string.Concat(new string[] { text, " and ", con.ParamName.Replace("@", ""), " like ", con.ParamName }); } else if (!string.IsNullOrEmpty(con.ParamOper)) { if (con.ParamType == TypeCode.DateTime) { text = string.Concat(new string[] { text, " and datediff( day,'", con.ParamValue.ToString().Replace("上午", "").Replace("下午", ""), "',", con.ParamName.Replace("@", ""), " ) ", con.ParamOper, " 0 " }); } else if (con.ParamType == TypeCode.Decimal || con.ParamType == TypeCode.Double || con.ParamType == TypeCode.Int16 || con.ParamType == TypeCode.Int32 || con.ParamType == TypeCode.Int64 || con.ParamType == TypeCode.UInt16 || con.ParamType == TypeCode.UInt32 || con.ParamType == TypeCode.UInt64) { text = string.Concat(new string[] { text, " and ", con.ParamName.Replace("@", ""), con.ParamOper, con.ParamName }); } else { text = string.Concat(new string[] { text, " and ", con.ParamName.Replace("@", ""), " = ", con.ParamName }); } } else { text = string.Concat(new string[] { text, " and ", con.ParamName.Replace("@", ""), " = ", con.ParamName }); } return(text); }
public void PrintReport() { int @int = base.GetInt("containCheck", 0); string text = base.GetString("ID_Team").Trim().ToLower(); string a = base.GetString("SearchType").Trim().ToLower(); string text2 = base.GetString("ID_Customer").Trim(); string text3 = base.GetString("modelName").Trim().ToLower(); int int2 = base.GetInt("pageIndex", 1); int int3 = base.GetInt("pageSize", 10); int totalCount = 0; int num = 0; string paramvalue = DateTime.Now.AddDays(-15.0).ToString("yyyy-MM-dd 00:00:01"); DataTable dt = null; if (a == "0") { SqlConditionInfo[] array = new SqlConditionInfo[3]; string pageCode; if (@int == 1) { pageCode = "CustomerReportPrintInfoPagesParamNoCheck"; } else { pageCode = "CustomerReportPrintInfoPagesParam"; } if (!string.IsNullOrEmpty(text2)) { array[0] = new SqlConditionInfo("@ID_Customer", text2, TypeCode.Int32); array[0].Blur = 4; } else { array[2] = new SqlConditionInfo("@CheckedDate", paramvalue, TypeCode.DateTime); array[2].ParamOper = ">="; } array[1] = new SqlConditionInfo("@SecurityLevel", this.SecurityLevel, TypeCode.Int32); array[1].Place = 2; dt = CommonReport.Instance.GetPage(pageCode, int2, int3, out totalCount, out num, array); } else if (a == "1") { string pageCode = "CustomerReportPrintSelfInfoPagesParam"; SqlConditionInfo[] array = new SqlConditionInfo[3]; if (!string.IsNullOrEmpty(text2)) { array[0] = new SqlConditionInfo("@ID_Customer", text2, TypeCode.Int32); array[0].Blur = 4; } else { array[2] = new SqlConditionInfo("@CheckedDate", paramvalue, TypeCode.DateTime); array[2].ParamOper = ">="; } array[1] = new SqlConditionInfo("@SecurityLevel", this.SecurityLevel, TypeCode.Int32); array[1].Place = 2; dt = CommonReport.Instance.GetPage(pageCode, int2, int3, out totalCount, out num, array); } else if (a == "2") { string pageCode = "CustomerReportPrintTeamInfoPagesParam"; SqlConditionInfo[] array = new SqlConditionInfo[3]; if (!string.IsNullOrEmpty(text2)) { array[0] = new SqlConditionInfo("@ID_Customer", text2, TypeCode.Int32); array[0].Blur = 4; } else { if (text != "-1") { array[0] = new SqlConditionInfo("@ID_Team", text, TypeCode.Int32); array[0].Blur = 4; } array[2] = new SqlConditionInfo("@CheckedDate", paramvalue, TypeCode.DateTime); array[2].ParamOper = ">="; } array[1] = new SqlConditionInfo("@SecurityLevel", this.SecurityLevel, TypeCode.Int32); array[1].Place = 2; dt = CommonReport.Instance.GetPage(pageCode, int2, int3, out totalCount, out num, array); } string msg = JsonHelperFont.Instance.DataTableToJSON(dt, totalCount); this.OutPutMessage(msg); }
public void GetCustomerSecurityLevelList() { int @int = base.GetInt("OperateLevel", -1); int int2 = base.GetInt("TeamID", -1); int int3 = base.GetInt("TeamTaskID", -1); int int4 = base.GetInt("SecurityLevel", -1); string text = base.GetString("ID_Customer").Trim().ToLower(); string text2 = Input.URLDecode(base.GetString("CustomerName").Trim().ToLower()); string text3 = base.GetString("modelName").Trim().ToLower(); int int5 = base.GetInt("pageIndex", 1); int int6 = base.GetInt("pageSize", 10); string text4 = base.Server.HtmlDecode(base.GetString("BeginExamDate")); string text5 = base.Server.HtmlDecode(base.GetString("EndExamDate")); int totalCount = 0; int num = 0; if (!string.IsNullOrEmpty(text4)) { text4 += " 00:00:00"; } if (!string.IsNullOrEmpty(text5)) { text5 += " 23:59:59"; } string pageCode = "QueryCustomerSecurityLevelListInfoPagesParam"; SqlConditionInfo[] array = new SqlConditionInfo[6]; if (!string.IsNullOrEmpty(text)) { array[2] = new SqlConditionInfo("@ID_Customer", text, TypeCode.Int64); } else { if (int2 != -1) { array[0] = new SqlConditionInfo("@ID_Team", int2, TypeCode.Int32); } if (int3 != -1) { array[1] = new SqlConditionInfo("@ID_TeamTask", int3, TypeCode.Int32); } if (!string.IsNullOrEmpty(text2)) { array[3] = new SqlConditionInfo("@CustomerName", text2, TypeCode.String); array[3].Blur = 3; array[3].Place = 3; } if (int4 != -1) { array[4] = new SqlConditionInfo("@SecurityLevel", int4, TypeCode.Int64); } else { array[4] = new SqlConditionInfo("@SecurityLevel", @int, TypeCode.Int64); array[4].ParamOper = "<="; } } DataTable page = CommonRegiste.Instance.GetPage(pageCode, int5, int6, out totalCount, out num, array); string msg = JsonHelperFont.Instance.DataTableToJSON(page, totalCount); this.OutPutMessage(msg); }
public void DeleteRoleNodeItem() { int @int = base.GetInt("txtRoleID", 0); int num = 0; SqlConditionInfo[] conditions = new SqlConditionInfo[] { new SqlConditionInfo("@ID_Role", @int, TypeCode.Int32) }; string querySqlCode = "QueryRoleUsedCount_Param"; try { DataSet dataSet = CommonRight.Instance.ExcuteQuerySql(querySqlCode, conditions); num = int.Parse(dataSet.Tables[0].Rows[0][0].ToString()); } catch (Exception ex) { Log4J.Instance.Error(string.Concat(new string[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",删除角色 错误信息:", ex.Message })); } int num2; if (num > 0) { num2 = -1; } else { PEIS.Model.SysRole model = PEIS.BLL.SysRole.Instance.GetModel(@int); if (model.Is_DefaultRole == 1) { num2 = -2; } else { num2 = CommonRight.Instance.DeleteRole(@int); if (num2 > 0) { Log4J.Instance.Info(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",删除角色 ID_Role:", model.RoleID })); } else { Log4J.Instance.Error(string.Concat(new object[] { Public.GetClientIP(), ",", this.LoginUserModel.UserName, ",删除角色失败 ID_Role:", model.RoleID })); } } } this.OutPutMessage(num2.ToString()); }
public virtual DataSet ExcuteQuerySql(string QuerySqlCode, params SqlConditionInfo[] conditions) { int num = 0; string text = string.Empty; DataSet result; try { string[] sqlSentence = this.GetSqlSentence(QuerySqlCode); if (sqlSentence.Length > 0) { text = sqlSentence[0].ToString(); } if (!string.IsNullOrEmpty(text) && conditions != null) { for (int i = 0; i < conditions.Length; i++) { SqlConditionInfo sqlConditionInfo = conditions[i]; if (sqlConditionInfo != null) { string text2 = sqlConditionInfo.ParamValue.ToString(); if (!string.IsNullOrEmpty(text2)) { string text3 = sqlConditionInfo.ParamName; if (text3.IndexOf("@") == -1) { text3 = "@" + text3; } if (text3 == "@CustomerExamState") { try { num = int.Parse(text2); } catch (Exception var_6_DB) { num = 0; } } text = text.Replace(text3, Util.GetStr(sqlConditionInfo)); } } } } if (num > 0) { string connectionString; if (num == 1) { connectionString = PubConstant.GetConnectionString("ToOffLineConnectionString"); } else { connectionString = PubConstant.GetConnectionString("FYH_HisFile" + (num - 1).ToString().PadLeft(3, '0')); } result = DbHelperSQL.Query(connectionString, text); return(result); } result = DbHelperSQL.Query(text); return(result); } catch (Exception ex) { Log4J.Instance.Error("通用查询语句(不分页) Exception:" + ex.Message + " Sql:" + Secret.AES.Encrypt(text)); } result = null; return(result); }