public override int Delete(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete from GOV_TC_DB_ZSZXFJ ");
builder.Append(" where PK='" + base.pk + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Delete(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete from GOV_TC_DB_UNITCOUNT ");
builder.Append(" where PK = '" + base.PK + "' or PKPath like '%" + base.PK + "%'");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override UnitCountModel[] GetEgality(bool bj, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" * ");
builder.Append(" from GOV_TC_DB_UNITCOUNT ");
if (base.Grade >= 0)
{
builder.Append(" where Grade='" + base.Grade + "'");
}
else
{
if (base.PK == "")
{
throw new Exception("条件不足.");
}
builder.Append(" where Grade=(select Grade from GOV_TC_DB_UNITCOUNT where PK='" + base.PK + "')");
}
DataSet set = dbo.BackDataSet(builder.ToString(), null);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
UnitCountModel[] modelArray = new UnitCountModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new UnitCountModel();
modelArray[i] = this.Getmm(set.Tables[0].Rows[i], bj, dbo);
}
return modelArray;
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into gov_tc_db_ServicesConnection(");
builder.Append("OperationPK,ServicePK,Name,ServiceStep,CompanyPK,BranchPK,ConnectionTypePK,FatherPK,ConnectionPath,Grade,IsHasBaby,TopLevelConnectionPK,IfTax,IfFee,IfLast,Memo)");
builder.Append(" values (");
builder.Append(":OperationPK,:ServicePK,:Name,:ServiceStep,:CompanyPK,:BranchPK,:ConnectionTypePK,:FatherPK,:ConnectionPath,:Grade,:IsHasBaby,:TopLevelConnectionPK,:IfTax,:IfFee,:IfLast,:Memo)");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":OperationPK", OracleType.VarChar, 40), new OracleParameter(":ServicePK", OracleType.VarChar, 40), new OracleParameter(":Name", OracleType.VarChar, 100), new OracleParameter(":ServiceStep", OracleType.Int32, 4), new OracleParameter(":CompanyPK", OracleType.VarChar, 40), new OracleParameter(":BranchPK", OracleType.VarChar, 40), new OracleParameter(":ConnectionTypePK", OracleType.VarChar, 40), new OracleParameter(":FatherPK", OracleType.VarChar, 40), new OracleParameter(":ConnectionPath", OracleType.VarChar, 0xff), new OracleParameter(":Grade", OracleType.Int32, 4), new OracleParameter(":IsHasBaby", OracleType.Char, 1), new OracleParameter(":TopLevelConnectionPK", OracleType.VarChar, 40), new OracleParameter(":IfTax", OracleType.Char, 1), new OracleParameter(":IfFee", OracleType.Char, 1), new OracleParameter(":IfLast", OracleType.Char, 1), new OracleParameter(":Memo", OracleType.VarChar, 0xff) };
parameters[0].Value = base.OperationPK;
parameters[1].Value = base.ServicePK;
parameters[2].Value = base.Name;
parameters[3].Value = base.ServiceStep;
parameters[4].Value = base.CompanyPK;
parameters[5].Value = base.BranchPK;
parameters[6].Value = base.ConnectionTypePK;
parameters[7].Value = base.FatherPK;
parameters[8].Value = base.ConnectionPath;
parameters[9].Value = base.Grade;
parameters[10].Value = base.IsHasBaby;
parameters[11].Value = base.TopLevelConnectionPK;
parameters[12].Value = base.IfTax;
parameters[13].Value = base.IfFee;
parameters[14].Value = base.IfLast;
parameters[15].Value = base.Memo;
return dbo.ExecutionIsSucess(builder.ToString(), parameters, "");
}
public override int Delete(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete DB_OPERATIONLOG ");
builder.Append(" where pk='" + base.pk + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public bool checkIsRepeat(string text, string sql)
{
bool flag = false;
try
{
this.dbo = new DB_OPT();
this.dbo.Open();
DataSet set = new DataSet();
set = this.dbo.BackDataSet(sql, null);
if ((set != null) && (set.Tables[0].Rows.Count > 0))
{
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
if (text == set.Tables[0].Rows[0][0].ToString())
{
flag = true;
}
}
}
return flag;
}
catch (Exception)
{
}
finally
{
if (this.dbo != null)
{
this.dbo.Close();
}
}
return flag;
}
public int Delete(string PK, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete from GOV_TC_DB_SFZSZXFJ ");
builder.Append(" where PK=" + PK);
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public bool checkIsRepeat(string sql)
{
this.dbo = new DB_OPT();
DataSet set = new DataSet();
set = this.dbo.BackDataSet(sql, null);
return ((set != null) && (set.Tables[0].Rows.Count > 0));
}
public override void Delete(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete from DB_Bank ");
builder.Append(" where BankPK='" + base.BankPK + "'");
dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into gov_tc_db_ServicesRegister(");
builder.Append("ServiceTypePK,Name,Path,ClassName,ContParameters,IfTwoCont,Method,IfTwoMet,Parameters,Discription,GetServiceType,StartSign,InTime,OutTime,FatherPK,IsHasBaby,Grade,PKPath,MaxNum)");
builder.Append(" values (");
builder.Append(":ServiceTypePK,:Name,:Path,:ClassName,:ContParameters,:IfTwoCont,:Method,:IfTwoMet,:Parameters,:Discription,:GetServiceType,:StartSign,:InTime,:OutTime,:FatherPK,:IsHasBaby,:Grade,:PKPath,:MaxNum)");
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ServiceTypePK", OracleType.Char, 40), new OracleParameter(":Name", OracleType.VarChar, 40), new OracleParameter(":Path", OracleType.VarChar, 0xff), new OracleParameter(":ClassName", OracleType.VarChar, 40), new OracleParameter(":ContParameters", OracleType.VarChar, 0xff), new OracleParameter(":IfTwoCont", OracleType.Char, 1), new OracleParameter(":Method", OracleType.VarChar, 40), new OracleParameter(":IfTwoMet", OracleType.Char, 1), new OracleParameter(":Parameters", OracleType.VarChar, 0xff), new OracleParameter(":Discription", OracleType.VarChar, 0xff), new OracleParameter(":GetServiceType", OracleType.VarChar, 1), new OracleParameter(":StartSign", OracleType.VarChar, 1), new OracleParameter(":InTime", OracleType.DateTime, 40), new OracleParameter(":OutTime", OracleType.DateTime, 40), new OracleParameter(":FatherPK", OracleType.VarChar, 40), new OracleParameter(":IsHasBaby", OracleType.Char, 1),
new OracleParameter(":Grade", OracleType.Int32, 4), new OracleParameter(":PKPath", OracleType.Clob), new OracleParameter(":MaxNum", OracleType.Int32, 4)
};
parameters[0].Value = base.ServiceTypePK;
parameters[1].Value = base.Name;
parameters[2].Value = base.Path;
parameters[3].Value = base.ClassName;
parameters[4].Value = base.ContParameters;
parameters[5].Value = base.IfTwoCont;
parameters[6].Value = base.Method;
parameters[7].Value = base.IfTwoMet;
parameters[8].Value = base.Parameters;
parameters[9].Value = base.Discription;
parameters[10].Value = base.GetServiceType;
parameters[11].Value = base.StartSign;
parameters[12].Value = base.InTime;
parameters[13].Value = base.OutTime;
parameters[14].Value = base.FatherPK;
parameters[15].Value = base.IsHasBaby;
parameters[0x10].Value = base.Grade;
parameters[0x11].Value = base.PKPath;
parameters[0x12].Value = base.MaxNum;
return dbo.ExecutionIsSucess(builder.ToString(), parameters, "");
}
public override int Exists(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from GOV_TC_DB_ZSZXFJ");
builder.Append(" where pk='" + base.pk + "' ");
return dbo.BackIsSelect(builder.ToString(), null);
}
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);
}
}
protected void btDo_Click(object sender, EventArgs e)
{
try
{
this.dbo = new DB_OPT();
this.dbo.Open();
this.drpm = new DataRowPowerDal();
this.drpm.Name = this.txtname.Text.Trim();
this.drpm.PowerCode = this.txtpowercode.Text.Trim();
this.drpm.TableName = this.ddltablename.SelectedValue;
this.drpm.ColumnName = this.ddlColumnName.SelectedValue.Split(new char[] { '|' })[0];
this.drpm.TJType = this.ddlColumnName.SelectedValue.Split(new char[] { '|' })[1];
this.drpm.strWhere = this.GetStrWhere();
this.drpm.Discription = this.txtDiscription.Text.Trim();
if (this.ifadd.Value == "0")
{
this.drpm.PK = this.pk.Value;
this.drpm.Update(this.dbo);
Const.DoSuccessOpen("修改成功！", this.Page);
}
else
{
this.drpm.Add(this.dbo);
Const.DoSuccessOpen("添加成功！", this.Page);
}
}
catch (Exception exception)
{
Const.ShowMessage("操作失败！" + exception.Message, this.Page);
}
}
public static void ChangeChildPkPath(string menupk, string pkpath, int grade, DB_OPT dbo)
{
MenuModel model = new MenuDal();
MenuModel[] childs = model.GetChilds(menupk, dbo);
if (childs != null)
{
for (int i = 0; i < childs.Length; i++)
{
model.MemuPK = childs[i].MemuPK;
model.Grade = grade;
model.PKPath = pkpath;
model.UpdatePKPathAndGrade(dbo);
if (childs[i].IsHasBaby == "1")
{
ChangeChildPkPath(childs[i].MemuPK, pkpath + model.MemuPK + "|", grade + 1, dbo);
}
}
}
else
{
model.MemuPK = menupk;
model.IsHasBaby = "0";
model.UpdateHasBaby(dbo);
}
}
public int Delete(string PK, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete from DB_DATATABLE ");
builder.Append(" where PK='" + PK + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public int Delete(string PK, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete GOV_TC_DB_SFProExecuteStandard ");
builder.Append(" where PK='" + PK + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
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 override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into DB_Menu(");
builder.Append("MenuBH,MenuName,PageUrl,ImgUrl,FatherPK,IsHasBaby,Grade,PKPath,IsShow,PowerCode,InsertPC,UpdatePC,DeletePC,PrintPC,OpenType,IsCheckPower,VisitPoint,MenuType,OrderBy,Discription,pk_corp");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + base.MenuBH + "',");
builder.Append("'" + base.MenuName + "',");
builder.Append("'" + base.PageUrl + "',");
builder.Append("'" + base.ImgUrl + "',");
builder.Append("'" + base.FatherPK + "',");
builder.Append("'" + base.IsHasBaby + "',");
builder.Append(base.Grade + ",");
builder.Append("'" + base.PKPath + "',");
builder.Append("'" + base.IsShow + "',");
builder.Append("'" + base.PowerCode + "',");
builder.Append("'" + base.InsertPC + "',");
builder.Append("'" + base.UpdatePC + "',");
builder.Append("'" + base.DeletePC + "',");
builder.Append("'" + base.PrintPC + "',");
builder.Append("'" + base.OpenType + "',");
builder.Append("'" + base.IsCheckPower + "',");
builder.Append(base.VisitPoint + ",");
builder.Append("'" + base.MenuType + "',");
builder.Append(base.OrderBy + ",");
builder.Append("'" + base.Discription + "',");
builder.Append("'" + base.pk_corp + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Delete(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete from DB_Menu ");
builder.Append(" where MemuPK='" + base.MemuPK + "'");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public string GetStrParent(string pkpath)
{
string str;
try
{
string str2 = "";
this.dbo = new DB_OPT();
this.dbo.Open();
BranchModel[] parents = new BranchDal { PKPath = pkpath }.GetParents(false, this.dbo);
for (int i = 0; i < parents.Length; i++)
{
str2 = parents[i].BranchPK + "~" + str2;
}
str = str2.Substring(0, str2.Length - 1);
}
catch (Exception)
{
str = "";
}
finally
{
if (this.dbo != null)
{
this.dbo.Close();
}
}
return str;
}
public override DataRowPowerModel[] GetModels(DB_OPT dbo)
{
DataRowPowerModel[] modelArray = null;
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" PK,Name,PowerCode,TJType,TableName,ColumnName,strWhere,Discription ");
builder.Append(" from DataRowPower ");
builder.Append(" where TableName='" + base.TableName + "'");
DataSet set = dbo.BackDataSet(builder.ToString(), null);
if (set.Tables[0].Rows.Count > 0)
{
modelArray = new DataRowPowerModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new DataRowPowerModel();
modelArray[i].Name = set.Tables[0].Rows[i]["Name"].ToString();
modelArray[i].PowerCode = set.Tables[0].Rows[i]["PowerCode"].ToString();
modelArray[i].TJType = set.Tables[0].Rows[i]["TJType"].ToString();
modelArray[i].TableName = set.Tables[0].Rows[i]["TableName"].ToString();
modelArray[i].ColumnName = set.Tables[0].Rows[i]["ColumnName"].ToString();
modelArray[i].strWhere = set.Tables[0].Rows[i]["strWhere"].ToString();
modelArray[i].Discription = set.Tables[0].Rows[i]["Discription"].ToString();
modelArray[i].CodeAndWhere = set.Tables[0].Rows[i]["PowerCode"].ToString() + "|" + set.Tables[0].Rows[i]["strWhere"].ToString();
}
}
return modelArray;
}
public override int Delete(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete DataRowPower ");
builder.Append(" where PK='" + base.PK + "'");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public int Delete(string PK, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete GOV_TC_DB_OprateToInformation ");
builder.Append(" where PK='" + PK + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into DB_Role(");
builder.Append("BH,Name,Power,DataPower,RowPower,ServicesPower,CompanyPower,Discription,IsUserPower,FatherPK,IsHasBaby,Grade,PKPath,BranchPK,pk_corp");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + base.BH + "',");
builder.Append("'" + base.Name + "',");
builder.Append("'" + base.Power + "',");
builder.Append("'" + base.DataPower + "',");
builder.Append("'" + base.RowPower + "',");
builder.Append("'" + base.ServicesPower + "',");
builder.Append("'" + base.CompanyPower + "',");
builder.Append("'" + base.Discription + "',");
builder.Append("'" + base.IsUserPower + "',");
builder.Append("'" + base.FatherPK + "',");
builder.Append("'" + base.IsHasBaby + "',");
builder.Append(base.Grade + ",");
builder.Append("'" + base.PKPath + "',");
builder.Append("'" + base.BranchPK + "',");
builder.Append("'" + base.pk_corp + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public DataSet GetDataSet(string sql)
{
DataSet ds;
DataBaseType dBT = DB_OPT.DBT;
try
{
if (base.Request["MSSQL"] != null)
{
this.db = new DB_OPT("2", base.Request["MSSQL"], DataBaseType.SqlServer);
DB_OPT.DBT = DataBaseType.SqlServer;
}
else
{
this.db = new DB_OPT();
}
this.ds = new DataSet();
this.ds = this.db.BackDataSet(sql, null);
ds = this.ds;
}
catch
{
ds = null;
}
finally
{
DB_OPT.DBT = dBT;
}
return ds;
}
public int TaxFee(string mainTableName, string mainPK, string tableName, string PK, string executeMan, string computerIP, int step, string riticize, decimal money1, decimal money2, decimal money3, DB_OPT dbo)
{
string strSql = "update " + tableName + " set Sign='1', ExecuteMan='" + executeMan + "', ComputerIP='" + computerIP + "', ExecuteDate='" + DateTime.Now.ToShortDateString() + "', Riticize='" + riticize + "', Money1=" + money1.ToString() + ", Money2=" + money2.ToString() + ", Money3=" + money3.ToString() + " where PK='" + PK + "'";
dbo.ExecutionIsSucess(strSql, null);
string[] strArray = new string[] { "update ", mainTableName, " set Step='", (step + 1).ToString(), "' where PK='", mainPK, "'" };
strSql = string.Concat(strArray);
return dbo.ExecutionIsSucess(strSql, null);
}
public override int Exists(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(PK) from gov_tc_db_ServicesType");
builder.Append(" where PK=:PK");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.VarChar) };
parameters[0].Value = base.PK;
return dbo.BackIsSelect(builder.ToString(), parameters, "");
}
public override int Delete(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("delete from gov_tc_db_ServicesType ");
builder.Append(" where PK=:PK");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.VarChar) };
parameters[0].Value = base.PK;
return dbo.ExecutionIsSucess(builder.ToString(), parameters, "");
}
public void ShowData(string str)
{
try
{
string year = HttpContext.Current.Request.Cookies["YearND"].Value.ToString();
this.dbo = new DB_OPT();
this.dbo.Open();
str = " where lbdm=5 and substr(fzdm,1,1)='3' and gsdm='" + year + "'";
DataSet set = this.pagesize.pagesize(GetColsName(), "gl_fzxzl ", str, "fzdm", " order by fzdm ", this.Master.PageIndex, this.Master.PageSize, out this.count);
this.Master.RecordCount = Convert.ToInt32(this.count);
if ((set != null) && (set.Tables[0].Rows.Count > 0))
{
DataTable table = set.Tables[0];
DataColumn dc = new DataColumn();
dc.ColumnName = "LEVEL";
dc.Expression = "(len(trim(fzdm))-1)/2";
table.Columns.Add(dc);
DataColumn dc2 = new DataColumn();
dc2.ColumnName = "PID";
dc2.Expression = "iif(len(trim(fzdm))=3,'0',substring(fzdm,1,len(trim(fzdm))-2))";
table.Columns.Add(dc2);
DataColumn dc3 = new DataColumn();
dc3.ColumnName = "FZDMM";
dc3.Expression = "FZDM+'-'+FZMC";
table.Columns.Add(dc3);
this.gvResult.DataSource = table;
this.gvResult.DataBind();
}
else
{
DataTable table3 = new DataTable();
this.gvResult.DataSource = table3.DefaultView;
this.gvResult.DataBind();
}
//PublicDal.setGridKeepAll(this.gvResult);
}
catch (Exception exception)
{
this.el = new ExceptionLog.ExceptionLog();
this.el.ErrClassName = base.GetType().ToString();
this.el.ErrMessage = exception.Message.ToString();
this.el.ErrMethod = "ShowData()";
this.el.WriteExceptionLog(true);
Const.OpenErrorPage("获取数据失败，请联系系统管理员！", this.Page);
}
finally
{
if (this.dbo != null)
{
this.dbo.Close();
}
}
}
public int Exists(string PK, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(PK) from GOV_TC_DB_SFProExecuteStandard");
builder.Append(" where PK=:PK");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.Char) };
parameters[0].Value = PK;
return dbo.BackIsSelect(builder.ToString(), parameters, "");
}