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 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();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.Master.LBTitle = "乡镇财政资金监管信息系统 - 查看操作日志";
this.Master.strTitle = "查看操作日志";
this.Master.TitlePic = "~/images/页标题/查看操作日志.jpg";
this.Master.ButtonsPushDown = new ButtonsHandler(this.Buttons);
if (!this.Page.IsPostBack)
{
if (this.Session["User"] != null)
{
if (base.Request.QueryString["PK"] == null)
{
return;
}
DB_OPT dbo = null;
try
{
try
{
string userName = ((UserModel)this.Session["User"]).UserName;
string power = ((UserModel)this.Session["User"]).Power;
ButtonsModel model = new ButtonsModel(userName);
if (PowerClass.IfHasPower(userName, power, PowerNum.ServicesMessUpdate))
{
model.IfRefresh = true;
model.IfExit = true;
this.Master.btModel = model;
dbo = new DB_OPT();
dbo.Open();
this.SetValue(dbo);
}
else
{
Const.SorryForPower(this.Page);
}
}
catch (Exception exception)
{
new ExceptionLog.ExceptionLog { ErrClassName = base.GetType().ToString(), ErrMessage = exception.Message.ToString(), ErrMethod = "Page_Load()" }.WriteExceptionLog(true);
Const.OpenErrorPage("获取数据失败，请联系管理员！", this.Page);
}
return;
}
finally
{
dbo.Close();
}
}
Const.GoLoginPath_Open(this.Page);
}
}
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 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 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 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 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 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 ";
}