public PD_PROJECT_PUBLICEXCEL_Model DataRowToModel(DataRow row)
{
PD_PROJECT_PUBLICEXCEL_Model model = new PD_PROJECT_PUBLICEXCEL_Model();
if (row != null)
{
if ((row["AUTO_ID"] != null) && (row["AUTO_ID"].ToString() != ""))
{
model.AUTO_ID = decimal.Parse(row["AUTO_ID"].ToString());
}
if (row["COMPANYID"] != null)
{
model.COMPANYID = row["COMPANYID"].ToString();
}
if (row["BRANCHID"] != null)
{
model.BRANCHID = row["BRANCHID"].ToString();
}
if (row["NAME"] != null)
{
model.NAME = row["NAME"].ToString();
}
if (row["TABLENAME"] != null)
{
model.TABLENAME = row["TABLENAME"].ToString();
}
if (row["PD_PROJECT_SERVERPK"] != null)
{
model.PD_PROJECT_SERVERPK = row["PD_PROJECT_SERVERPK"].ToString();
}
}
return model;
}
public bool Add(PD_PROJECT_PUBLICEXCEL_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PD_PROJECT_PUBLICEXCEL(");
builder.Append("AUTO_ID,COMPANYID,BRANCHID,NAME,TABLENAME,PD_PROJECT_SERVERPK)");
builder.Append(" values (");
builder.Append(":AUTO_ID,:COMPANYID,:BRANCHID,:NAME,:TABLENAME,:PD_PROJECT_SERVERPK)");
builder.Append(" RETURNING AUTO_ID INTO :R_Auto_No ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_ID", OracleType.Number, 10), new OracleParameter(":COMPANYID", OracleType.VarChar, 50), new OracleParameter(":BRANCHID", OracleType.VarChar, 50), new OracleParameter(":NAME", OracleType.VarChar, 50), new OracleParameter(":TABLENAME", OracleType.VarChar, 0xfa0), new OracleParameter(":PD_PROJECT_SERVERPK", OracleType.VarChar, 50), new OracleParameter(":R_Auto_No", OracleType.Number, 20) };
cmdParms[0].Value = model.AUTO_ID;
cmdParms[1].Value = model.COMPANYID;
cmdParms[2].Value = model.BRANCHID;
cmdParms[3].Value = model.NAME;
cmdParms[4].Value = model.TABLENAME;
cmdParms[5].Value = model.PD_PROJECT_SERVERPK;
cmdParms[6].Direction = ParameterDirection.Output;
int num = DbHelperOra.ExecuteSql(builder.ToString(), cmdParms);
model.AUTO_ID = decimal.Parse(cmdParms[6].Value.ToString());
return (num > 0);
}
public bool Add(PD_PROJECT_PUBLICEXCEL_Model model)
{
return this.dal.Add(model);
}
public bool Update(PD_PROJECT_PUBLICEXCEL_Model model)
{
return this.dal.Update(model);
}
public bool Update(PD_PROJECT_PUBLICEXCEL_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PD_PROJECT_PUBLICEXCEL set ");
builder.Append("COMPANYID=:COMPANYID,");
builder.Append("BRANCHID=:BRANCHID,");
builder.Append("NAME=:NAME,");
builder.Append("TABLENAME=:TABLENAME,");
builder.Append("PD_PROJECT_SERVERPK=:PD_PROJECT_SERVERPK");
builder.Append(" where AUTO_ID=:AUTO_ID ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":COMPANYID", OracleType.VarChar, 50), new OracleParameter(":BRANCHID", OracleType.VarChar, 50), new OracleParameter(":NAME", OracleType.VarChar, 50), new OracleParameter(":TABLENAME", OracleType.VarChar, 0xfa0), new OracleParameter(":PD_PROJECT_SERVERPK", OracleType.VarChar, 50), new OracleParameter(":AUTO_ID", OracleType.Number, 10) };
cmdParms[0].Value = model.COMPANYID;
cmdParms[1].Value = model.BRANCHID;
cmdParms[2].Value = model.NAME;
cmdParms[3].Value = model.TABLENAME;
cmdParms[4].Value = model.PD_PROJECT_SERVERPK;
cmdParms[5].Value = model.AUTO_ID;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
