public void Add(PD_PROJECT_LOG_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PD_PROJECT_LOG(");
builder.Append("AUTOID,PD_PROJECT_TYPE,PD_PROJECT_CODE,MAN,COMPANY,BM,EXE_DTIME,EXE_CZ,EXE_JG,EXE_TXT,FREE1,FREE2,FREE3)");
builder.Append(" values (");
builder.Append(":AUTOID,:PD_PROJECT_TYPE,:PD_PROJECT_CODE,:MAN,:COMPANY,:BM,:EXE_DTIME,:EXE_CZ,:EXE_JG,:EXE_TXT,:FREE1,:FREE2,:FREE3)");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTOID", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_TYPE", OracleType.Char, 1), new OracleParameter(":PD_PROJECT_CODE", OracleType.NVarChar), new OracleParameter(":MAN", OracleType.NVarChar), new OracleParameter(":COMPANY", OracleType.NVarChar), new OracleParameter(":BM", OracleType.NVarChar), new OracleParameter(":EXE_DTIME", OracleType.NVarChar), new OracleParameter(":EXE_CZ", OracleType.NVarChar), new OracleParameter(":EXE_JG", OracleType.NVarChar), new OracleParameter(":EXE_TXT", OracleType.NVarChar), new OracleParameter(":FREE1", OracleType.NVarChar), new OracleParameter(":FREE2", OracleType.NVarChar), new OracleParameter(":FREE3", OracleType.NVarChar) };
cmdParms[0].Value = model.AUTOID;
cmdParms[1].Value = model.PD_PROJECT_TYPE;
cmdParms[2].Value = model.PD_PROJECT_CODE;
cmdParms[3].Value = model.MAN;
cmdParms[4].Value = model.COMPANY;
cmdParms[5].Value = model.BM;
cmdParms[6].Value = model.EXE_DTIME;
cmdParms[7].Value = model.EXE_CZ;
cmdParms[8].Value = model.EXE_JG;
cmdParms[9].Value = model.EXE_TXT;
cmdParms[10].Value = model.FREE1;
cmdParms[11].Value = model.FREE2;
cmdParms[12].Value = model.FREE3;
DbHelperOra.ExecuteSql(builder.ToString(), cmdParms);
}
public PD_PROJECT_LOG_Model GetModel(string PD_PROJECT_CODE)
{
StringBuilder builder = new StringBuilder();
builder.Append("select AUTOID,PD_PROJECT_TYPE,PD_PROJECT_CODE,MAN,COMPANY,BM,EXE_DTIME,EXE_CZ,EXE_JG,EXE_TXT,FREE1,FREE2,FREE3 from PD_PROJECT_LOG ");
builder.Append(" where PD_PROJECT_CODE=:PD_PROJECT_CODE ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.NVarChar) };
cmdParms[0].Value = PD_PROJECT_CODE;
PD_PROJECT_LOG_Model model = new PD_PROJECT_LOG_Model();
DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count > 0)
{
model.AUTOID = set.Tables[0].Rows[0]["AUTOID"].ToString();
model.PD_PROJECT_TYPE = set.Tables[0].Rows[0]["PD_PROJECT_TYPE"].ToString();
model.PD_PROJECT_CODE = set.Tables[0].Rows[0]["PD_PROJECT_CODE"].ToString();
model.MAN = set.Tables[0].Rows[0]["MAN"].ToString();
model.COMPANY = set.Tables[0].Rows[0]["COMPANY"].ToString();
model.BM = set.Tables[0].Rows[0]["BM"].ToString();
model.EXE_DTIME = set.Tables[0].Rows[0]["EXE_DTIME"].ToString();
model.EXE_CZ = set.Tables[0].Rows[0]["EXE_CZ"].ToString();
model.EXE_JG = set.Tables[0].Rows[0]["EXE_JG"].ToString();
model.EXE_TXT = set.Tables[0].Rows[0]["EXE_TXT"].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();
return model;
}
return null;
}
public bool Update(PD_PROJECT_LOG_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PD_PROJECT_LOG set ");
builder.Append("PD_PROJECT_TYPE=:PD_PROJECT_TYPE,");
builder.Append("PD_PROJECT_CODE=:PD_PROJECT_CODE,");
builder.Append("MAN=:MAN,");
builder.Append("COMPANY=:COMPANY,");
builder.Append("BM=:BM,");
builder.Append("EXE_DTIME=:EXE_DTIME,");
builder.Append("EXE_CZ=:EXE_CZ,");
builder.Append("EXE_JG=:EXE_JG,");
builder.Append("EXE_TXT=:EXE_TXT,");
builder.Append("FREE1=:FREE1,");
builder.Append("FREE2=:FREE2,");
builder.Append("FREE3=:FREE3");
builder.Append(" where PD_PROJECT_CODE=:PD_PROJECT_CODE ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_TYPE", OracleType.Char, 1), new OracleParameter(":PD_PROJECT_CODE", OracleType.NVarChar), new OracleParameter(":MAN", OracleType.NVarChar), new OracleParameter(":COMPANY", OracleType.NVarChar), new OracleParameter(":BM", OracleType.NVarChar), new OracleParameter(":EXE_DTIME", OracleType.NVarChar), new OracleParameter(":EXE_CZ", OracleType.NVarChar), new OracleParameter(":EXE_JG", OracleType.NVarChar), new OracleParameter(":EXE_TXT", OracleType.NVarChar), new OracleParameter(":FREE1", OracleType.NVarChar), new OracleParameter(":FREE2", OracleType.NVarChar), new OracleParameter(":FREE3", OracleType.NVarChar), new OracleParameter(":AUTOID", OracleType.Number, 4) };
cmdParms[0].Value = model.PD_PROJECT_TYPE;
cmdParms[1].Value = model.PD_PROJECT_CODE;
cmdParms[2].Value = model.MAN;
cmdParms[3].Value = model.COMPANY;
cmdParms[4].Value = model.BM;
cmdParms[5].Value = model.EXE_DTIME;
cmdParms[6].Value = model.EXE_CZ;
cmdParms[7].Value = model.EXE_JG;
cmdParms[8].Value = model.EXE_TXT;
cmdParms[9].Value = model.FREE1;
cmdParms[10].Value = model.FREE2;
cmdParms[11].Value = model.FREE3;
cmdParms[12].Value = model.AUTOID;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public static void UpdateLog(string TYPE, string CODE, string EXE_CZ, string EXE_JG, string EXE_TXT, string FREE1, string FREE2, string FREE3, Page page)
{
if (HttpContext.Current.Session["User"] == null)
{
PageShowText.GoLoginPath_List(page);
}
else
{
PD_PROJECT_LOG_Bll bll = new PD_PROJECT_LOG_Bll();
UserModel model = (UserModel) page.Session["User"];
PD_PROJECT_LOG_Model model2 = new PD_PROJECT_LOG_Model {
AUTOID = DateTime.Now.ToString("yyyyMMddhhmmssffffff"),
BM = model.Branch.BH,
COMPANY = page.Session["pk_corp"].ToString(),
PD_PROJECT_CODE = CODE,
PD_PROJECT_TYPE = TYPE,
MAN = model.UserName,
EXE_CZ = EXE_CZ,
EXE_DTIME = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"),
EXE_JG = EXE_JG,
EXE_TXT = EXE_TXT,
FREE1 = FREE1,
FREE2 = FREE2,
FREE3 = FREE3
};
bll.Add(model2);
}
}