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 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 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_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 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 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 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 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 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 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 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 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 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 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 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 override int Update(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("update GOV_TC_DB_SFType set ");
builder.Append("pk_corp='" + base.pk_corp + "',");
builder.Append("Name='" + base.Name + "',");
builder.Append("Discription='" + base.Discription + "'");
builder.Append(" where PK='" + base.PK + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into gov_tc_db_ServicesType(");
builder.Append("BH,Name)");
builder.Append(" values (");
builder.Append(":BH,:Name)");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":BH", OracleType.VarChar, 40), new OracleParameter(":Name", OracleType.VarChar, 40) };
parameters[0].Value = base.BH;
parameters[1].Value = base.Name;
return dbo.ExecutionIsSucess(builder.ToString(), parameters, "");
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into gov_tc_db_Operation(");
builder.Append("OperationPK,ServerPKs)");
builder.Append(" values (");
builder.Append(":OperationPK,:ServerPKs)");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":OperationPK", OracleType.VarChar, 40), new OracleParameter(":ServerPKs", OracleType.VarChar, 0xff) };
parameters[0].Value = base.OperationPK;
parameters[1].Value = base.ServerPKs;
return dbo.ExecutionIsSucess(builder.ToString(), parameters, "");
}
public override int Update(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("update DB_Bank set ");
builder.Append("pk_corp='" + base.pk_corp + "',");
builder.Append("BankName='" + base.BankName + "',");
builder.Append("BankNum='" + base.BankNum + "',");
builder.Append("BankNumMan='" + base.BankNumMan + "',");
builder.Append("Discription='" + base.Discription + "'");
builder.Append(" where BankPK='" + base.BankPK + "'");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Update(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("update DB_OPERATIONLOG set ");
builder.Append("UserName='******',");
builder.Append("opType='" + base.opType + "',");
builder.Append("Business='" + base.Business + "',");
builder.Append("Content='" + base.Content + "',");
builder.Append("ifPass='******',");
builder.Append("opTime='" + base.opTime + "'");
builder.Append(" where pk='" + base.pk + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into GOV_TC_DB_SFType(");
builder.Append("pk_corp,Name,Discription");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + base.pk_corp + "',");
builder.Append("'" + base.Name + "',");
builder.Append("'" + base.Discription + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public int Add(DataTableModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into DB_DATATABLE(");
builder.Append("TABLEREMARK,TABLENAME,REMARK");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.TABLEREMARK + "',");
builder.Append("'" + model.TABLENAME + "',");
builder.Append("'" + model.REMARK + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into GOV_TC_DB_OPRATETACHE(");
builder.Append("Name,OprateOrder,Remark,TacheType)");
builder.Append(" values (");
builder.Append(":Name,:OprateOrder,:Remark,:TacheType)");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":Name", OracleType.VarChar, 60), new OracleParameter(":OprateOrder", OracleType.Number), new OracleParameter(":Remark", OracleType.VarChar, 0xff), new OracleParameter(":TacheType", OracleType.VarChar, 2) };
parameters[0].Value = base.Name;
parameters[1].Value = base.OprateOrder;
parameters[2].Value = base.Remark;
parameters[3].Value = base.TacheType;
return dbo.ExecutionIsSucess(builder.ToString(), parameters, "");
}
public int Add(DataColumnModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into DB_DATACOLUMN(");
builder.Append("TABLEPK,COLUMNREMARK,COLUMNNAME,REMARK");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.TABLEPK + "',");
builder.Append("'" + model.COLUMNREMARK + "',");
builder.Append("'" + model.COLUMNNAME + "',");
builder.Append("'" + model.REMARK + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into DB_Bank(");
builder.Append("pk_corp,BankName,BankNum,BankNumMan,Discription");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + base.pk_corp + "',");
builder.Append("'" + base.BankName + "',");
builder.Append("'" + base.BankNum + "',");
builder.Append("'" + base.BankNumMan + "',");
builder.Append("'" + base.Discription + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into DB_OPERATIONLOG(");
builder.Append("UserName,opType,Business,Content,ifPass");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + base.UserName + "',");
builder.Append("'" + base.opType + "',");
builder.Append("'" + base.Business + "',");
builder.Append("'" + base.Content + "',");
builder.Append("'" + base.ifPass + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public int Add(SFProExecuteStandardModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into GOV_TC_DB_SFProExecuteStandard(");
builder.Append("SFProjectPK,CountStandardPK,BuildingProPK,ExecuteStandard,Remark");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.SFProjectPK + "',");
builder.Append("'" + model.CountStandardPK + "',");
builder.Append("'" + model.BuildingProPK + "',");
builder.Append(model.ExecuteStandard + ",");
builder.Append("'" + model.Remark + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public int Add(SFZSZXFJModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into GOV_TC_DB_SFZSZXFJ(");
builder.Append("EXECUTESTANDARDPK,TERMNAME,TERMVALUE,EXEMIN,EXEMAX,DISCRIPTION");
builder.Append(")");
builder.Append(" values (");
builder.Append(model.EXECUTESTANDARDPK + ",");
builder.Append(model.TERMNAME + ",");
builder.Append(model.TERMVALUE + ",");
builder.Append(model.EXEMIN + ",");
builder.Append(model.EXEMAX + ",");
builder.Append(model.DISCRIPTION ?? "");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public override int Add(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into GOV_TC_DB_UNITCOUNT(");
builder.Append("BH,Name,Discription,FatherPK,IsHasBaby,Grade,PKPath");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + base.BH + "',");
builder.Append("'" + base.Name + "',");
builder.Append("'" + base.Discription + "',");
builder.Append("'" + base.FatherPK + "',");
builder.Append("'" + base.IsHasBaby + "',");
builder.Append(base.Grade + ",");
builder.Append("'" + base.PKPath + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
