public static string GetUserCompany(string username) { string str = "false"; DB_OPT dbo = null; try { dbo = new DB_OPT(); dbo.Open(); string str2 = ""; UserDal.GetCompanyPK(username.Trim(), ref str2, dbo); if (str2 != "") { string ccode = ""; string cname = ""; CompanyDal.GetCompanyName(str2, ref ccode, ref cname, dbo); str = ccode + "," + cname; } } catch (Exception exception) { new ExceptionLog.ExceptionLog { ErrClassName = "UserBll", ErrMessage = exception.Message.ToString(), ErrMethod = "GetUserCompany()" }.WriteExceptionLog(true); } finally { if (dbo != null) { dbo.Close(); } } return str; }
public static int insertOp(string opType, string Business, string Content, string ifPass, Page page) { int num = 0; DB_OPT dbo = null; try { OperationLogModel model = new OperationLogDal(); dbo = new DB_OPT(); dbo.Open(); string userName = ""; if (((UserModel) HttpContext.Current.Session["user"]).TrueName == "") { userName = ((UserModel) HttpContext.Current.Session["user"]).UserName; } else { userName = ((UserModel) HttpContext.Current.Session["user"]).TrueName; } model.UserName = userName; model.opType = opType; model.Business = Business; model.Content = Content; model.ifPass = ifPass; num = model.Add(dbo); } catch (Exception exception) { new ExceptionLog.ExceptionLog { ErrClassName = "OperationLogBll", ErrMessage = exception.Message.ToString(), ErrMethod = "insertOp()" }.WriteExceptionLog(true); Const.OpenErrorPage("操作失败,请联系管理员!", page); } finally { if (dbo != null) { dbo.Close(); } } return num; }
public static bool TryCon(string strCon) { bool flag = false; DB_OPT db_opt = null; try { db_opt = new DB_OPT(); db_opt.OpenTest(strCon); flag = true; } catch (Exception exception) { new ExceptionLog.ExceptionLog { ErrClassName = "EIP_User.Login", ErrMessage = exception.Message.ToString(), ErrMethod = "TryCon()" }.WriteExceptionLog(true); } finally { if (db_opt != null) { db_opt.Close(); } } return flag; }
public static void deleteOp(string pk, Page page) { DB_OPT db = null; try { OperationLogModel model = new OperationLogDal(); db = new DB_OPT(); db.Open(); model.pk = pk; model.Delete(db); } catch (Exception exception) { new ExceptionLog.ExceptionLog { ErrClassName = "OperationLogBll", ErrMessage = exception.Message.ToString(), ErrMethod = "deleteOp()" }.WriteExceptionLog(true); Const.OpenErrorPage("操作失败,请联系管理员!", page); } finally { if (db != null) { db.Close(); } } }
private void IsPower() { DB_OPT dbo = new DB_OPT(); try { UserModel model = new UserDal { UserName = ((UserModel)HttpContext.Current.Session["User"]).UserName }; model.GetModel(dbo); string[] strArray = model.CompanyPower.Split(new char[] { '|' }); for (int i = 0; i < strArray.Length; i++) { strArray[i].Trim(); } } catch (Exception) { } finally { dbo.Close(); } }
public int ChangePwd(string struser, string strpwd, string strOpwd) { int num; UserModel model = new UserDal(); DB_OPT dbo = new DB_OPT(); try { dbo.Open(); model.UserName = struser; model.Password = QxRoom.QxConst.QxConst.Encrypt(strOpwd, "powerich"); num = model.UpdatePwd(strpwd, dbo); } catch (Exception exception) { throw exception; } finally { dbo.Close(); } return num; }
public DataSet UserName(string struser) { DataSet list; UserModel model = new UserDal(); DB_OPT dbo = new DB_OPT(); try { dbo.Open(); model.UserPK = struser; list = model.GetList(" UserPK='" + model.UserPK + "'", dbo); } catch (Exception exception) { throw exception; } finally { dbo.Close(); } return list; }
public DataSet userinfo(string strwhere) { DataSet listAll; UserModel model = new UserDal(); DB_OPT dbo = new DB_OPT(); try { dbo.Open(); listAll = model.GetListAll(strwhere, dbo); } catch (Exception exception) { throw exception; } finally { dbo.Close(); } return listAll; }
public int Updateuserinfo(string strUser, string power, string strname, string pk_corp) { int num; UserModel model = new UserDal(); DB_OPT dbo = new DB_OPT(); try { dbo.Open(); model.EmployeePK = strUser; model.UserName = strname; model.Power = power; model.pk_corp = pk_corp; num = model.Update(UserUpdatePowerType.BranchAndRole, UserUpdateIndex.AllowEmployeePK, dbo); } catch (Exception exception) { throw exception; } finally { dbo.Close(); } return num; }
public UserModel Login(string struser) { UserModel model; UserModel model2 = new UserDal(); DB_OPT dbo = new DB_OPT(); try { dbo.Open(); model2.UserName = struser; model2.Login(dbo); ConfigurationModel model3 = new ConfigurationDal().GetModel(dbo); if (model3 != null) { HttpContext.Current.Response.Cookies["ischangelist"].Value = model3.ISCHANGELIST; HttpContext.Current.Session["common"] = model3; if (model3.ErrMessPath != "") { ExceptionLog.ExceptionLog log = new ExceptionLog.ExceptionLog { LogFilePath = model3.ErrMessPath }; } } model = model2; } catch (Exception exception) { throw exception; } finally { dbo.Close(); } return model; }
public int IsHaveData(string emppk) { int num; UserModel model = new UserDal(); DB_OPT dbo = new DB_OPT(); try { dbo.Open(); model.EmployeePK = emppk; num = model.ExistsByEmpPK(dbo); } catch (Exception exception) { throw exception; } finally { dbo.Close(); } return num; }
public string deleteuserinfo(string strUser, Page page) { string str2; string str = ""; UserModel model = new UserDal(); DB_OPT dbo = new DB_OPT(); try { dbo.Open(); model.UserPK = strUser; model.GetModel(dbo); if (model.UserName == "admin") { return "admin"; } model.Delete(dbo); OperationLogBll.insertOp("删除", "用户列表", "删除 " + model.cName + " 单位, " + model.bName + "部门下用户名为:" + model.UserName + " 真实姓名为:" + model.TrueName + " 的用户", "Y", page); str2 = str; } catch (Exception exception) { throw exception; } finally { dbo.Close(); } return str2; }
public static string btn_tb() { string str = ""; StringBuilder builder = new StringBuilder(); builder.Append("select distinct gsdm as PK_CORP,gsmc as Name,case len(gsdm) when 2 then 1 else 0 end as ISHASBABY,case len(gsdm) when 2 then 0 else 1 end as Grade,substring(gsdm,1,2) as FatherPK,substring(gsdm,1,2)+'|' as PKPath,'0' as ZXBJ from PubGszl where kjnd=(select max(kjnd) from PubGszl)"); builder.Append(" and gsdm in "); builder.Append(strSelectDW); builder.Append(" ; "); builder.Append("select gsdm as PK_CORP,kjnd,bmdm as BH,bmmc as Name from PUBBMXX where kjnd=(select max(kjnd) from PUBBMXX );"); builder.Append(" and gsdm in "); builder.Append(strSelectDW); builder.Append(" ; "); builder.Append("select gsdm,kjnd,zydm,zyxm,bmdm from PUBZYXX where kjnd=(select max(kjnd) from PUBZYXX );"); builder.Append(" and gsdm in "); builder.Append(strSelectDW); builder.Append(" ; "); builder.Append("select ID,name as UserName,password,gsdm as PK_CORP from gl_CZY;"); builder.Append(" and gsdm in "); builder.Append(strSelectDW); builder.Append(" ; "); DataSet set = DbHelperSQL.Query(builder.ToString()); DB_OPT dbo = new DB_OPT(); dbo.Open(); if ((set == null) || (set.Tables.Count != 4)) { return str; } DataTable table = set.Tables[0]; for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; CompanyModel model = new CompanyDal { pk_corp = row["PK_CORP"].ToString(), Name = row["Name"].ToString(), IsHasBaby = row["ISHASBABY"].ToString(), Grade = Convert.ToInt32(row["Grade"].ToString()), FatherPK = row["FatherPK"].ToString(), PKPath = row["PKPath"].ToString(), ZXBJ = row["ZXBJ"].ToString() }; builder = new StringBuilder(); builder.Append("select * from DB_Company where pk_corp='"); builder.Append(model.pk_corp); builder.Append("'"); if (DbHelperOra.Exists(builder.ToString())) { builder = new StringBuilder(); builder.Append("update Db_Company set IsHasBaby='"); builder.Append(model.IsHasBaby); builder.Append("',Grade="); builder.Append(model.Grade); builder.Append(",FatherPK='"); builder.Append(model.FatherPK); builder.Append("',PKPath='"); builder.Append(model.PKPath); builder.Append("',ZXBJ='"); builder.Append(model.ZXBJ); builder.Append("' where PK_CORP='"); builder.Append(model.pk_corp); builder.Append("' "); DbHelperOra.ExecuteSql(builder.ToString()); } else { builder = new StringBuilder(); builder.Append("insert into Db_Company(pk_corp,Name,Ishasbaby,Grade,FatherPK,PKPath,ZXBJ) values('"); builder.Append(model.pk_corp); builder.Append("','"); builder.Append(model.Name); builder.Append("','"); builder.Append(model.IsHasBaby); builder.Append("',"); builder.Append(model.Grade); builder.Append(",'"); builder.Append(model.FatherPK); builder.Append("','"); builder.Append(model.PKPath); builder.Append("','"); builder.Append(model.ZXBJ); builder.Append("')"); DbHelperOra.ExecuteSql(builder.ToString()); builder = new StringBuilder(); builder.Append("insert into db_branch(BranchPK,BH,Name,ISHasbaby,grade,PK_CORP,ISJGBM) values (sys_Guid(),'D"); builder.Append(model.pk_corp); builder.Append("01','"); builder.Append(model.Name); builder.Append("默认部门',0,0,'"); builder.Append(model.pk_corp); builder.Append("',0)"); DbHelperOra.ExecuteSql(builder.ToString()); builder = new StringBuilder(); builder.Append("insert into db_role(RolePK,BH,Name,Power,ServicesPower,ISUserPower,Grade,BranchPK,PK_CORP )"); builder.Append("select sys_guid(),'R"); builder.Append(model.pk_corp); builder.Append("01','"); builder.Append(model.Name); builder.Append("默认角色',"); builder.Append("Power,ServicesPower,ISUserPower,Grade,(select BranchPK from Db_Branch where BH='D"); builder.Append(model.pk_corp); builder.Append("01' and Rownum=1),'"); builder.Append(model.pk_corp); builder.Append("' from db_role t where BH='R000000' "); DbHelperOra.ExecuteSql(builder.ToString()); } } table = set.Tables[1]; for (int j = 0; j < table.Rows.Count; j++) { DataRow row2 = table.Rows[j]; BranchModel model2 = new BranchDal { BH = row2["BH"].ToString(), Name = row2["Name"].ToString(), pk_corp = row2["PK_CORP"].ToString() }; if (model2.Exists(model2.BH, dbo) > 0) { model2.Update(dbo); } else { model2.Add(dbo); } } table = set.Tables[3]; for (int k = 0; k < table.Rows.Count; k++) { DataRow row3 = table.Rows[k]; UserModel model3 = new UserDal { UserName = row3["UserName"].ToString().Trim(), TrueName = row3["UserName"].ToString(), Password = QxRoom.QxConst.QxConst.Encrypt(row3["password"].ToString(), "powerich") }; if (string.IsNullOrEmpty(row3["PK_CORP"].ToString())) { model3.pk_corp = "01"; } else { model3.pk_corp = row3["PK_CORP"].ToString(); } if (model3.ExistsByUserName(dbo) > 0) { builder = new StringBuilder(); builder.Append("update DB_Users set Password ='******' , PK_Corp='"); builder.Append(model3.pk_corp); builder.Append("' , TrueName='"); builder.Append(model3.UserName); builder.Append("' where UserName='******'"); DbHelperOra.ExecuteSql(builder.ToString()); } else { builder = new StringBuilder(); builder.Append("insert into Db_Users(UserName,TrueName,Password,pk_corp,BranchPK,RolePK) values('"); builder.Append(model3.UserName); builder.Append("','"); builder.Append(model3.UserName); builder.Append("','"); builder.Append(model3.Password); builder.Append("','"); builder.Append(model3.pk_corp); builder.Append("',(select BranchPK from Db_Branch where BH='D"); builder.Append(model3.pk_corp); builder.Append("01' and Rownum=1),(SELECT rolepk FROM db_role WHERE BH='R"); builder.Append(model3.pk_corp); builder.Append("01' and Rownum=1))"); DbHelperOra.ExecuteSql(builder.ToString()); builder = new StringBuilder(); builder.Append("update db_users a set (a.Power, a.servicespower)= (select b.Power, b.servicespower from Db_Role b where a.RolePK=b.RolePK) where length(a.pk_corp)<=4"); DbHelperOra.ExecuteSql(builder.ToString()); } } dbo.Close(); StringBuilder builder2 = new StringBuilder(); builder2.Append("已成功同步乡财县管系统的基础数据! 本次共同步【单位数据】:"); builder2.Append(set.Tables[0].Rows.Count); builder2.Append(" 条;【部门数据】:"); builder2.Append(set.Tables[1].Rows.Count); builder2.Append(" 条;【人员数据】:"); builder2.Append(set.Tables[3].Rows.Count); builder2.Append(" 条"); return builder2.ToString(); }
public static string GetCompanyWhereZB() { UserModel model = (UserModel) HttpContext.Current.Session["User"]; string str = model.Company.pk_corp; string str2 = ""; if ((str != null) && (str.Trim() != "")) { DB_OPT dbo = new DB_OPT(); try { try { dbo.Open(); UserModel model2 = new UserDal { UserName = model.UserName }; model2.GetModel(dbo); string[] strArray = model2.CompanyPower.Split(new char[] { '|' }); string str3 = ""; for (int i = 0; i < strArray.Length; i++) { str3 = str3 + strArray[i].Trim(); if (i < (strArray.Length - 1)) { str3 = str3 + "','"; } } if (str3 != "") { str3 = "'" + str3 + "'"; return (" and ((trim(PD_QUOTA_INPUT_DEPART)='" + model.Branch.BH.Trim() + "' and trim(PD_QUOTA_INPUT_COMPANY)='" + str.Trim() + "') or trim(PD_QUOTA_DEPART) in (" + str3 + ") or (pd_quota_isup=1 and IF_SHOW=1 and company_code='" + str.Trim() + "'))"); } return (" and ((trim(PD_QUOTA_INPUT_DEPART)='" + model.Branch.BH.Trim() + "' and trim(PD_QUOTA_INPUT_COMPANY)='" + str.Trim() + "') or (pd_quota_isup=1 and IF_SHOW=1 and company_code='" + str.Trim() + "'))"); } catch (Exception) { str2 = " and 1=0 "; } return str2; } finally { if (dbo != null) { dbo.Close(); } } } return " and 1=0 "; }
public static string GetCompanyWhere() { string str = HttpContext.Current.Session["pk_corp"].ToString(); string str2 = ""; if ((str != null) && (str.Trim() != "")) { DB_OPT dbo = new DB_OPT(); try { try { dbo.Open(); UserModel model = new UserDal { UserName = ((UserModel) HttpContext.Current.Session["User"]).UserName }; model.GetModel(dbo); string[] strArray = model.CompanyPower.Split(new char[] { '|' }); string str3 = ""; for (int i = 0; i < strArray.Length; i++) { str3 = str3 + strArray[i].Trim(); if (i < (strArray.Length - 1)) { str3 = str3 + "','"; } } if (str3 != "") { str3 = "'" + str3 + "'"; return (" and (trim(PD_PROJECT_INPUT_COMPANY) like '" + str.Trim() + "%' and trim(PD_PROJECT_INPUT_COMPANY) in (" + str3 + "))"); } return " and 1=0"; } catch (Exception) { str2 = " and 1=0 "; } return str2; } finally { if (dbo != null) { dbo.Close(); } } } return " and 1=0 "; }