public bool Update(TB_QUOTA_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update TB_QUOTA set ");
builder.Append("PD_QUOTA_NAME=:PD_QUOTA_NAME,");
builder.Append("PD_YEAR=:PD_YEAR,");
builder.Append("PD_QUOTA_LWJG=:PD_QUOTA_LWJG,");
builder.Append("PD_QUOTA_IFUP=:PD_QUOTA_IFUP,");
builder.Append("PD_QUOTA_ZJXZ=:PD_QUOTA_ZJXZ,");
builder.Append("PD_QUOTA_TARGET=:PD_QUOTA_TARGET,");
builder.Append("PD_QUOTA_STANDARD=:PD_QUOTA_STANDARD,");
builder.Append("PD_QUOTA_BASIS=:PD_QUOTA_BASIS,");
builder.Append("PD_QUOTA_BASIS_JG=:PD_QUOTA_BASIS_JG,");
builder.Append("PD_QUOTA_INPUT_MAN=:PD_QUOTA_INPUT_MAN,");
builder.Append("PD_QUOTA_FILE=:PD_QUOTA_FILE,");
builder.Append("PD_QUOTA_XZ_ACCEPT_COMPANY=:PD_QUOTA_XZ_ACCEPT_COMPANY,");
builder.Append("PD_QUOTA_XZ_ACCEPT_DATE=:PD_QUOTA_XZ_ACCEPT_DATE,");
builder.Append("PD_QUOTA_MONEY_TOTAL=:PD_QUOTA_MONEY_TOTAL,");
builder.Append("PD_QUOTA_DEPART=:PD_QUOTA_DEPART,");
builder.Append("PD_QUOTA_JGYQ=:PD_QUOTA_JGYQ,");
builder.Append("PD_QUOTA_INPUT_DATE=:PD_QUOTA_INPUT_DATE,");
builder.Append("PD_QUOTA_INPUT_COMPANY=:PD_QUOTA_INPUT_COMPANY,");
builder.Append("PD_QUOTA_XZ_ACCEPT_MAN=:PD_QUOTA_XZ_ACCEPT_MAN,");
builder.Append("PD_PROJ_STATUS=:PD_PROJ_STATUS,");
builder.Append("PD_PROJ_LAST_AUDIT_STATUS=:PD_PROJ_LAST_AUDIT_STATUS,");
builder.Append("PD_IS_RETURN=:PD_IS_RETURN,");
builder.Append("PD_ISOUT_QUOTA=:PD_ISOUT_QUOTA,");
builder.Append("PD_QUOTA_ZBWH=:PD_QUOTA_ZBWH,");
builder.Append("PD_QUOTA_FWDATA=:PD_QUOTA_FWDATA,");
builder.Append("PD_QUOTA_COMPANY=:PD_QUOTA_COMPANY,");
builder.Append("PD_QUOTA_ZBYT=:PD_QUOTA_ZBYT,");
builder.Append("PD_QUOTA_QCDW=:PD_QUOTA_QCDW,");
builder.Append("PD_QUOTA_QCBM=:PD_QUOTA_QCBM,");
builder.Append("PD_QUOTA_GLLX=:PD_QUOTA_GLLX,");
builder.Append("PD_QUOTA_JJLX=:PD_QUOTA_JJLX, ");
builder.Append("PD_QUOTA_ZJLY=:PD_QUOTA_ZJLY, ");
builder.Append("PD_QUOTA_ZGKJ=:PD_QUOTA_ZGKJ, ");
builder.Append("PD_QUOTA_XMZGBM=:PD_QUOTA_XMZGBM, ");
builder.Append("PD_QUOTA_ZBXDZH=:PD_QUOTA_ZBXDZH,");
builder.Append("PD_QUOTA_ZGBM=:PD_QUOTA_ZGBM,");
builder.Append("PD_QUOTA_PICI=:PD_QUOTA_PICI,");
builder.Append("PD_QUOTA_YSLX=:PD_QUOTA_YSLX,");
builder.Append("Free1=:Free1,");
builder.Append("Free2=:Free2,");
builder.Append("Free3=:Free3,");
builder.Append("Free4=:Free4,");
builder.Append("Free5=:Free5,");
builder.Append("Free6=:Free6,");
builder.Append("Free7=:Free7,");
builder.Append("Free8=:Free8,");
builder.Append("Free9=:Free9,");
builder.Append("Free10=:Free10");
builder.Append(" where PD_QUOTA_CODE=:PD_QUOTA_CODE ");
OracleParameter[] cmdParms = new OracleParameter[] {
new OracleParameter(":PD_QUOTA_NAME", OracleType.VarChar, 100), new OracleParameter(":PD_YEAR", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_LWJG", OracleType.Number, 4), new OracleParameter(":PD_QUOTA_IFUP", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_ZJXZ", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_TARGET", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_STANDARD", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_BASIS", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_BASIS_JG", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_INPUT_MAN", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_FILE", OracleType.VarChar, 300), new OracleParameter(":PD_QUOTA_XZ_ACCEPT_COMPANY", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_XZ_ACCEPT_DATE", OracleType.DateTime), new OracleParameter(":PD_QUOTA_MONEY_TOTAL", OracleType.Number, 4), new OracleParameter(":PD_QUOTA_DEPART", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_JGYQ", OracleType.VarChar, 0x7d0),
new OracleParameter(":PD_QUOTA_INPUT_DATE", OracleType.DateTime), new OracleParameter(":PD_QUOTA_INPUT_COMPANY", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_XZ_ACCEPT_MAN", OracleType.VarChar, 30), new OracleParameter(":PD_PROJ_STATUS", OracleType.VarChar, 100), new OracleParameter(":PD_PROJ_LAST_AUDIT_STATUS", OracleType.VarChar, 100), new OracleParameter(":PD_IS_RETURN", OracleType.Number, 4), new OracleParameter(":PD_ISOUT_QUOTA", OracleType.Number, 4), new OracleParameter(":PD_QUOTA_CODE", OracleType.NVarChar, 30), new OracleParameter(":PD_QUOTA_ZBWH", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_FWDATA", OracleType.DateTime), new OracleParameter(":PD_QUOTA_COMPANY", OracleType.VarChar, 100), new OracleParameter(":PD_QUOTA_ZBYT", OracleType.VarChar, 100), new OracleParameter(":PD_QUOTA_QCDW", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_QCBM", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_GLLX", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_JJLX", OracleType.VarChar, 50),
new OracleParameter(":PD_QUOTA_ZJLY", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_ZGKJ", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_XMZGBM", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_XMZGBM", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_ZBXDZH", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_ZGBM", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_PICI", OracleType.VarChar, 4), new OracleParameter(":PD_QUOTA_YSLX", OracleType.VarChar, 100), new OracleParameter(":Free1", OracleType.VarChar, 100), new OracleParameter(":Free2", OracleType.VarChar, 100), new OracleParameter(":Free3", OracleType.VarChar, 100), new OracleParameter(":Free4", OracleType.VarChar, 100), new OracleParameter(":Free5", OracleType.VarChar, 100), new OracleParameter(":Free6", OracleType.Int32, 4), new OracleParameter(":Free7", OracleType.Int32, 4), new OracleParameter(":Free8", OracleType.Number),
new OracleParameter(":Free9", OracleType.Number), new OracleParameter(":Free10", OracleType.Number)
};
cmdParms[0].Value = model.PD_QUOTA_NAME;
cmdParms[1].Value = model.PD_YEAR;
cmdParms[2].Value = model.PD_QUOTA_LWJG;
cmdParms[3].Value = model.PD_QUOTA_IFUP;
cmdParms[4].Value = model.PD_QUOTA_ZJXZ;
cmdParms[5].Value = model.PD_QUOTA_TARGET;
cmdParms[6].Value = model.PD_QUOTA_STANDARD;
cmdParms[7].Value = model.PD_QUOTA_BASIS;
cmdParms[8].Value = model.PD_QUOTA_BASIS_JG;
cmdParms[9].Value = model.PD_QUOTA_INPUT_MAN;
cmdParms[10].Value = model.PD_QUOTA_FILE;
cmdParms[11].Value = model.PD_QUOTA_XZ_ACCEPT_COMPANY;
cmdParms[12].Value = model.PD_QUOTA_XZ_ACCEPT_DATE;
cmdParms[13].Value = model.PD_QUOTA_MONEY_TOTAL;
cmdParms[14].Value = model.PD_QUOTA_DEPART;
cmdParms[15].Value = model.PD_QUOTA_JGYQ;
cmdParms[0x10].Value = model.PD_QUOTA_INPUT_DATE;
cmdParms[0x11].Value = model.PD_QUOTA_INPUT_COMPANY;
cmdParms[0x12].Value = model.PD_QUOTA_XZ_ACCEPT_MAN;
cmdParms[0x13].Value = model.PD_PROJ_STATUS;
cmdParms[20].Value = model.PD_PROJ_LAST_AUDIT_STATUS;
cmdParms[0x15].Value = model.PD_IS_RETURN;
cmdParms[0x16].Value = model.PD_ISOUT_QUOTA;
cmdParms[0x17].Value = model.PD_QUOTA_CODE;
cmdParms[0x18].Value = model.PD_QUOTA_ZBWH;
cmdParms[0x19].Value = model.PD_QUOTA_FWDATA;
cmdParms[0x1a].Value = model.PD_QUOTA_COMPANY;
cmdParms[0x1b].Value = model.PD_QUOTA_ZBYT;
cmdParms[0x1c].Value = model.PD_QUOTA_QCDW;
cmdParms[0x1d].Value = model.PD_QUOTA_QCBM;
cmdParms[30].Value = model.PD_QUOTA_GLLX;
cmdParms[0x1f].Value = model.PD_QUOTA_JJLX;
cmdParms[0x20].Value = model.PD_QUOTA_ZJLY;
cmdParms[0x21].Value = model.PD_QUOTA_ZGKJ;
cmdParms[0x22].Value = model.PD_QUOTA_XMZGBM;
cmdParms[0x23].Value = model.PD_QUOTA_CODE;
cmdParms[0x24].Value = model.PD_QUOTA_ZBXDZH;
cmdParms[0x25].Value = model.PD_QUOTA_ZGBM;
cmdParms[0x26].Value = model.PD_QUOTA_PICI;
cmdParms[0x27].Value = model.PD_QUOTA_YSLX;
cmdParms[40].Value = model.Free1;
cmdParms[0x29].Value = model.Free2;
cmdParms[0x2a].Value = model.Free3;
cmdParms[0x2b].Value = model.Free4;
cmdParms[0x2c].Value = model.Free5;
cmdParms[0x2d].Value = model.Free6;
cmdParms[0x2e].Value = model.Free7;
cmdParms[0x2f].Value = model.Free8;
cmdParms[0x30].Value = model.Free9;
cmdParms[0x31].Value = model.Free10;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public void Add(TB_QUOTA_Model model, string wh)
{
model.PD_QUOTA_CODE = DateTime.Now.ToString("yyyyMMddhhmmssffffff");
StringBuilder builder = new StringBuilder();
builder.Append("insert into TB_QUOTA(");
builder.Append("AUTO_NO,PD_QUOTA_CODE,PD_QUOTA_NAME,PD_YEAR,PD_QUOTA_LWJG,PD_QUOTA_IFUP,PD_QUOTA_ZJXZ,PD_QUOTA_TARGET,PD_QUOTA_STANDARD,PD_QUOTA_BASIS,PD_QUOTA_IFXZQS,PD_QUOTA_IFPASS,PD_QUOTA_BASIS_JG,PD_QUOTA_INPUT_MAN,PD_QUOTA_PASS_DATE,PD_QUOTA_ACCEPT_MAN,PD_QUOTA_PASS_MAN,PD_QUOTA_ACCEPT_COMPANY,PD_QUOTA_ACCEPT_DATE,PD_QUOTA_IFLLYQS,PD_QUOTA_FILE,PD_QUOTA_XZ_ACCEPT_COMPANY,PD_QUOTA_XZ_ACCEPT_DATE,PD_QUOTA_MONEY_TOTAL,PD_QUOTA_DEPART,PD_QUOTA_JGYQ,PD_QUOTA_INPUT_DATE,PD_QUOTA_INPUT_COMPANY,PD_QUOTA_XZ_ACCEPT_MAN,PD_PROJ_STATUS,PD_PROJ_LAST_AUDIT_STATUS,PD_IS_RETURN,PD_ISOUT_QUOTA,PD_QUOTA_ZBWH,PD_QUOTA_FWDATA,PD_QUOTA_COMPANY,PD_QUOTA_ZBYT,PD_QUOTA_QCDW,PD_QUOTA_QCBM,PD_QUOTA_GLLX,PD_QUOTA_JJLX,");
builder.Append("PD_QUOTA_ZJLY,PD_QUOTA_ZGKJ,PD_QUOTA_XMZGBM,PD_QUOTA_SERVERPK,PD_QUOTA_INPUT_DEPART,PD_QUOTA_ZBXDZH,PD_QUOTA_ZGBM,PD_QUOTA_PICI,");
builder.Append("PD_QUOTA_YSLX,Free1,Free2,Free3,Free4,Free5,Free6,Free7,Free8,Free9,Free10)");
builder.Append(" values (");
builder.Append(":AUTO_NO,:PD_QUOTA_CODE,:PD_QUOTA_NAME,:PD_YEAR,:PD_QUOTA_LWJG,:PD_QUOTA_IFUP,:PD_QUOTA_ZJXZ,:PD_QUOTA_TARGET,:PD_QUOTA_STANDARD,:PD_QUOTA_BASIS,:PD_QUOTA_IFXZQS,:PD_QUOTA_IFPASS,:PD_QUOTA_BASIS_JG,:PD_QUOTA_INPUT_MAN,:PD_QUOTA_PASS_DATE,:PD_QUOTA_ACCEPT_MAN,:PD_QUOTA_PASS_MAN,:PD_QUOTA_ACCEPT_COMPANY,:PD_QUOTA_ACCEPT_DATE,:PD_QUOTA_IFLLYQS,:PD_QUOTA_FILE,:PD_QUOTA_XZ_ACCEPT_COMPANY,:PD_QUOTA_XZ_ACCEPT_DATE,:PD_QUOTA_MONEY_TOTAL,:PD_QUOTA_DEPART,:PD_QUOTA_JGYQ,:PD_QUOTA_INPUT_DATE,:PD_QUOTA_INPUT_COMPANY,:PD_QUOTA_XZ_ACCEPT_MAN,:PD_PROJ_STATUS,:PD_PROJ_LAST_AUDIT_STATUS,:PD_IS_RETURN,:PD_ISOUT_QUOTA,:PD_QUOTA_ZBWH,:PD_QUOTA_FWDATA,:PD_QUOTA_COMPANY,:PD_QUOTA_ZBYT,:PD_QUOTA_QCDW,:PD_QUOTA_QCBM,:PD_QUOTA_GLLX,:PD_QUOTA_JJLX,");
builder.Append(":PD_QUOTA_ZJLY,:PD_QUOTA_ZGKJ,:PD_QUOTA_XMZGBM,:PD_QUOTA_SERVERPK,:PD_QUOTA_INPUT_DEPART,:PD_QUOTA_ZBXDZH,:PD_QUOTA_ZGBM,:PD_QUOTA_PICI,");
builder.Append(":PD_QUOTA_YSLX,:Free1,:Free2,:Free3,:Free4,:Free5,:Free6,:Free7,:Free8,:Free9,:Free10)");
builder.Append(" RETURNING PD_QUOTA_CODE INTO :R_Auto_No");
OracleParameter[] cmdParms = new OracleParameter[] {
new OracleParameter(":AUTO_NO", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_NAME", OracleType.VarChar, 100), new OracleParameter(":PD_YEAR", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_LWJG", OracleType.Number, 4), new OracleParameter(":PD_QUOTA_IFUP", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_ZJXZ", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_TARGET", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_STANDARD", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_BASIS", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_IFXZQS", OracleType.Number, 4), new OracleParameter(":PD_QUOTA_IFPASS", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_BASIS_JG", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_INPUT_MAN", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_PASS_DATE", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_ACCEPT_MAN", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_PASS_MAN", OracleType.VarChar, 30),
new OracleParameter(":PD_QUOTA_ACCEPT_COMPANY", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_ACCEPT_DATE", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_IFLLYQS", OracleType.Number, 4), new OracleParameter(":PD_QUOTA_FILE", OracleType.VarChar, 300), new OracleParameter(":PD_QUOTA_XZ_ACCEPT_COMPANY", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_XZ_ACCEPT_DATE", OracleType.DateTime), new OracleParameter(":PD_QUOTA_MONEY_TOTAL", OracleType.Number, 4), new OracleParameter(":PD_QUOTA_DEPART", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_JGYQ", OracleType.VarChar, 0x7d0), new OracleParameter(":PD_QUOTA_INPUT_DATE", OracleType.DateTime), new OracleParameter(":PD_QUOTA_INPUT_COMPANY", OracleType.Char, 10), new OracleParameter(":PD_QUOTA_XZ_ACCEPT_MAN", OracleType.VarChar, 30), new OracleParameter(":PD_PROJ_STATUS", OracleType.VarChar, 100), new OracleParameter(":PD_PROJ_LAST_AUDIT_STATUS", OracleType.VarChar, 100), new OracleParameter(":PD_IS_RETURN", OracleType.Number, 4), new OracleParameter(":PD_ISOUT_QUOTA", OracleType.Number, 4),
new OracleParameter(":PD_QUOTA_ZBWH", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_FWDATA", OracleType.DateTime), new OracleParameter(":PD_QUOTA_COMPANY", OracleType.VarChar, 100), new OracleParameter(":PD_QUOTA_ZBYT", OracleType.VarChar, 100), new OracleParameter(":PD_QUOTA_QCDW", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_QCBM", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_GLLX", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_JJLX", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_ZJLY", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_ZGKJ", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_XMZGBM", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_SERVERPK", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_CODE", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_INPUT_DEPART", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_ZBXDZH", OracleType.VarChar, 30), new OracleParameter(":PD_QUOTA_ZGBM", OracleType.VarChar, 50),
new OracleParameter(":PD_QUOTA_PICI", OracleType.VarChar, 4), new OracleParameter(":PD_QUOTA_YSLX", OracleType.VarChar, 100), new OracleParameter(":Free1", OracleType.VarChar, 100), new OracleParameter(":Free2", OracleType.VarChar, 100), new OracleParameter(":Free3", OracleType.VarChar, 100), new OracleParameter(":Free4", OracleType.VarChar, 100), new OracleParameter(":Free5", OracleType.VarChar, 100), new OracleParameter(":Free6", OracleType.Int32, 4), new OracleParameter(":Free7", OracleType.Int32, 4), new OracleParameter(":Free8", OracleType.Number), new OracleParameter(":Free9", OracleType.Number), new OracleParameter(":Free10", OracleType.Number), new OracleParameter(":R_Auto_No", OracleType.Number, 20)
};
cmdParms[0].Value = model.AUTO_NO;
cmdParms[1].Value = model.PD_QUOTA_NAME;
cmdParms[2].Value = model.PD_YEAR;
cmdParms[3].Value = model.PD_QUOTA_LWJG;
cmdParms[4].Value = model.PD_QUOTA_IFUP;
cmdParms[5].Value = model.PD_QUOTA_ZJXZ;
cmdParms[6].Value = model.PD_QUOTA_TARGET;
cmdParms[7].Value = model.PD_QUOTA_STANDARD;
cmdParms[8].Value = model.PD_QUOTA_BASIS;
cmdParms[9].Value = model.PD_QUOTA_IFXZQS;
cmdParms[10].Value = model.PD_QUOTA_IFPASS;
cmdParms[11].Value = model.PD_QUOTA_BASIS_JG;
cmdParms[12].Value = model.PD_QUOTA_INPUT_MAN;
cmdParms[13].Value = model.PD_QUOTA_PASS_DATE;
cmdParms[14].Value = model.PD_QUOTA_ACCEPT_MAN;
cmdParms[15].Value = model.PD_QUOTA_PASS_MAN;
cmdParms[0x10].Value = model.PD_QUOTA_ACCEPT_COMPANY;
cmdParms[0x11].Value = model.PD_QUOTA_ACCEPT_DATE;
cmdParms[0x12].Value = model.PD_QUOTA_IFLLYQS;
cmdParms[0x13].Value = model.PD_QUOTA_FILE;
cmdParms[20].Value = model.PD_QUOTA_XZ_ACCEPT_COMPANY;
cmdParms[0x15].Value = model.PD_QUOTA_XZ_ACCEPT_DATE;
cmdParms[0x16].Value = model.PD_QUOTA_MONEY_TOTAL;
cmdParms[0x17].Value = model.PD_QUOTA_DEPART;
cmdParms[0x18].Value = model.PD_QUOTA_JGYQ;
cmdParms[0x19].Value = model.PD_QUOTA_INPUT_DATE;
cmdParms[0x1a].Value = model.PD_QUOTA_INPUT_COMPANY;
cmdParms[0x1b].Value = model.PD_QUOTA_XZ_ACCEPT_MAN;
cmdParms[0x1c].Value = model.PD_PROJ_STATUS;
cmdParms[0x1d].Value = model.PD_PROJ_LAST_AUDIT_STATUS;
cmdParms[30].Value = model.PD_IS_RETURN;
cmdParms[0x1f].Value = model.PD_ISOUT_QUOTA;
cmdParms[0x20].Value = model.PD_QUOTA_ZBWH;
cmdParms[0x21].Value = model.PD_QUOTA_FWDATA;
cmdParms[0x22].Value = model.PD_QUOTA_COMPANY;
cmdParms[0x23].Value = model.PD_QUOTA_ZBYT;
cmdParms[0x24].Value = model.PD_QUOTA_QCDW;
cmdParms[0x25].Value = model.PD_QUOTA_QCBM;
cmdParms[0x26].Value = model.PD_QUOTA_GLLX;
cmdParms[0x27].Value = model.PD_QUOTA_JJLX;
cmdParms[40].Value = model.PD_QUOTA_ZJLY;
cmdParms[0x29].Value = model.PD_QUOTA_ZGKJ;
cmdParms[0x2a].Value = model.PD_QUOTA_XMZGBM;
cmdParms[0x2b].Value = model.PD_QUOTA_SERVERPK;
cmdParms[0x2c].Value = model.PD_QUOTA_CODE;
cmdParms[0x2d].Value = model.PD_QUOTA_INPUT_DEPART;
cmdParms[0x2e].Value = model.PD_QUOTA_ZBXDZH;
cmdParms[0x2f].Value = model.PD_QUOTA_ZGBM;
cmdParms[0x30].Value = model.PD_QUOTA_PICI;
cmdParms[0x31].Value = model.PD_QUOTA_YSLX;
cmdParms[50].Value = model.Free1;
cmdParms[0x33].Value = model.Free2;
cmdParms[0x34].Value = model.Free3;
cmdParms[0x35].Value = model.Free4;
cmdParms[0x36].Value = model.Free5;
cmdParms[0x37].Value = model.Free6;
cmdParms[0x38].Value = model.Free7;
cmdParms[0x39].Value = model.Free8;
cmdParms[0x3a].Value = model.Free9;
cmdParms[0x3b].Value = model.Free10;
cmdParms[60].Direction = ParameterDirection.Output;
DbHelperOra.ExecuteSql(builder.ToString(), cmdParms);
model.PD_QUOTA_CODE = cmdParms[60].Value.ToString();
}
public TB_QUOTA_Model GetModelByCode(string PD_QUOTA_CODE)
{
StringBuilder builder = new StringBuilder();
builder.Append("select AUTO_NO,PD_QUOTA_CODE,PD_QUOTA_NAME,PD_YEAR,PD_QUOTA_LWJG,PD_QUOTA_LWJG_NAME,PD_QUOTA_IFUP,PD_QUOTA_ZJXZ,pd_quota_zjxzCode,PD_QUOTA_TARGET,PD_QUOTA_STANDARD,PD_QUOTA_BASIS,PD_QUOTA_IFXZQS,PD_QUOTA_IFXZQS_NAME,PD_QUOTA_IFPASS,PD_QUOTA_BASIS_JG,PD_QUOTA_INPUT_MAN,PD_QUOTA_PASS_DATE,PD_QUOTA_ACCEPT_MAN,PD_QUOTA_PASS_MAN,PD_QUOTA_ACCEPT_COMPANY,PD_QUOTA_ACCEPT_DATE,PD_QUOTA_IFLLYQS,PD_QUOTA_FILE,PD_QUOTA_XZ_ACCEPT_COMPANY,PD_QUOTA_XZ_ACCEPT_DATE,PD_QUOTA_MONEY_TOTAL,PD_QUOTA_DEPART,PD_QUOTA_JGYQ,PD_QUOTA_INPUT_DATE,PD_QUOTA_INPUT_COMPANY,PD_QUOTA_XZ_ACCEPT_MAN,PD_PROJ_STATUS,PD_PROJ_LAST_AUDIT_STATUS,PD_IS_RETURN,PD_ISOUT_QUOTA,pd_quota_zbwh,PD_QUOTA_FWDATA,PD_QUOTA_COMPANY,PD_QUOTA_ZBYT,PD_QUOTA_QCDW,PD_QUOTA_QCBM,PD_QUOTA_GLLX,PD_QUOTA_JJLX,");
builder.Append("PD_QUOTA_PASS_COMPANY,PD_QUOTA_PASS_DEPART,PD_QUOTA_ACCEPT_DEPART,PD_QUOTA_UP_COMPANY,PD_QUOTA_UP_DEPART,PD_QUOTA_UP_DATE,PD_QUOTA_UP_MAN,PD_QUOTA_PASS_COMPANY_NAme,PD_QUOTA_ACCEPT_COMPANY_NAME,PD_QUOTA_UP_COMPANY_NAME,PD_QUOTA_PASS_DEPART_NAME,PD_QUOTA_ACCEPT_DEPART_NAME,PD_QUOTA_UP_DEPART_NAME,PD_QUOTA_PASS_MAN,PD_QUOTA_ACCEPT_MAN,PD_QUOTA_UP_MAN,PD_QUOTA_IFPASS_NAME,PD_QUOTA_IFLLYQS_NAME,");
builder.Append("PD_QUOTA_ZJLY,PD_QUOTA_ZGKJ,PD_QUOTA_XMZGBM,PD_QUOTA_ISUP,PD_QUOTA_ISUP_NAME,PD_QUOTA_ZBXDZH,PD_QUOTA_ZGBM,PD_QUOTA_IFXZHZ,PD_QUOTA_IFXZHZ_NAME,pd_quota_serverpk,PD_QUOTA_PICI,PD_JY_MONEY,PD_QUOTA_YSLX,Free1,Free2,Free3,Free4,Free5,Free6,Free7,Free8,Free9,Free10 from view_tb_quota_list ");
builder.Append(" where PD_QUOTA_CODE=:PD_QUOTA_CODE ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_QUOTA_CODE", OracleType.VarChar, 100) };
cmdParms[0].Value = PD_QUOTA_CODE;
TB_QUOTA_Model model = new TB_QUOTA_Model();
DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
model.AUTO_NO = set.Tables[0].Rows[0]["AUTO_NO"].ToString();
model.PD_QUOTA_CODE = set.Tables[0].Rows[0]["PD_QUOTA_CODE"].ToString();
model.PD_QUOTA_NAME = set.Tables[0].Rows[0]["PD_QUOTA_NAME"].ToString();
model.PD_YEAR = set.Tables[0].Rows[0]["PD_YEAR"].ToString();
if (set.Tables[0].Rows[0]["PD_QUOTA_LWJG"].ToString() != "")
{
model.PD_QUOTA_LWJG = new int?(int.Parse(set.Tables[0].Rows[0]["PD_QUOTA_LWJG"].ToString()));
}
model.PD_QUOTA_LWJG_NAME = set.Tables[0].Rows[0]["PD_QUOTA_LWJG_NAME"].ToString();
model.PD_QUOTA_IFUP = set.Tables[0].Rows[0]["PD_QUOTA_IFUP"].ToString();
model.PD_QUOTA_ZJXZ = set.Tables[0].Rows[0]["pd_quota_zjxzCode"].ToString();
model.PD_QUOTA_TARGET = set.Tables[0].Rows[0]["PD_QUOTA_TARGET"].ToString();
model.PD_QUOTA_STANDARD = set.Tables[0].Rows[0]["PD_QUOTA_STANDARD"].ToString();
model.PD_QUOTA_BASIS = set.Tables[0].Rows[0]["PD_QUOTA_BASIS"].ToString();
model.PD_QUOTA_IFXZQS = set.Tables[0].Rows[0]["PD_QUOTA_IFXZQS_NAME"].ToString();
model.PD_QUOTA_IFPASS = set.Tables[0].Rows[0]["PD_QUOTA_IFPASS_NAME"].ToString();
model.PD_QUOTA_BASIS_JG = set.Tables[0].Rows[0]["PD_QUOTA_BASIS_JG"].ToString();
model.PD_QUOTA_INPUT_MAN = set.Tables[0].Rows[0]["PD_QUOTA_INPUT_MAN"].ToString();
model.PD_QUOTA_PASS_DATE = set.Tables[0].Rows[0]["PD_QUOTA_PASS_DATE"].ToString();
model.PD_QUOTA_ACCEPT_MAN = set.Tables[0].Rows[0]["PD_QUOTA_ACCEPT_MAN"].ToString();
model.PD_QUOTA_PASS_MAN = set.Tables[0].Rows[0]["PD_QUOTA_PASS_MAN"].ToString();
model.PD_QUOTA_ACCEPT_COMPANY = set.Tables[0].Rows[0]["PD_QUOTA_ACCEPT_COMPANY_NAME"].ToString();
model.PD_QUOTA_ACCEPT_DATE = set.Tables[0].Rows[0]["PD_QUOTA_ACCEPT_DATE"].ToString();
model.PD_QUOTA_IFLLYQS = set.Tables[0].Rows[0]["PD_QUOTA_IFLLYQS_NAME"].ToString();
model.PD_QUOTA_IFXZHZ = set.Tables[0].Rows[0]["PD_QUOTA_IFXZHZ_NAME"].ToString();
model.PD_QUOTA_FILE = set.Tables[0].Rows[0]["PD_QUOTA_FILE"].ToString();
model.PD_QUOTA_XZ_ACCEPT_COMPANY = set.Tables[0].Rows[0]["PD_QUOTA_XZ_ACCEPT_COMPANY"].ToString();
if (set.Tables[0].Rows[0]["PD_QUOTA_XZ_ACCEPT_DATE"].ToString() != "")
{
model.PD_QUOTA_XZ_ACCEPT_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_QUOTA_XZ_ACCEPT_DATE"].ToString()));
}
if (set.Tables[0].Rows[0]["PD_QUOTA_MONEY_TOTAL"].ToString() != "")
{
model.PD_QUOTA_MONEY_TOTAL = decimal.Parse(set.Tables[0].Rows[0]["PD_QUOTA_MONEY_TOTAL"].ToString());
}
model.PD_QUOTA_DEPART = set.Tables[0].Rows[0]["PD_QUOTA_DEPART"].ToString();
model.PD_QUOTA_JGYQ = set.Tables[0].Rows[0]["PD_QUOTA_JGYQ"].ToString();
if (set.Tables[0].Rows[0]["PD_QUOTA_INPUT_DATE"].ToString() != "")
{
model.PD_QUOTA_INPUT_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_QUOTA_INPUT_DATE"].ToString()));
}
model.PD_QUOTA_INPUT_COMPANY = set.Tables[0].Rows[0]["PD_QUOTA_INPUT_COMPANY"].ToString();
model.INPUT_COMPANYNAME = new PublicModel();
model.INPUT_COMPANYNAME.PK_CODE = set.Tables[0].Rows[0]["PD_QUOTA_INPUT_COMPANY"].ToString();
model.PD_QUOTA_XZ_ACCEPT_MAN = set.Tables[0].Rows[0]["PD_QUOTA_XZ_ACCEPT_MAN"].ToString();
model.PD_PROJ_STATUS = set.Tables[0].Rows[0]["PD_PROJ_STATUS"].ToString();
model.PD_PROJ_LAST_AUDIT_STATUS = set.Tables[0].Rows[0]["PD_PROJ_LAST_AUDIT_STATUS"].ToString();
model.PD_QUOTA_ZBWH = set.Tables[0].Rows[0]["pd_quota_zbwh"].ToString();
if (set.Tables[0].Rows[0]["PD_QUOTA_FWDATA"].ToString() != "")
{
model.PD_QUOTA_FWDATA = DateTime.Parse(set.Tables[0].Rows[0]["PD_QUOTA_FWDATA"].ToString());
}
model.PD_QUOTA_COMPANY = set.Tables[0].Rows[0]["PD_QUOTA_COMPANY"].ToString();
model.PD_QUOTA_ZBYT = set.Tables[0].Rows[0]["PD_QUOTA_ZBYT"].ToString();
model.PD_QUOTA_QCDW = set.Tables[0].Rows[0]["PD_QUOTA_QCDW"].ToString();
model.PD_QUOTA_QCBM = set.Tables[0].Rows[0]["PD_QUOTA_QCBM"].ToString();
model.PD_QUOTA_GLLX = set.Tables[0].Rows[0]["PD_QUOTA_GLLX"].ToString();
model.PD_QUOTA_JJLX = set.Tables[0].Rows[0]["PD_QUOTA_JJLX"].ToString();
model.PD_QUOTA_ZJLY = set.Tables[0].Rows[0]["PD_QUOTA_ZJLY"].ToString();
model.PD_QUOTA_ZGKJ = set.Tables[0].Rows[0]["PD_QUOTA_ZGKJ"].ToString();
model.PD_QUOTA_XMZGBM = set.Tables[0].Rows[0]["PD_QUOTA_XMZGBM"].ToString();
model.PD_QUOTA_ISUP = set.Tables[0].Rows[0]["PD_QUOTA_ISUP_NAME"].ToString();
model.PD_QUOTA_ZBXDZH = set.Tables[0].Rows[0]["PD_QUOTA_ZBXDZH"].ToString();
model.PD_QUOTA_ZGBM = set.Tables[0].Rows[0]["PD_QUOTA_ZGBM"].ToString();
model.PD_QUOTA_PASS_COMPANY = set.Tables[0].Rows[0]["PD_QUOTA_PASS_COMPANY_NAME"].ToString();
model.PD_QUOTA_PASS_DEPART = set.Tables[0].Rows[0]["PD_QUOTA_PASS_DEPART_NAME"].ToString();
model.PD_QUOTA_ACCEPT_DEPART = set.Tables[0].Rows[0]["PD_QUOTA_ACCEPT_DEPART_NAME"].ToString();
model.PD_QUOTA_UP_COMPANY = set.Tables[0].Rows[0]["PD_QUOTA_UP_COMPANY_NAME"].ToString();
model.PD_QUOTA_UP_DEPART = set.Tables[0].Rows[0]["PD_QUOTA_UP_DEPART_NAME"].ToString();
model.PD_QUOTA_UP_DATE = set.Tables[0].Rows[0]["PD_QUOTA_UP_DATE"].ToString();
model.PD_QUOTA_UP_MAN = set.Tables[0].Rows[0]["PD_QUOTA_UP_MAN"].ToString();
model.PD_QUOTA_SERVERPK = set.Tables[0].Rows[0]["pd_quota_serverpk"].ToString();
if (set.Tables[0].Rows[0]["PD_IS_RETURN"].ToString() != "")
{
model.PD_IS_RETURN = new int?(int.Parse(set.Tables[0].Rows[0]["PD_IS_RETURN"].ToString()));
}
if (set.Tables[0].Rows[0]["PD_ISOUT_QUOTA"].ToString() != "")
{
model.PD_ISOUT_QUOTA = new int?(int.Parse(set.Tables[0].Rows[0]["PD_ISOUT_QUOTA"].ToString()));
}
model.PD_QUOTA_PICI = set.Tables[0].Rows[0]["PD_QUOTA_PICI"].ToString();
model.PD_JY_MONEY = set.Tables[0].Rows[0]["PD_JY_MONEY"].ToString();
model.PD_QUOTA_YSLX = set.Tables[0].Rows[0]["PD_QUOTA_YSLX"].ToString();
model.Free1 = set.Tables[0].Rows[0]["Free1"].ToString();
model.Free2 = set.Tables[0].Rows[0]["Free2"].ToString();
model.Free3 = set.Tables[0].Rows[0]["Free3"].ToString();
model.Free4 = set.Tables[0].Rows[0]["Free4"].ToString();
model.Free5 = set.Tables[0].Rows[0]["Free5"].ToString();
if (set.Tables[0].Rows[0]["Free6"].ToString() != "")
{
model.Free6 = int.Parse(set.Tables[0].Rows[0]["Free6"].ToString());
}
if (set.Tables[0].Rows[0]["Free7"].ToString() != "")
{
model.Free7 = int.Parse(set.Tables[0].Rows[0]["Free7"].ToString());
}
if (set.Tables[0].Rows[0]["Free8"].ToString() != "")
{
model.Free8 = decimal.Parse(set.Tables[0].Rows[0]["Free8"].ToString());
}
if (set.Tables[0].Rows[0]["Free9"].ToString() != "")
{
model.Free9 = decimal.Parse(set.Tables[0].Rows[0]["Free9"].ToString());
}
if (set.Tables[0].Rows[0]["Free10"].ToString() != "")
{
model.Free10 = decimal.Parse(set.Tables[0].Rows[0]["Free10"].ToString());
}
return model;
}
public List<TB_QUOTA_Model> DataTableToList(DataTable dt)
{
List<TB_QUOTA_Model> list = new List<TB_QUOTA_Model>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
TB_QUOTA_Model item = new TB_QUOTA_Model {
AUTO_NO = dt.Rows[i]["AUTO_NO"].ToString(),
PD_QUOTA_CODE = dt.Rows[i]["PD_QUOTA_CODE"].ToString(),
PD_QUOTA_NAME = dt.Rows[i]["PD_QUOTA_NAME"].ToString(),
PD_YEAR = dt.Rows[i]["PD_YEAR"].ToString()
};
if (dt.Rows[i]["PD_QUOTA_LWJG"].ToString() != "")
{
item.PD_QUOTA_LWJG = new int?(int.Parse(dt.Rows[i]["PD_QUOTA_LWJG"].ToString()));
}
item.PD_QUOTA_IFUP = dt.Rows[i]["PD_QUOTA_IFUP"].ToString();
item.PD_QUOTA_ZJXZ = dt.Rows[i]["PD_QUOTA_ZJXZ"].ToString();
item.PD_QUOTA_TARGET = dt.Rows[i]["PD_QUOTA_TARGET"].ToString();
item.PD_QUOTA_STANDARD = dt.Rows[i]["PD_QUOTA_STANDARD"].ToString();
item.PD_QUOTA_BASIS = dt.Rows[i]["PD_QUOTA_BASIS"].ToString();
item.PD_QUOTA_IFXZQS = dt.Rows[i]["PD_QUOTA_IFXZQS"].ToString();
item.PD_QUOTA_IFPASS = dt.Rows[i]["PD_QUOTA_IFPASS"].ToString();
item.PD_QUOTA_BASIS_JG = dt.Rows[i]["PD_QUOTA_BASIS_JG"].ToString();
item.PD_QUOTA_INPUT_MAN = dt.Rows[i]["PD_QUOTA_INPUT_MAN"].ToString();
item.PD_QUOTA_PASS_DATE = dt.Rows[i]["PD_QUOTA_PASS_DATE"].ToString();
item.PD_QUOTA_ACCEPT_MAN = dt.Rows[i]["PD_QUOTA_ACCEPT_MAN"].ToString();
item.PD_QUOTA_PASS_MAN = dt.Rows[i]["PD_QUOTA_PASS_MAN"].ToString();
item.PD_QUOTA_ACCEPT_COMPANY = dt.Rows[i]["PD_QUOTA_ACCEPT_COMPANY"].ToString();
item.PD_QUOTA_ACCEPT_DATE = dt.Rows[i]["PD_QUOTA_ACCEPT_DATE"].ToString();
if (dt.Rows[i]["PD_QUOTA_IFLLYQS"].ToString() != "")
{
item.PD_QUOTA_IFLLYQS = dt.Rows[i]["PD_QUOTA_IFLLYQS"].ToString();
}
item.PD_QUOTA_FILE = dt.Rows[i]["PD_QUOTA_FILE"].ToString();
item.PD_QUOTA_XZ_ACCEPT_COMPANY = dt.Rows[i]["PD_QUOTA_XZ_ACCEPT_COMPANY"].ToString();
if (dt.Rows[i]["PD_QUOTA_XZ_ACCEPT_DATE"].ToString() != "")
{
item.PD_QUOTA_XZ_ACCEPT_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_QUOTA_XZ_ACCEPT_DATE"].ToString()));
}
if (dt.Rows[i]["PD_QUOTA_MONEY_TOTAL"].ToString() != "")
{
item.PD_QUOTA_MONEY_TOTAL = int.Parse(dt.Rows[i]["PD_QUOTA_MONEY_TOTAL"].ToString());
}
item.PD_QUOTA_DEPART = dt.Rows[i]["PD_QUOTA_DEPART"].ToString();
item.PD_QUOTA_JGYQ = dt.Rows[i]["PD_QUOTA_JGYQ"].ToString();
if (dt.Rows[i]["PD_QUOTA_INPUT_DATE"].ToString() != "")
{
item.PD_QUOTA_INPUT_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_QUOTA_INPUT_DATE"].ToString()));
}
item.PD_QUOTA_INPUT_COMPANY = dt.Rows[i]["PD_QUOTA_INPUT_COMPANY"].ToString();
item.PD_QUOTA_XZ_ACCEPT_MAN = dt.Rows[i]["PD_QUOTA_XZ_ACCEPT_MAN"].ToString();
item.PD_PROJ_STATUS = dt.Rows[i]["PD_PROJ_STATUS"].ToString();
item.PD_PROJ_LAST_AUDIT_STATUS = dt.Rows[i]["PD_PROJ_LAST_AUDIT_STATUS"].ToString();
if (dt.Rows[i]["PD_IS_RETURN"].ToString() != "")
{
item.PD_IS_RETURN = new int?(int.Parse(dt.Rows[i]["PD_IS_RETURN"].ToString()));
}
if (dt.Rows[i]["PD_ISOUT_QUOTA"].ToString() != "")
{
item.PD_ISOUT_QUOTA = new int?(int.Parse(dt.Rows[i]["PD_ISOUT_QUOTA"].ToString()));
}
list.Add(item);
}
}
return list;
}
public TB_QUOTA_Model GetIsUpModel(string PD_QUOTA_CODE)
{
StringBuilder builder = new StringBuilder();
builder.Append("select PD_QUOTA_ISUP,PD_QUOTA_INPUT_DEPART,PD_QUOTA_SERVERPK,PD_QUOTA_IFXZHZ,PD_QUOTA_IFSBXM from TB_QUOTA ");
builder.Append(" where trim(PD_QUOTA_CODE)=:PD_QUOTA_CODE ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_QUOTA_CODE", OracleType.VarChar, 30) };
cmdParms[0].Value = PD_QUOTA_CODE;
DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms);
TB_QUOTA_Model model = new TB_QUOTA_Model();
if (set.Tables[0].Rows.Count > 0)
{
model.PD_QUOTA_ISUP = set.Tables[0].Rows[0]["PD_QUOTA_ISUP"].ToString().Trim();
model.PD_QUOTA_INPUT_DEPART = set.Tables[0].Rows[0]["PD_QUOTA_INPUT_DEPART"].ToString().Trim();
model.PD_QUOTA_SERVERPK = set.Tables[0].Rows[0]["PD_QUOTA_SERVERPK"].ToString().Trim();
model.PD_QUOTA_IFXZHZ = set.Tables[0].Rows[0]["PD_QUOTA_IFXZHZ"].ToString().Trim();
model.PD_QUOTA_IFSBXM = set.Tables[0].Rows[0]["PD_QUOTA_IFSBXM"].ToString().Trim();
return model;
}
return null;
}
public bool Update(TB_QUOTA_Model model)
{
return this.dal.Update(model);
}
public void Add(TB_QUOTA_Model model, string wh)
{
this.dal.Add(model, wh);
}
private TB_QUOTA_Model GetModel(TB_QUOTA_Model model)
{
if (model == null)
{
model = new TB_QUOTA_Model();
}
model.PD_QUOTA_ZJLY = this.ddlzjly.SelectedValue;
model.PD_QUOTA_ZGKJ = this.ddlzgkj.SelectedValue;
model.PD_QUOTA_JJLX = this.hjj.Value;
model.PD_QUOTA_GLLX = this.hgl.Value;
model.PD_QUOTA_ZBXDZH = this.txtPD_QUOTA_ZBXDZH.Text;
model.AUTO_NO = "";
model.PD_QUOTA_NAME = this.txtPD_QUOTA_NAME.Text;
model.PD_YEAR = this.ddlPD_YEAR.SelectedValue;
model.PD_QUOTA_LWJG = 0;
if (this.txtPD_QUOTA_LWJG.SelectedValue.Trim() != "")
{
model.PD_QUOTA_LWJG = new int?(int.Parse(this.txtPD_QUOTA_LWJG.SelectedValue));
}
model.PD_QUOTA_IFUP = this.ddlPD_QUOTA_IFUP.SelectedValue;
model.PD_QUOTA_ZJXZ = this.ddlPD_QUOTA_ZJXZ.SelectedValue;
model.PD_QUOTA_TARGET = this.txtPD_QUOTA_TARGET.Text;
model.PD_QUOTA_STANDARD = this.txtPD_QUOTA_STANDARD.Text;
model.PD_QUOTA_BASIS = this.txtPD_QUOTA_BASIS.Text;
model.PD_QUOTA_BASIS_JG = this.txtPD_QUOTA_BASIS_JG.Text;
model.PD_QUOTA_MONEY_TOTAL = 0M;
if (this.txtPD_QUOTA_MONEY_TOTAL.Text.Trim() != "")
{
model.PD_QUOTA_MONEY_TOTAL = decimal.Parse(this.txtPD_QUOTA_MONEY_TOTAL.Text);
}
model.PD_QUOTA_DEPART = this.ddlPD_QUOTA_DEPART.SelectedValue;
model.PD_QUOTA_JGYQ = this.txtPD_QUOTA_JGYQ.Text;
model.PD_PROJ_STATUS = this.ddlPD_PROJ_STATUS.SelectedValue;
model.PD_PROJ_LAST_AUDIT_STATUS = this.ddlPD_PROJ_LAST_AUDIT_STATUS.SelectedValue;
if (this.ddlPD_IS_RETURN.SelectedValue.Trim() != "")
{
model.PD_IS_RETURN = new int?(int.Parse(this.ddlPD_IS_RETURN.SelectedValue));
}
if (this.ddlPD_ISOUT_QUOTA.SelectedValue.Trim() != "")
{
model.PD_ISOUT_QUOTA = new int?(int.Parse(this.ddlPD_ISOUT_QUOTA.SelectedValue));
}
model.PD_QUOTA_ZBWH = this.txtPD_QUOTA_ZBWH.Text;
if (this.txtPD_QUOTA_FWDATA.Text.Trim() != "")
{
model.PD_QUOTA_FWDATA = DateTime.Parse(this.txtPD_QUOTA_FWDATA.Text);
}
model.PD_QUOTA_COMPANY = this.txtPD_QUOTA_COMPANY.Text;
model.PD_QUOTA_ZBYT = this.txtPD_QUOTA_ZBYT.Text;
model.PD_QUOTA_ZGBM = this.txtPD_QUOTA_ZGBM.Text;
model.PD_QUOTA_PICI = this.PD_QUOTA_PICI.Value;
model.PD_QUOTA_YSLX = this.ddlPD_QUOTA_YSLX.SelectedValue;
return model;
}
private void GetQUOTA(TB_QUOTA_Model model)
{
DataSet set = null;
DataView defaultView = null;
string s = base.Server.UrlDecode(this.FilePostCtr1.getFileName);
if ((s != null) && (s.Trim() != ""))
{
set = new DataSet();
XmlTextReader reader = new XmlTextReader(new StringReader(s));
set.ReadXml(reader);
}
if ((set != null) && (set.Tables.Count > 0))
{
defaultView = set.Tables[0].DefaultView;
}
if (defaultView != null)
{
defaultView.RowFilter = " tableID='zxzb_bt' ";
if (defaultView.Count > 0)
{
model.PD_QUOTA_FILE = defaultView[0]["FileSysName"].ToString() + "|" + defaultView[0]["FileName"].ToString();
}
}
}
private void Bind1(string PD_QUOTA_CODE, TB_QUOTA_Model model, bool IsCreate)
{
if (PD_QUOTA_CODE == "")
{
this.txtPD_QUOTA_ZGBM.Text = "乡镇人民政府";
}
SMZJ.BLL.TB_QUOTA_DETAIL tb_quota_detail = new SMZJ.BLL.TB_QUOTA_DETAIL();
string strWhere = " PD_QUOTA_CODE='" + PD_QUOTA_CODE + "' and IF_SHOW=1 ";
if (!IsCreate)
{
string str2 = ((UserModel)HttpContext.Current.Session["User"]).Company.pk_corp;
if (str2.Trim() != model.PD_QUOTA_INPUT_COMPANY.Trim())
{
strWhere = strWhere + " and COMPANY_CODE like '" + str2 + "%'";
}
}
else
{
strWhere = " 1=0 ";
}
DataSet list = tb_quota_detail.GetList(strWhere);
this.json_xzxxData.Value = base.Server.UrlEncode(PublicDal.DataToJSON(list));
if (list.Tables[0].Rows.Count > 0)
{
list.Tables[0].Rows.Clear();
}
DataRow row = list.Tables[0].NewRow();
row["PD_QUOTA_CODE"] = PD_QUOTA_CODE;
list.Tables[0].Rows.Add(row);
this.json_xzxx.Value = base.Server.UrlEncode(PublicDal.DataToJSON(list));
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("AUTO_NO");
ds.Tables[0].Columns.Add("FILE_NAME");
ds.Tables[0].Columns.Add("FILE_SYSNAME");
if ((model != null) && this.tr_wjzl.Visible)
{
string[] strArray = model.PD_QUOTA_FILE.Split(new char[] { '|' });
if (strArray.Length > 1)
{
DataRow row2 = ds.Tables[0].NewRow();
row2["AUTO_NO"] = model.AUTO_NO;
row2["FILE_NAME"] = strArray[1];
row2["FILE_SYSNAME"] = strArray[0];
ds.Tables[0].Rows.Add(row2);
}
}
this.json_btData.Value = base.Server.UrlEncode(PublicDal.DataToJSON(ds));
}
private void UpdataData(string PD_QUOTA_CODE)
{
string strErr = "";
if (!this.PanDuan(ref strErr))
{
this.hy_File(null, strErr);
}
else
{
TB_QUOTA_Bll bll = new TB_QUOTA_Bll();
TB_QUOTA_Model model = new TB_QUOTA_Model();
model = bll.GetModel(PD_QUOTA_CODE);
model = this.GetModel(model);
model.PD_QUOTA_CODE = PD_QUOTA_CODE;
this.GetQUOTA(model);
bll.Update(model);
SMZJ.BLL.TB_QUOTA_DETAIL tb_quota_detail = new SMZJ.BLL.TB_QUOTA_DETAIL();
List<SMZJ.Model.TB_QUOTA_DETAIL> qUOTAModel = this.GetQUOTAModel(PD_QUOTA_CODE);
tb_quota_detail.DeleteProject(PD_QUOTA_CODE);
tb_quota_detail.AddList(qUOTAModel);
this.UpdateLog(PD_QUOTA_CODE, "修改指标", "执行 修改 成功", "", PD_QUOTA_CODE, "", "");
PageShowText.Refurbish("修改成功", this.Page);
}
}
private bool ZhiBiaoInPut()
{
if (this.gvResult.Rows.Count > 0)
{
TB_QUOTA_Bll bll = new TB_QUOTA_Bll();
List<TB_QUOTA_Model> modelList = new List<TB_QUOTA_Model>();
UserModel model = (UserModel)this.Session["User"];
string userName = model.UserName;
string str2 = model.Company.pk_corp;
string bH = model.Branch.BH;
DateTime now = DateTime.Now;
string databaseName = this.hiddDatabase.Value;
PublicDal.SetCreateServiceStream(this.Page, "ZBOper.aspx");
foreach (GridViewRow row in this.gvResult.Rows)
{
if (((CheckBox)row.Cells[0].FindControl("checkbox1")).Checked)
{
TB_QUOTA_Model item = new TB_QUOTA_Model
{
PD_QUOTA_CODE = DateTime.Now.ToString("yyyyMMddhhmmssffffff")
};
if (PublicDal.PageValidate.IsDateTime(row.Cells[1].Text))
{
item.PD_QUOTA_FWDATA = DateTime.Parse(row.Cells[1].Text);
}
item.PD_QUOTA_ZBWH = row.Cells[2].Text;
item.PD_QUOTA_NAME = row.Cells[3].Text;
item.PD_YEAR = row.Cells[4].Text;
item.PD_QUOTA_ZJXZ = row.Cells[5].Text;
if (PublicDal.PageValidate.IsDecimal(row.Cells[6].Text))
{
item.PD_QUOTA_MONEY_TOTAL = decimal.Parse(row.Cells[6].Text);
}
item.PD_QUOTA_ZBXDZH = row.Cells[7].Text;
item.PD_QUOTA_ZBYT = row.Cells[8].Text;
item.PD_QUOTA_GLLX = row.Cells[9].Text;
item.PD_QUOTA_JJLX = row.Cells[10].Text;
item.PD_QUOTA_INPUT_MAN = userName;
item.PD_QUOTA_INPUT_COMPANY = str2;
item.PD_QUOTA_INPUT_DATE = new DateTime?(now);
item.PD_QUOTA_INPUT_DEPART = bH;
modelList.Add(item);
}
}
if (modelList.Count > 0)
{
bll.AddList(modelList, databaseName);
this.JS_BindShow("导入成功!");
return true;
}
this.JS_BindShow("请选择一行数据进行导入!");
}
else
{
this.JS_BindShow("请先查询数据!");
}
return false;
}
private void Bind1(string PD_QUOTA_CODE, TB_QUOTA_Model model)
{
DataSet list = new SMZJ.BLL.TB_QUOTA_DETAIL().GetList(" PD_QUOTA_CODE='" + PD_QUOTA_CODE + "'");
this.json_xzxxData = PublicDal.DataToJSON(list);
if (list.Tables[0].Rows.Count > 0)
{
list.Tables[0].Rows.Clear();
}
DataRow row = list.Tables[0].NewRow();
row["PD_QUOTA_CODE"] = PD_QUOTA_CODE;
list.Tables[0].Rows.Add(row);
this.json_xzxx = PublicDal.DataToJSON(list);
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("AUTO_NO");
ds.Tables[0].Columns.Add("FILE_NAME");
ds.Tables[0].Columns.Add("FILE_SYSNAME");
if (model != null)
{
string[] strArray = model.PD_QUOTA_FILE.Split(new char[] { '|' });
if (strArray.Length > 1)
{
DataRow row2 = ds.Tables[0].NewRow();
row2["AUTO_NO"] = model.AUTO_NO;
row2["FILE_NAME"] = strArray[1];
row2["FILE_SYSNAME"] = strArray[0];
ds.Tables[0].Rows.Add(row2);
}
}
this.json_btData = PublicDal.DataToJSON(ds);
}
public void btnUpdate_Click(object sender, EventArgs e)
{
string text = this.txtPD_QUOTA_CODE.Text;
string str2 = this.txtPD_QUOTA_NAME.Text;
int num = int.Parse(this.txtPD_QUOTA_LWJG.Text);
string str3 = this.ddlPD_QUOTA_ZJXZ.Text;
int num2 = int.Parse(this.txtPD_QUOTA_MONEY_TOTAL.Text);
string selectedValue = this.ddlPD_QUOTA_DEPART.SelectedValue;
string str5 = this.txtPD_QUOTA_JGYQ.Text;
DateTime time = DateTime.Parse(this.txtPD_QUOTA_INPUT_DATE.Text);
string str6 = this.txtPD_QUOTA_INPUT_MAN.Text;
string str7 = this.txtPD_QUOTA_PASS_DATE.Text;
string str8 = this.txtPD_QUOTA_PASS_MAN.Text;
string str9 = this.txtPD_QUOTA_ACCEPT_DATE.Text;
string str10 = this.txtPD_QUOTA_ACCEPT_MAN.Text;
string str11 = this.ddlPD_QUOTA_IFLLYQS.SelectedValue;
string str12 = this.ddlPD_QUOTA_IFXZQS.SelectedValue;
DateTime time2 = DateTime.Parse(this.txtPD_QUOTA_XZ_ACCEPT_DATE.Text);
string str13 = this.txtPD_QUOTA_XZ_ACCEPT_MAN.Text;
TB_QUOTA_Model model = new TB_QUOTA_Model
{
PD_QUOTA_CODE = text,
PD_QUOTA_NAME = str2,
PD_QUOTA_LWJG = new int?(num),
PD_QUOTA_ZJXZ = str3,
PD_QUOTA_MONEY_TOTAL = num2,
PD_QUOTA_DEPART = selectedValue,
PD_QUOTA_JGYQ = str5,
PD_QUOTA_INPUT_DATE = new DateTime?(time),
PD_QUOTA_INPUT_MAN = str6,
PD_QUOTA_PASS_DATE = str7,
PD_QUOTA_PASS_MAN = str8,
PD_QUOTA_ACCEPT_DATE = str9,
PD_QUOTA_ACCEPT_MAN = str10,
PD_QUOTA_IFLLYQS = str11,
PD_QUOTA_IFXZQS = str12,
PD_QUOTA_FILE = "",
PD_QUOTA_XZ_ACCEPT_DATE = new DateTime?(time2),
PD_QUOTA_XZ_ACCEPT_MAN = str13
};
new TB_QUOTA_Bll().Update(model);
PageShowText.Refurbish("修改成功", this.Page);
}