public bool Add(PD_PROJECT_GKGS_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PD_PROJECT_GKGS(");
builder.Append("AUTO_NO,PD_PROJECT_CODE,PD_PROJECT_TYPE,PD_GS_TYPE,PD_GS_STYLE,PD_GS_ZHUTI,PD_GS_DATE,PD_GS_ADDR,PD_GS_FILENAME,PD_GS_FILENAME_SYSTEM,PD_GS_DETAIL,PD_GS_DATE_END)");
builder.Append(" values (");
builder.Append(":AUTO_NO,:PD_PROJECT_CODE,:PD_PROJECT_TYPE,:PD_GS_TYPE,:PD_GS_STYLE,:PD_GS_ZHUTI,:PD_GS_DATE,:PD_GS_ADDR,:PD_GS_FILENAME,:PD_GS_FILENAME_SYSTEM,:PD_GS_DETAIL,:PD_GS_DATE_END)");
builder.Append(" RETURNING AUTO_NO INTO :R_Auto_No ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_CODE", OracleType.NVarChar), new OracleParameter(":PD_PROJECT_TYPE", OracleType.Number, 4), new OracleParameter(":PD_GS_TYPE", OracleType.Number, 4), new OracleParameter(":PD_GS_STYLE", OracleType.NVarChar), new OracleParameter(":PD_GS_ZHUTI", OracleType.NVarChar), new OracleParameter(":PD_GS_DATE", OracleType.DateTime), new OracleParameter(":PD_GS_ADDR", OracleType.NVarChar), new OracleParameter(":PD_GS_FILENAME", OracleType.NVarChar), new OracleParameter(":PD_GS_FILENAME_SYSTEM", OracleType.NVarChar), new OracleParameter(":PD_GS_DETAIL", OracleType.NVarChar), new OracleParameter(":PD_GS_DATE_END", OracleType.DateTime), new OracleParameter(":R_Auto_No", OracleType.Number, 20) };
cmdParms[0].Value = model.AUTO_NO;
cmdParms[1].Value = model.PD_PROJECT_CODE;
cmdParms[2].Value = model.PD_PROJECT_TYPE;
cmdParms[3].Value = model.PD_GS_TYPE;
cmdParms[4].Value = model.PD_GS_STYLE;
cmdParms[5].Value = model.PD_GS_ZHUTI;
cmdParms[6].Value = model.PD_GS_DATE;
cmdParms[7].Value = model.PD_GS_ADDR;
cmdParms[8].Value = model.PD_GS_FILENAME;
cmdParms[9].Value = model.PD_GS_FILENAME_SYSTEM;
cmdParms[10].Value = model.PD_GS_DETAIL;
cmdParms[11].Value = model.PD_GS_DATE_END;
cmdParms[12].Direction = ParameterDirection.Output;
int num = DbHelperOra.ExecuteSql(builder.ToString(), cmdParms);
model.AUTO_NO = int.Parse(cmdParms[12].Value.ToString());
return (num > 0);
}
public List<PD_PROJECT_GKGS_Model> DataTableToList(DataTable dt)
{
List<PD_PROJECT_GKGS_Model> list = new List<PD_PROJECT_GKGS_Model>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PD_PROJECT_GKGS_Model item = new PD_PROJECT_GKGS_Model();
if (dt.Rows[i]["AUTO_NO"].ToString() != "")
{
item.AUTO_NO = int.Parse(dt.Rows[i]["AUTO_NO"].ToString());
}
item.PD_PROJECT_CODE = dt.Rows[i]["PD_PROJECT_CODE"].ToString();
if (dt.Rows[i]["PD_PROJECT_TYPE"].ToString() != "")
{
item.PD_PROJECT_TYPE = new int?(int.Parse(dt.Rows[i]["PD_PROJECT_TYPE"].ToString()));
}
if (dt.Rows[i]["PD_GS_TYPE"].ToString() != "")
{
item.PD_GS_TYPE = new int?(int.Parse(dt.Rows[i]["PD_GS_TYPE"].ToString()));
}
item.PD_GS_STYLE = dt.Rows[i]["PD_GS_STYLE"].ToString();
item.PD_GS_ZHUTI = dt.Rows[i]["PD_GS_ZHUTI"].ToString();
if (dt.Rows[i]["PD_GS_DATE"].ToString() != "")
{
item.PD_GS_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_GS_DATE"].ToString()));
}
item.PD_GS_ADDR = dt.Rows[i]["PD_GS_ADDR"].ToString();
item.PD_GS_FILENAME = dt.Rows[i]["PD_GS_FILENAME"].ToString();
item.PD_GS_FILENAME_SYSTEM = dt.Rows[i]["PD_GS_FILENAME_SYSTEM"].ToString();
item.PD_GS_DETAIL = dt.Rows[i]["PD_GS_DETAIL"].ToString();
list.Add(item);
}
}
return list;
}
public bool Add(PD_PROJECT_GKGS_Model model)
{
return this.dal.Add(model);
}
public bool Update(PD_PROJECT_GKGS_Model model)
{
return this.dal.Update(model);
}
public PD_PROJECT_GKGS_Model GetModel(int AUTO_NO)
{
StringBuilder builder = new StringBuilder();
builder.Append("select AUTO_NO,PD_PROJECT_CODE,PD_PROJECT_TYPE,PD_GS_TYPE,PD_GS_STYLE,PD_GS_ZHUTI,PD_GS_DATE,PD_GS_ADDR,PD_GS_FILENAME,PD_GS_FILENAME_SYSTEM,PD_GS_DETAIL,PD_GS_DATE_END from PD_PROJECT_GKGS ");
builder.Append(" where AUTO_NO=:AUTO_NO ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Number, 4) };
cmdParms[0].Value = AUTO_NO;
PD_PROJECT_GKGS_Model model = new PD_PROJECT_GKGS_Model();
DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if (set.Tables[0].Rows[0]["AUTO_NO"].ToString() != "")
{
model.AUTO_NO = int.Parse(set.Tables[0].Rows[0]["AUTO_NO"].ToString());
}
model.PD_PROJECT_CODE = set.Tables[0].Rows[0]["PD_PROJECT_CODE"].ToString();
if (set.Tables[0].Rows[0]["PD_PROJECT_TYPE"].ToString() != "")
{
model.PD_PROJECT_TYPE = new int?(int.Parse(set.Tables[0].Rows[0]["PD_PROJECT_TYPE"].ToString()));
}
if (set.Tables[0].Rows[0]["PD_GS_TYPE"].ToString() != "")
{
model.PD_GS_TYPE = new int?(int.Parse(set.Tables[0].Rows[0]["PD_GS_TYPE"].ToString()));
}
model.PD_GS_STYLE = set.Tables[0].Rows[0]["PD_GS_STYLE"].ToString();
model.PD_GS_ZHUTI = set.Tables[0].Rows[0]["PD_GS_ZHUTI"].ToString();
if (set.Tables[0].Rows[0]["PD_GS_DATE"].ToString() != "")
{
model.PD_GS_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_GS_DATE"].ToString()));
}
model.PD_GS_ADDR = set.Tables[0].Rows[0]["PD_GS_ADDR"].ToString();
model.PD_GS_FILENAME = set.Tables[0].Rows[0]["PD_GS_FILENAME"].ToString();
model.PD_GS_FILENAME_SYSTEM = set.Tables[0].Rows[0]["PD_GS_FILENAME_SYSTEM"].ToString();
model.PD_GS_DETAIL = set.Tables[0].Rows[0]["PD_GS_DETAIL"].ToString();
if (set.Tables[0].Rows[0]["PD_GS_DATE_END"].ToString() != "")
{
model.PD_GS_DATE_END = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_GS_DATE_END"].ToString()));
}
return model;
}
public bool Update(PD_PROJECT_GKGS_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PD_PROJECT_GKGS set ");
builder.Append("PD_PROJECT_CODE=:PD_PROJECT_CODE,");
builder.Append("PD_PROJECT_TYPE=:PD_PROJECT_TYPE,");
builder.Append("PD_GS_TYPE=:PD_GS_TYPE,");
builder.Append("PD_GS_STYLE=:PD_GS_STYLE,");
builder.Append("PD_GS_ZHUTI=:PD_GS_ZHUTI,");
builder.Append("PD_GS_DATE=:PD_GS_DATE,");
builder.Append("PD_GS_ADDR=:PD_GS_ADDR,");
builder.Append("PD_GS_FILENAME=:PD_GS_FILENAME,");
builder.Append("PD_GS_FILENAME_SYSTEM=:PD_GS_FILENAME_SYSTEM,");
builder.Append("PD_GS_DETAIL=:PD_GS_DETAIL,");
builder.Append("PD_GS_DATE_END=:PD_GS_DATE_END");
builder.Append(" where AUTO_NO=:AUTO_NO ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.NVarChar), new OracleParameter(":PD_PROJECT_TYPE", OracleType.Number, 4), new OracleParameter(":PD_GS_TYPE", OracleType.Number, 4), new OracleParameter(":PD_GS_STYLE", OracleType.NVarChar), new OracleParameter(":PD_GS_ZHUTI", OracleType.NVarChar), new OracleParameter(":PD_GS_DATE", OracleType.DateTime), new OracleParameter(":PD_GS_ADDR", OracleType.NVarChar), new OracleParameter(":PD_GS_FILENAME", OracleType.NVarChar), new OracleParameter(":PD_GS_FILENAME_SYSTEM", OracleType.NVarChar), new OracleParameter(":PD_GS_DETAIL", OracleType.NVarChar), new OracleParameter(":PD_GS_DATE_END", OracleType.DateTime), new OracleParameter(":AUTO_NO", OracleType.Number, 4) };
cmdParms[0].Value = model.PD_PROJECT_CODE;
cmdParms[1].Value = model.PD_PROJECT_TYPE;
cmdParms[2].Value = model.PD_GS_TYPE;
cmdParms[3].Value = model.PD_GS_STYLE;
cmdParms[4].Value = model.PD_GS_ZHUTI;
cmdParms[5].Value = model.PD_GS_DATE;
cmdParms[6].Value = model.PD_GS_ADDR;
cmdParms[7].Value = model.PD_GS_FILENAME;
cmdParms[8].Value = model.PD_GS_FILENAME_SYSTEM;
cmdParms[9].Value = model.PD_GS_DETAIL;
cmdParms[10].Value = model.PD_GS_DATE_END;
cmdParms[11].Value = model.AUTO_NO;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
private void Save()
{
PD_PROJECT_GKGS_Bll bll = new PD_PROJECT_GKGS_Bll();
if (base.Request["doType"] == "add")
{
if (this.txtPD_PROJECT_CODE.Value != null)
{
PD_PROJECT_GKGS_Model model = new PD_PROJECT_GKGS_Model();
this.getModel(model);
if (bll.Add(model))
{
this.AddImgMethod(model);
Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + model.PD_PROJECT_CODE, this.Page);
}
else
{
Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + base.Request["UpdatePK"].ToString(), this.Page);
}
}
}
else if (base.Request["DoType"].ToString() == "update")
{
if (PublicDal.PageValidate.IsDecimal(this.lblAUTO_NO.Text))
{
PD_PROJECT_GKGS_Model model2 = bll.GetModel(int.Parse(this.lblAUTO_NO.Text));
this.getModel(model2);
if (bll.Update(model2))
{
this.AddImgMethod(model2);
Const.DoSuccessNoClose("修改成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + base.Request["UpdatePK"].ToString(), this.Page);
}
else
{
Const.DoSuccessNoClose("修改失败", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + base.Request["UpdatePK"].ToString(), this.Page);
}
}
}
else if (this.txtPD_PROJECT_CODE.Value != null)
{
PD_PROJECT_GKGS_Model model3 = new PD_PROJECT_GKGS_Model();
this.getModel(model3);
if (bll.Add(model3))
{
this.AddImgMethod(model3);
Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + model3.PD_PROJECT_CODE, this.Page);
}
Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + model3.PD_PROJECT_CODE, this.Page);
}
}
private void GetQUOTA(PD_PROJECT_GKGS_Model model)
{
DataSet set = null;
DataView defaultView = null;
string s = base.Server.UrlDecode(this.FilePostCtr1.getFileName);
if ((s != null) && (s.Trim() != ""))
{
set = new DataSet();
XmlTextReader reader = new XmlTextReader(new StringReader(s));
set.ReadXml(reader);
}
if ((set != null) && (set.Tables.Count > 0))
{
defaultView = set.Tables[0].DefaultView;
}
if (defaultView != null)
{
defaultView.RowFilter = " tableID='zxzb_bt' ";
if (defaultView.Count > 0)
{
model.PD_GS_FILENAME = defaultView[0]["FileName"].ToString();
model.PD_GS_FILENAME_SYSTEM = defaultView[0]["FileSysName"].ToString();
}
}
}
private void getModel(PD_PROJECT_GKGS_Model model)
{
model.PD_PROJECT_CODE = this.txtPD_PROJECT_CODE.Value;
model.PD_GS_ADDR = this.txtPD_GS_ADDR.Value;
if (PublicDal.PageValidate.IsDateTime(this.txtPD_GS_DATE.Value))
{
model.PD_GS_DATE = new DateTime?(DateTime.Parse(this.txtPD_GS_DATE.Value));
}
if (PublicDal.PageValidate.IsDateTime(this.txtPD_GS_DATE_END.Value))
{
model.PD_GS_DATE_END = new DateTime?(DateTime.Parse(this.txtPD_GS_DATE_END.Value));
}
model.PD_GS_DETAIL = this.txtPD_GS_DETAIL.Value.ToString();
model.PD_GS_STYLE = this.txtPD_GS_STYLE.Value.ToString();
model.PD_GS_TYPE = new int?(Convert.ToInt32(this.txtPD_GS_TYPE.SelectedValue.ToString()));
model.PD_GS_ZHUTI = this.txtPD_GS_ZHUTI.Value.ToString();
model.PD_PROJECT_CODE = this.txtPD_PROJECT_CODE.Value.ToString();
this.GetQUOTA(model);
}
private void AddImgMethod(PD_PROJECT_GKGS_Model model)
{
try
{
str = this.txt_file.Text.ToString();
if (!string.IsNullOrEmpty(str))
{
string str2 = "";
string str3 = "";
if (!string.IsNullOrEmpty(str))
{
str2 = str.Substring(str.LastIndexOf("||")).Replace("||", "");
str3 = str2;
str2 = str2.Substring(0, str2.LastIndexOf("."));
}
str = "UserImages/" + str3;
DbHelperOra.ExecuteSql(string.Concat(new object[] { "insert into t_photos (fkid, photoname, photopath, remarks, sortid) values ( 'BZssGKGS_", model.AUTO_NO, "', '", str3, "', '", str, "', '", str3, "', 1)" }));
}
}
catch (Exception)
{
}
}
