public PD_PROJECT_TZJGC_Model DataRowToModel(DataRow row)
{
PD_PROJECT_TZJGC_Model model = new PD_PROJECT_TZJGC_Model();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if ((row["PD_BASE_TZJGC"] != null) && (row["PD_BASE_TZJGC"].ToString() != ""))
{
model.PD_BASE_TZJGC = new decimal?(decimal.Parse(row["PD_BASE_TZJGC"].ToString()));
}
if (row["TB_QUOTA_ZBWH"] != null)
{
model.TB_QUOTA_ZBWH = row["TB_QUOTA_ZBWH"].ToString();
}
if ((row["PD_PROJECT_MONEY_CZ_SJ"] != null) && (row["PD_PROJECT_MONEY_CZ_SJ"].ToString() != ""))
{
model.PD_PROJECT_MONEY_CZ_SJ = new decimal?(decimal.Parse(row["PD_PROJECT_MONEY_CZ_SJ"].ToString()));
}
if (row["PD_PROJECT_CODE"] != null)
{
model.PD_PROJECT_CODE = row["PD_PROJECT_CODE"].ToString();
}
if (row["TB_QUOTA_CODE"] != null)
{
model.TB_QUOTA_CODE = row["TB_QUOTA_CODE"].ToString();
}
}
return model;
}
public bool Add(PD_PROJECT_TZJGC_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PD_PROJECT_TZJGC(");
builder.Append("ID,PD_BASE_TZJGC,TB_QUOTA_ZBWH,PD_PROJECT_MONEY_CZ_SJ,PD_PROJECT_CODE,TB_QUOTA_CODE)");
builder.Append(" values (");
builder.Append(":ID,:PD_BASE_TZJGC,:TB_QUOTA_ZBWH,:PD_PROJECT_MONEY_CZ_SJ,:PD_PROJECT_CODE,:TB_QUOTA_CODE)");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":ID", OracleType.VarChar, 30), new OracleParameter(":PD_BASE_TZJGC", OracleType.Number, 2), new OracleParameter(":TB_QUOTA_ZBWH", OracleType.VarChar, 30), new OracleParameter(":PD_PROJECT_MONEY_CZ_SJ", OracleType.Number, 0x10), new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30), new OracleParameter(":TB_QUOTA_CODE", OracleType.VarChar, 30) };
cmdParms[0].Value = model.ID;
cmdParms[1].Value = model.PD_BASE_TZJGC;
cmdParms[2].Value = model.TB_QUOTA_ZBWH;
cmdParms[3].Value = model.PD_PROJECT_MONEY_CZ_SJ;
cmdParms[4].Value = model.PD_PROJECT_CODE;
cmdParms[5].Value = model.TB_QUOTA_CODE;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(PD_PROJECT_TZJGC_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PD_PROJECT_TZJGC set ");
builder.Append("PD_BASE_TZJGC=:PD_BASE_TZJGC,");
builder.Append("TB_QUOTA_ZBWH=:TB_QUOTA_ZBWH,");
builder.Append("PD_PROJECT_MONEY_CZ_SJ=:PD_PROJECT_MONEY_CZ_SJ,");
builder.Append("PD_PROJECT_CODE=:PD_PROJECT_CODE,");
builder.Append("TB_QUOTA_CODE=:TB_QUOTA_CODE");
builder.Append(" where ID=:ID ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_BASE_TZJGC", OracleType.Number, 2), new OracleParameter(":TB_QUOTA_ZBWH", OracleType.VarChar, 30), new OracleParameter(":PD_PROJECT_MONEY_CZ_SJ", OracleType.Number, 0x10), new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30), new OracleParameter(":TB_QUOTA_CODE", OracleType.VarChar, 30), new OracleParameter(":ID", OracleType.VarChar, 30) };
cmdParms[0].Value = model.PD_BASE_TZJGC;
cmdParms[1].Value = model.TB_QUOTA_ZBWH;
cmdParms[2].Value = model.PD_PROJECT_MONEY_CZ_SJ;
cmdParms[3].Value = model.PD_PROJECT_CODE;
cmdParms[4].Value = model.TB_QUOTA_CODE;
cmdParms[5].Value = model.ID;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Add(PD_PROJECT_TZJGC_Model model)
{
return this.dal.Add(model);
}
public bool Update(PD_PROJECT_TZJGC_Model model)
{
return this.dal.Update(model);
}
private List<PD_PROJECT_TZJGC_Model> getTZJGCModel(string PD_PROJECT_CODE)
{
List<PD_PROJECT_TZJGC_Model> list = new List<PD_PROJECT_TZJGC_Model>();
if (base.Request["PD_BASE_TZJGC"] != null)
{
string[] strArray = base.Request["PD_BASE_TZJGC"].Split(new char[] { ',' });
string[] strArray2 = base.Request["PD_PROJECT_MONEY_CZ_SJ"].Split(new char[] { ',' });
for (int i = 0; i < strArray.Length; i++)
{
PD_PROJECT_TZJGC_Model item = new PD_PROJECT_TZJGC_Model
{
PD_PROJECT_CODE = PD_PROJECT_CODE
};
if (PublicDal.PageValidate.IsInt(strArray[i]))
{
item.PD_BASE_TZJGC = new decimal?(int.Parse(strArray[i]));
}
if (PublicDal.PageValidate.IsDecimal(strArray2[i]))
{
item.PD_PROJECT_MONEY_CZ_SJ = new decimal?(decimal.Parse(strArray2[i]));
}
list.Add(item);
}
}
return list;
}