public static void ChangeChildPkPath(string pk_corp, string pkpath, int grade, DB_OPT dbo)
{
CompanyModel model = new CompanyDal();
CompanyModel[] modelArray = model.GetChilds(pk_corp, false, dbo);
if (modelArray != null)
{
for (int i = 0; i < modelArray.Length; i++)
{
model.pk_corp = modelArray[i].pk_corp;
model.Grade = grade;
model.PKPath = pkpath;
model.UpdatePKPathAndGrade(dbo);
if (modelArray[i].IsHasBaby == "1")
{
ChangeChildPkPath(modelArray[i].pk_corp, pkpath + model.pk_corp + "|", grade + 1, dbo);
}
}
}
else
{
model.pk_corp = pk_corp;
model.IsHasBaby = "0";
model.UpdateHasBaby(dbo);
}
}
public string GetStrParent(string pkpath)
{
string str;
try
{
string str2 = "";
this.dbo = new DB_OPT();
this.dbo.Open();
CompanyModel[] parents = new CompanyDal { PKPath = pkpath }.GetParents(false, this.dbo);
for (int i = 0; i < parents.Length; i++)
{
str2 = parents[i].pk_corp + "~" + str2;
}
str = str2.Substring(0, str2.Length - 1);
}
catch (Exception)
{
str = "";
}
finally
{
if (this.dbo != null)
{
this.dbo.Close();
}
}
return str;
}
private void BindList(DB_OPT dbo)
{
CompanyModel[] modelArray = new CompanyDal().GetModels("", false, false, false, dbo);
this.ddlcompany.DataSource = modelArray;
this.ddlcompany.DataTextField = "Name";
this.ddlcompany.DataValueField = "pk_corp";
this.ddlcompany.DataBind();
BranchModel[] modelArray2 = new BranchDal().GetModels("", false, false, false, false, dbo);
this.ddlbranch.DataSource = modelArray2;
this.ddlbranch.DataTextField = "Name";
this.ddlbranch.DataValueField = "BranchPK";
this.ddlbranch.DataBind();
}
private CompanyModel Getcm(DataRow dr, bool bj_child, bool bj_father, bool bj_branch, DB_OPT dbo)
{
CompanyModel model = new CompanyDal();
if (bj_father)
{
model.pk_corp = dr["FatherPK"].ToString();
model.FatherInfo = model.GetModel(false, false, true, dbo);
}
model.pk_corp = dr["pk_corp"].ToString();
model.Name = dr["Name"].ToString();
model.ShortName = dr["ShortName"].ToString();
model.KeyChar = dr["KeyChar"].ToString();
model.Country = dr["Country"].ToString();
model.Province = dr["Province"].ToString();
model.Area = dr["Area"].ToString();
model.Address = dr["Address"].ToString();
model.PostalCode = dr["PostalCode"].ToString();
model.Url = dr["Url"].ToString();
model.Email1 = dr["Email1"].ToString();
model.Email2 = dr["Email2"].ToString();
model.Email3 = dr["Email3"].ToString();
model.Phone1 = dr["Phone1"].ToString();
model.Phone2 = dr["Phone2"].ToString();
model.Phone3 = dr["Phone3"].ToString();
model.Fax1 = dr["Fax1"].ToString();
model.Fax2 = dr["Fax2"].ToString();
model.Fax3 = dr["Fax3"].ToString();
model.linkman1 = dr["linkman1"].ToString();
model.linkman2 = dr["linkman2"].ToString();
model.Holder = dr["Holder"].ToString();
if (dr["RegMoney"].ToString() != "")
{
model.RegMoney = decimal.Parse(dr["RegMoney"].ToString());
}
model.BankPK = dr["BankPK"].ToString().Trim();
model.FPDWM = dr["FPDWM"].ToString();
model.InvoiceType = dr["InvoiceType"].ToString();
model.DutyNum = dr["DutyNum"].ToString();
model.Discription = dr["Discription"].ToString();
model.FatherPK = dr["FatherPK"].ToString().Trim();
model.IsHasBaby = dr["IsHasBaby"].ToString();
if (dr["Grade"].ToString() != "")
{
model.Grade = int.Parse(dr["Grade"].ToString());
}
model.PKPath = dr["PKPath"].ToString();
model.ZXBJ = dr["ZXBJ"].ToString();
if (bj_father)
{
model.Childs_Branch = new BranchDal().GetModels("pk_corp='" + dr["pk_corp"].ToString() + "'", false, false, false, true, dbo);
}
if ((dr["IsHasBaby"].ToString() == "1") && !bj_child)
{
model.Childs_Company = this.GetChilds(model.pk_corp, true, dbo);
}
return model;
}
private void BindTV(DB_OPT dbo)
{
DataSet list;
CompanyModel model = new CompanyDal();
string str = ((UserModel)this.Session["User"]).CompanyPower.Replace("|", "','");
str = "'" + str + "'";
if (!((UserModel)this.Session["User"]).UserName.Equals("admin"))
{
StringBuilder builder = new StringBuilder();
builder.Append(" pk_corp in (");
builder.Append(str);
builder.Append(")");
builder.Append(" and pk_corp like '");
builder.Append(((UserModel)this.Session["User"]).Company.pk_corp.Trim());
builder.Append("%' ");
list = model.GetList(builder.ToString(), dbo);
}
else
{
list = model.GetList("1=1 ", dbo);
}
this.GetTreeView(list);
}
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();
}
private EmployeeModel Getem(DataRow dr, bool bj_child, bool bj_father, bool bj_company, bool bj_branch, bool bj_role, DB_OPT dbo)
{
EmployeeModel model = new EmployeeModel();
if (bj_father)
{
model.BranchPK = dr["FatherPK"].ToString();
model.FatherInfo = model.GetModel(false, false, false, false, true, dbo);
}
model.BranchPK = dr["BranchPK"].ToString().Trim();
if (bj_branch)
{
BranchModel model2 = new BranchDal
{
BranchPK = dr["BranchPK"].ToString()
};
model2 = model2.GetModel(false, false, false, false, dbo);
model.Branch = model2;
}
model.RolePK = dr["RolePK"].ToString().Trim();
if (bj_role)
{
RoleModel model3 = new RoleDal
{
RolePK = dr["RolePK"].ToString()
};
model3 = model3.GetModel(false, false, dbo);
model.Role = model3;
}
model.BH = dr["BH"].ToString();
model.Name = dr["Name"].ToString();
model.CardNum = dr["CardNum"].ToString();
model.Sex = dr["Sex"].ToString();
if (dr["Age"].ToString() != "")
{
model.Age = int.Parse(dr["Age"].ToString());
}
if (dr["WorkAge"].ToString() != "")
{
model.WorkAge = int.Parse(dr["WorkAge"].ToString());
}
if (dr["BirthDay"].ToString() != "")
{
model.BirthDay = DateTime.Parse(dr["BirthDay"].ToString());
}
model.MZ = dr["MZ"].ToString();
model.Nationals = dr["Nationals"].ToString();
model.Province = dr["Province"].ToString();
model.Area = dr["Area"].ToString();
model.City = dr["City"].ToString();
model.Address = dr["Address"].ToString();
model.PostalCode = dr["PostalCode"].ToString();
model.OfficePhone = dr["OfficePhone"].ToString();
model.Phone = dr["Phone"].ToString();
model.Mobile1 = dr["Mobile1"].ToString();
model.Mobile2 = dr["Mobile2"].ToString();
model.Mobile3 = dr["Mobile3"].ToString();
model.QQNum = dr["QQNum"].ToString();
model.ICQNum = dr["ICQNum"].ToString();
model.MSNNum = dr["MSNNum"].ToString();
model.Email = dr["Email"].ToString();
model.OtherLink = dr["OtherLink"].ToString();
model.pk_corp = dr["pk_corp"].ToString();
if (bj_company)
{
CompanyModel model4 = new CompanyDal
{
pk_corp = dr["pk_corp"].ToString()
};
model4 = model4.GetModel(false, false, false, dbo);
model.Company = model4;
}
model.FatherPK = dr["FatherPK"].ToString().Trim();
model.IsHasBaby = dr["IsHasBaby"].ToString();
if (dr["Grade"].ToString() != "")
{
model.Grade = int.Parse(dr["Grade"].ToString());
}
model.PKPath = dr["PKPath"].ToString();
if ((dr["IsHasBaby"].ToString() == "1") && bj_child)
{
this.GetChilds(model.EmployeePK, false, false, false, dbo);
}
return model;
}
public CompanyModel[] GetCompany(string parentid)
{
CompanyModel[] modelArray;
try
{
this.dbo = new DB_OPT();
this.dbo.Open();
modelArray = new CompanyDal().GetModels("FatherPK='" + parentid.Split(new char[] { '|' })[0] + "'", false, false, true, this.dbo);
}
catch (Exception)
{
modelArray = null;
}
finally
{
if (this.dbo != null)
{
this.dbo.Close();
}
}
return modelArray;
}
private void UpdateCompany()
{
try
{
this.dbo = new DB_OPT();
this.dbo.Open();
if ((this.txtName.Text.Trim() == "") || (this.txtpk_corp.Text.Trim() == ""))
{
Const.ShowMessage("带*的数据必须填写！", this.Page);
}
else
{
CompanyModel model = new CompanyDal();
CompanyModel model2 = new CompanyDal
{
FatherPK = this.txtsjgspk.Value.Trim()
};
if (model2.FatherPK != "")
{
model2.pk_corp = model2.FatherPK;
model2 = model2.GetModel(false, false, false, this.dbo);
if (model2.IsHasBaby == "0")
{
model.pk_corp = model2.pk_corp;
model.UpdateHasBaby(this.dbo);
}
model.PKPath = model2.PKPath + model2.pk_corp + "|";
if (this.txtishasbaby.Value == "1")
{
Companybll.ChangeChildPkPath(base.Request.QueryString["PK"].ToString(), model.PKPath + base.Request.QueryString["PK"].ToString() + "|", model2.Grade + 2, this.dbo);
}
model.Grade = model2.Grade + 1;
}
else
{
model.Grade = 0;
}
model.FatherPK = this.txtsjgspk.Value.Trim();
model.IsHasBaby = this.txtishasbaby.Value;
model.pk_corp = this.txtpk_corp.Text.Trim();
model.BH = this.txtcmbh.Value.Trim();
model.Name = this.txtName.Text.Trim();
model.IsHasBaby = this.txtishasbaby.Value.Trim();
model.Address = this.txtAddress.Text.Trim();
model.Area = this.txtArea.Text.Trim();
model.Country = this.txtCountry.Text.Trim();
model.Discription = this.txtDiscription.Text.Trim();
model.DutyNum = this.txtDutyNum.Text.Trim();
model.Email1 = this.txtEmail1.Text.Trim();
model.Email2 = this.txtEmail2.Text.Trim();
model.Email3 = this.txtEmail3.Text.Trim();
model.Fax1 = this.txtFax1.Text.Trim();
model.Fax2 = this.txtFax2.Text.Trim();
model.Fax3 = this.txtFax3.Text.Trim();
model.FPDWM = this.txtFPDWM.Text.Trim();
model.Holder = this.txtHolder.Text.Trim();
model.InvoiceType = this.txtInvoiceType.Text.Trim();
model.KeyChar = this.txtKeyChar.Text.Trim();
model.linkman1 = this.txtlinkman1.Text.Trim();
model.linkman2 = this.txtlinkman2.Text.Trim();
model.Name = this.txtName.Text.Trim();
model.Phone1 = this.txtPhone1.Text.Trim();
model.Phone2 = this.txtPhone2.Text.Trim();
model.Phone3 = this.txtPhone3.Text.Trim();
model.PostalCode = this.txtPostalCode.Text.Trim();
model.Province = this.txtProvince.Text.Trim();
if (this.txtRegMoney.Text.Trim() != "")
{
model.RegMoney = decimal.Parse(this.txtRegMoney.Text.Trim());
}
model.ShortName = this.txtShortName.Text.Trim();
model.Url = this.txtUrl.Text.Trim();
model.PostalCode = this.txtPostalCode.Text.Trim();
Const.UpdateSuccess(model.Update(base.Request.QueryString["PK"].ToString().Trim(), this.dbo), this.Page);
}
}
catch (Exception exception)
{
this.el = new ExceptionLog.ExceptionLog();
this.el.ErrClassName = base.GetType().ToString();
this.el.ErrMessage = exception.Message.ToString();
this.el.ErrMethod = "UpdateCompany()";
this.el.WriteExceptionLog(true);
Const.OpenErrorPage("操作失败，请联系管理员！", this.Page);
}
finally
{
if (this.dbo != null)
{
this.dbo.Close();
}
}
}
private string BingData(string pk_corp, DB_OPT dbo)
{
CompanyModel model = new CompanyDal
{
pk_corp = pk_corp
};
model = model.GetModel(false, true, false, dbo);
this.txtpk_corp.Text = base.Request["PK"].ToString();
this.txtcmbh.Value = model.BH;
this.txtName.Text = model.Name;
this.txtishasbaby.Value = model.IsHasBaby;
this.txtAddress.Text = model.Address;
this.txtArea.Text = model.Area;
this.txtCountry.Text = model.Country;
this.txtDiscription.Text = model.Discription;
this.txtDutyNum.Text = model.DutyNum;
this.txtEmail1.Text = model.Email1;
this.txtEmail2.Text = model.Email2;
this.txtEmail3.Text = model.Email3;
this.txtFax1.Text = model.Fax1;
this.txtFax2.Text = model.Fax2;
this.txtFax3.Text = model.Fax3;
this.txtFPDWM.Text = model.FPDWM;
this.txtHolder.Text = model.Holder;
this.txtInvoiceType.Text = model.InvoiceType;
this.txtKeyChar.Text = model.KeyChar;
this.txtlinkman1.Text = model.linkman1;
this.txtlinkman2.Text = model.linkman2;
this.txtName.Text = model.Name;
this.txtPhone1.Text = model.Phone1;
this.txtPhone2.Text = model.Phone2;
this.txtPhone3.Text = model.Phone3;
if (model.FatherInfo != null)
{
this.txtsjgs.Text = model.FatherInfo.Name;
}
this.txtsjgspk.Value = model.FatherPK;
this.txtPostalCode.Text = model.PostalCode;
this.txtProvince.Text = model.Province;
this.txtRegMoney.Text = model.RegMoney.ToString();
this.txtShortName.Text = model.ShortName;
this.txtUrl.Text = model.Url;
this.txtPostalCode.Text = model.PostalCode;
return model.PKPath;
}