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); }