public bool Add(PD_PROJECT_PUBLICEXCEL_DETAIL_Model[] modelAll)
{
foreach (PD_PROJECT_PUBLICEXCEL_DETAIL_Model model in modelAll)
{
this.dal.Add(model);
}
return true;
}
public PD_PROJECT_PUBLICEXCEL_DETAIL_Model DataRowToModel(DataRow row)
{
PD_PROJECT_PUBLICEXCEL_DETAIL_Model model = new PD_PROJECT_PUBLICEXCEL_DETAIL_Model();
if (row != null)
{
if ((row["ID"] != null) && (row["ID"].ToString() != ""))
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if ((row["PID"] != null) && (row["PID"].ToString() != ""))
{
model.PID = new decimal?(decimal.Parse(row["PID"].ToString()));
}
if (row["TABLE_ENAME"] != null)
{
model.TABLE_ENAME = row["TABLE_ENAME"].ToString();
}
if (row["TABLE_CNAME"] != null)
{
model.TABLE_CNAME = row["TABLE_CNAME"].ToString();
}
if (row["COLUMN_ENAME"] != null)
{
model.COLUMN_ENAME = row["COLUMN_ENAME"].ToString();
}
if (row["COLUMN_CNAME"] != null)
{
model.COLUMN_CNAME = row["COLUMN_CNAME"].ToString();
}
if (row["GETSYSNAME"] != null)
{
model.GETSYSNAME = row["GETSYSNAME"].ToString();
}
if (row["ISPRIMARY"] != null)
{
model.ISPRIMARY = row["ISPRIMARY"].ToString();
}
if (row["ISDEFAULTTYPE"] != null)
{
model.ISDEFAULTTYPE = row["ISDEFAULTTYPE"].ToString();
}
if (row["DEFAULTDATA"] != null)
{
model.DEFAULTDATA = row["DEFAULTDATA"].ToString();
}
}
return model;
}
public bool Add(PD_PROJECT_PUBLICEXCEL_DETAIL_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PD_PROJECT_PUBLICEXCEL_DETAIL(");
builder.Append("ID,PID,TABLE_ENAME,TABLE_CNAME,COLUMN_ENAME,COLUMN_CNAME,GETSYSNAME,ISPRIMARY,ISDEFAULTTYPE,DEFAULTDATA)");
builder.Append(" values (");
builder.Append(":ID,:PID,:TABLE_ENAME,:TABLE_CNAME,:COLUMN_ENAME,:COLUMN_CNAME,:GETSYSNAME,:ISPRIMARY,:ISDEFAULTTYPE,:DEFAULTDATA)");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":ID", OracleType.Number, 4), new OracleParameter(":PID", OracleType.Number, 4), new OracleParameter(":TABLE_ENAME", OracleType.NVarChar), new OracleParameter(":TABLE_CNAME", OracleType.NVarChar), new OracleParameter(":COLUMN_ENAME", OracleType.NVarChar), new OracleParameter(":COLUMN_CNAME", OracleType.NVarChar), new OracleParameter(":GETSYSNAME", OracleType.NVarChar), new OracleParameter(":ISPRIMARY", OracleType.Char, 1), new OracleParameter(":ISDEFAULTTYPE", OracleType.Char, 1), new OracleParameter(":DEFAULTDATA", OracleType.NVarChar) };
cmdParms[0].Value = model.ID;
cmdParms[1].Value = model.PID;
cmdParms[2].Value = model.TABLE_ENAME;
cmdParms[3].Value = model.TABLE_CNAME;
cmdParms[4].Value = model.COLUMN_ENAME;
cmdParms[5].Value = model.COLUMN_CNAME;
cmdParms[6].Value = model.GETSYSNAME;
cmdParms[7].Value = model.ISPRIMARY;
cmdParms[8].Value = model.ISDEFAULTTYPE;
cmdParms[9].Value = model.DEFAULTDATA;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(PD_PROJECT_PUBLICEXCEL_DETAIL_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PD_PROJECT_PUBLICEXCEL_DETAIL set ");
builder.Append("PID=:PID,");
builder.Append("TABLE_ENAME=:TABLE_ENAME,");
builder.Append("TABLE_CNAME=:TABLE_CNAME,");
builder.Append("COLUMN_ENAME=:COLUMN_ENAME,");
builder.Append("COLUMN_CNAME=:COLUMN_CNAME,");
builder.Append("GETSYSNAME=:GETSYSNAME,");
builder.Append("ISPRIMARY=:ISPRIMARY,");
builder.Append("ISDEFAULTTYPE=:ISDEFAULTTYPE,");
builder.Append("DEFAULTDATA=:DEFAULTDATA");
builder.Append(" where ID=:ID ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PID", OracleType.Number, 4), new OracleParameter(":TABLE_ENAME", OracleType.NVarChar), new OracleParameter(":TABLE_CNAME", OracleType.NVarChar), new OracleParameter(":COLUMN_ENAME", OracleType.NVarChar), new OracleParameter(":COLUMN_CNAME", OracleType.NVarChar), new OracleParameter(":GETSYSNAME", OracleType.NVarChar), new OracleParameter(":ISPRIMARY", OracleType.Char, 1), new OracleParameter(":ISDEFAULTTYPE", OracleType.Char, 1), new OracleParameter(":DEFAULTDATA", OracleType.NVarChar), new OracleParameter(":ID", OracleType.Number, 4) };
cmdParms[0].Value = model.PID;
cmdParms[1].Value = model.TABLE_ENAME;
cmdParms[2].Value = model.TABLE_CNAME;
cmdParms[3].Value = model.COLUMN_ENAME;
cmdParms[4].Value = model.COLUMN_CNAME;
cmdParms[5].Value = model.GETSYSNAME;
cmdParms[6].Value = model.ISPRIMARY;
cmdParms[7].Value = model.ISDEFAULTTYPE;
cmdParms[8].Value = model.DEFAULTDATA;
cmdParms[9].Value = model.ID;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Add(PD_PROJECT_PUBLICEXCEL_DETAIL_Model model)
{
return this.dal.Add(model);
}
public bool Update(PD_PROJECT_PUBLICEXCEL_DETAIL_Model model)
{
return this.dal.Update(model);
}
