protected void btnSubmit_Click(object sender, EventArgs e)
{
Entity.BASE_DOCUMENT model = new Entity.BASE_DOCUMENT();
model = GetEntity();
if (this.CheckModel(model))
{
model.ANNEX = this.UploadAnnex();
if (string.IsNullOrWhiteSpace(model.ANNEX))
{
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;'>至少添加一个附件文档!</div>";
}
if (model.ID < 0)
{
bll.Add(model);
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;'>添加成功!</div>";
}
else
{
bll.Update(model);
Response.Redirect("List.aspx", true);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
Entity.BASE_DOCUMENT model = new Entity.BASE_DOCUMENT();
model = bll.GetEntity(id);
SetEntity(model);
}
}
private void SetEntity(Entity.BASE_DOCUMENT model)
{
txtBeginTime.Text = model.BEGINTIME.ToString("yyyy-MM-dd");
txtCASEFILENUMBER.Text = model.CASEFILENUMBER;
txtCATALOGNUMBER.Text = model.CATALOGNUMBER;
txtEndTime.Text = model.ENDTIME.ToString("yyyy-MM-dd");
txtFONDSNO.Text = model.FONDSNO;
hidPrimary.Value = model.ID.ToString();
txtNUMBEROFCOPIES.Text = model.NUMBEROFCOPIES.ToString();
txtRETENTION.Text = model.RETENTION.ToString();
txtTitle.Text = model.TIELE;
ddlTypeList.SelectedValue = model.TYPECODE.ToString();
txtUnit.Text = model.UNIT;
txtYear.Text = model.YEAR.ToString();
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_DOCUMENT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_DOCUMENT(");
strSql.Append("ID,YEAR,FONDSNO,CATALOGNUMBER,CASEFILENUMBER,RETENTION,TIELE,BEGINTIME,ENDTIME,NUMBEROFCOPIES,UNIT,ANNEX,DEPTCODE,TYPECODE");
strSql.Append(") values (");
strSql.Append(":ID,:YEAR,:FONDSNO,:CATALOGNUMBER,:CASEFILENUMBER,:RETENTION,:TIELE,:BEGINTIME,:ENDTIME,:NUMBEROFCOPIES,:UNIT,:ANNEX,:DEPTCODE,:TYPECODE");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":YEAR", OracleType.Number, 4),
new OracleParameter(":FONDSNO", OracleType.VarChar, 50),
new OracleParameter(":CATALOGNUMBER", OracleType.VarChar, 50),
new OracleParameter(":CASEFILENUMBER", OracleType.VarChar, 50),
new OracleParameter(":RETENTION", OracleType.Number, 4),
new OracleParameter(":TIELE", OracleType.VarChar, 200),
new OracleParameter(":BEGINTIME", OracleType.DateTime),
new OracleParameter(":ENDTIME", OracleType.DateTime),
new OracleParameter(":NUMBEROFCOPIES", OracleType.Number, 4),
new OracleParameter(":UNIT", OracleType.VarChar, 50),
new OracleParameter(":ANNEX", OracleType.VarChar, 2000),
new OracleParameter(":DEPTCODE", OracleType.Number, 4),
new OracleParameter(":TYPECODE", OracleType.Number, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.YEAR;
parameters[2].Value = model.FONDSNO;
parameters[3].Value = model.CATALOGNUMBER;
parameters[4].Value = model.CASEFILENUMBER;
parameters[5].Value = model.RETENTION;
parameters[6].Value = model.TIELE;
parameters[7].Value = model.BEGINTIME;
parameters[8].Value = model.ENDTIME;
parameters[9].Value = model.NUMBEROFCOPIES;
parameters[10].Value = model.UNIT;
parameters[11].Value = model.ANNEX;
parameters[12].Value = model.DEPTCODE;
parameters[13].Value = model.TYPECODE;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
private Entity.BASE_DOCUMENT GetEntity()
{
Entity.BASE_DOCUMENT model = new Entity.BASE_DOCUMENT();
model.BEGINTIME = DateTime.Parse(txtBeginTime.Text.Trim());
model.CASEFILENUMBER = txtCASEFILENUMBER.Text.Trim();
model.CATALOGNUMBER = txtCATALOGNUMBER.Text.Trim();
model.DEPTCODE = userSession.DEPTID;
model.ENDTIME = DateTime.Parse(txtEndTime.Text.Trim());
model.FONDSNO = txtFONDSNO.Text;
model.ID = Convert.ToDecimal(hidPrimary.Value);
model.NUMBEROFCOPIES = Convert.ToDecimal(txtNUMBEROFCOPIES.Text.Trim());
model.RETENTION = Convert.ToDecimal(txtRETENTION.Text.Trim());
model.TIELE = txtTitle.Text.Trim();
model.TYPECODE = Convert.ToDecimal(ddlTypeList.SelectedValue);
model.UNIT = txtUnit.Text.Trim();
model.YEAR = Convert.ToDecimal(txtYear.Text.Trim());
return(model);
}
private void SetEntity(Entity.BASE_DOCUMENT model)
{
txtBeginTime.Text = model.BEGINTIME.ToString("yyyy-MM-dd");
txtCASEFILENUMBER.Text = model.CASEFILENUMBER;
txtCATALOGNUMBER.Text = model.CATALOGNUMBER;
txtEndTime.Text = model.ENDTIME.ToString("yyyy-MM-dd");
txtFONDSNO.Text = model.FONDSNO;
hidPrimary.Value = model.ID.ToString();
txtNUMBEROFCOPIES.Text = model.NUMBEROFCOPIES.ToString();
txtRETENTION.Text = model.RETENTION.ToString();
txtTitle.Text = model.TIELE;
txtUnit.Text = model.UNIT;
txtYear.Text = model.YEAR.ToString();
if (model.ANNEX.Substring(model.ANNEX.Length - 1, 1).Equals(","))
{
model.ANNEX = model.ANNEX.Substring(0, model.ANNEX.Length - 1);
}
hidAnnex.Value = model.ANNEX;
}
protected void Page_Load(object sender, EventArgs e)
{
//告诉表单如何格式化文件信息
Page.Form.Enctype = "multipart/form-data";
userSession = (Utility.UserSession)Session["user"];
if (!IsPostBack)
{
BindType();
txtBeginTime.Text = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
txtEndTime.Text = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
//获取编辑模式ID
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
Entity.BASE_DOCUMENT model = new Entity.BASE_DOCUMENT();
model = bll.GetEntity(id);
SetEntity(model);
}
}
}
public void Update(Entity.BASE_DOCUMENT model)
{
dal.Update(model);
}
public void Add(Entity.BASE_DOCUMENT model)
{
dal.Add(model);
}
private bool CheckModel(Entity.BASE_DOCUMENT model)
{
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_DOCUMENT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_DOCUMENT set ");
strSql.Append(" ID = :ID , ");
strSql.Append(" YEAR = :YEAR , ");
strSql.Append(" FONDSNO = :FONDSNO , ");
strSql.Append(" CATALOGNUMBER = :CATALOGNUMBER , ");
strSql.Append(" CASEFILENUMBER = :CASEFILENUMBER , ");
strSql.Append(" RETENTION = :RETENTION , ");
strSql.Append(" TIELE = :TIELE , ");
strSql.Append(" BEGINTIME = :BEGINTIME , ");
strSql.Append(" ENDTIME = :ENDTIME , ");
strSql.Append(" NUMBEROFCOPIES = :NUMBEROFCOPIES , ");
strSql.Append(" UNIT = :UNIT , ");
strSql.Append(" ANNEX = :ANNEX , ");
strSql.Append(" DEPTCODE = :DEPTCODE , ");
strSql.Append(" TYPECODE = :TYPECODE ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":YEAR", OracleType.Number, 4),
new OracleParameter(":FONDSNO", OracleType.VarChar, 50),
new OracleParameter(":CATALOGNUMBER", OracleType.VarChar, 50),
new OracleParameter(":CASEFILENUMBER", OracleType.VarChar, 50),
new OracleParameter(":RETENTION", OracleType.Number, 4),
new OracleParameter(":TIELE", OracleType.VarChar, 200),
new OracleParameter(":BEGINTIME", OracleType.DateTime),
new OracleParameter(":ENDTIME", OracleType.DateTime),
new OracleParameter(":NUMBEROFCOPIES", OracleType.Number, 4),
new OracleParameter(":UNIT", OracleType.VarChar, 50),
new OracleParameter(":ANNEX", OracleType.VarChar, 2000),
new OracleParameter(":DEPTCODE", OracleType.Number, 4),
new OracleParameter(":TYPECODE", OracleType.Number, 4)
};
parameters[14].Value = model.ID;
parameters[15].Value = model.YEAR;
parameters[16].Value = model.FONDSNO;
parameters[17].Value = model.CATALOGNUMBER;
parameters[18].Value = model.CASEFILENUMBER;
parameters[19].Value = model.RETENTION;
parameters[20].Value = model.TIELE;
parameters[21].Value = model.BEGINTIME;
parameters[22].Value = model.ENDTIME;
parameters[23].Value = model.NUMBEROFCOPIES;
parameters[24].Value = model.UNIT;
parameters[25].Value = model.ANNEX;
parameters[26].Value = model.DEPTCODE;
parameters[27].Value = model.TYPECODE;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_DOCUMENT GetEntity(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, YEAR, FONDSNO, CATALOGNUMBER, CASEFILENUMBER, RETENTION, TIELE, BEGINTIME, ENDTIME, NUMBEROFCOPIES, UNIT, ANNEX, DEPTCODE, TYPECODE ");
strSql.Append(" from BASE_DOCUMENT ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = ID;
Entity.BASE_DOCUMENT entity = new Entity.BASE_DOCUMENT();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["ID"].ToString() != "")
{
entity.ID = decimal.Parse(dt.Rows[0]["ID"].ToString());
}
if (dt.Rows[0]["YEAR"].ToString() != "")
{
entity.YEAR = decimal.Parse(dt.Rows[0]["YEAR"].ToString());
}
entity.FONDSNO = dt.Rows[0]["FONDSNO"].ToString();
entity.CATALOGNUMBER = dt.Rows[0]["CATALOGNUMBER"].ToString();
entity.CASEFILENUMBER = dt.Rows[0]["CASEFILENUMBER"].ToString();
if (dt.Rows[0]["RETENTION"].ToString() != "")
{
entity.RETENTION = decimal.Parse(dt.Rows[0]["RETENTION"].ToString());
}
entity.TIELE = dt.Rows[0]["TIELE"].ToString();
if (dt.Rows[0]["BEGINTIME"].ToString() != "")
{
entity.BEGINTIME = DateTime.Parse(dt.Rows[0]["BEGINTIME"].ToString());
}
if (dt.Rows[0]["ENDTIME"].ToString() != "")
{
entity.ENDTIME = DateTime.Parse(dt.Rows[0]["ENDTIME"].ToString());
}
if (dt.Rows[0]["NUMBEROFCOPIES"].ToString() != "")
{
entity.NUMBEROFCOPIES = decimal.Parse(dt.Rows[0]["NUMBEROFCOPIES"].ToString());
}
entity.UNIT = dt.Rows[0]["UNIT"].ToString();
entity.ANNEX = dt.Rows[0]["ANNEX"].ToString();
if (dt.Rows[0]["DEPTCODE"].ToString() != "")
{
entity.DEPTCODE = decimal.Parse(dt.Rows[0]["DEPTCODE"].ToString());
}
if (dt.Rows[0]["TYPECODE"].ToString() != "")
{
entity.TYPECODE = decimal.Parse(dt.Rows[0]["TYPECODE"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
