protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
model = bll.GetModel(id);
InitModelToPage(model);
}
}
private bool CheckModel(Entity.BASE_AREA model)
{
if (model == null)
{
return(false);
}
return(true);
}
private void SetModel(Entity.BASE_AREA model)
{
ddlType.SelectedValue = model.TYPEID.ToString();
txtLINENAME.Text = model.LINENAME;
txtAREANAME.Text = model.AREANAME;
txtSTAKEK.Text = model.STAKEK.ToString();
txtSTAKEM.Text = model.STAKEM.ToString();
txtSUMMARY.Text = model.SUMMARY;
txtREGTIME.Text = model.REGTIME.ToString("yyyy-MM-dd");
txtCOMPTIME.Text = model.COMPTIME.ToString("yyyy-MM-dd");
txtOWNER.Text = model.OWNER;
txtDETAILED.Text = model.DETAILED;
txtSTATUS.Text = model.STATUS;
txtREMARK.Text = model.REMARK;
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_AREA entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_AREA(");
strSql.Append("ID,AREANAME,TYPEID,LINENAME,STAKEK,STAKEM,SUMMARY,COMPTIME,REGTIME,OWNER,DETAILED,STATUS,REMARK,PHOTO,DEPTID");
strSql.Append(") values (");
strSql.Append(":ID,:AREANAME,:TYPEID,:LINENAME,:STAKEK,:STAKEM,:SUMMARY,:COMPTIME,:REGTIME,:OWNER,:DETAILED,:STATUS,:REMARK,:PHOTO,:DEPTID");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":AREANAME", OracleType.VarChar, 50),
new OracleParameter(":TYPEID", OracleType.Number, 4),
new OracleParameter(":LINENAME", OracleType.VarChar, 50),
new OracleParameter(":STAKEK", OracleType.Number, 4),
new OracleParameter(":STAKEM", OracleType.Number, 4),
new OracleParameter(":SUMMARY", OracleType.VarChar, 50),
new OracleParameter(":COMPTIME", OracleType.DateTime),
new OracleParameter(":REGTIME", OracleType.DateTime),
new OracleParameter(":OWNER", OracleType.VarChar, 50),
new OracleParameter(":DETAILED", OracleType.VarChar, 200),
new OracleParameter(":STATUS", OracleType.VarChar, 200),
new OracleParameter(":REMARK", OracleType.VarChar, 200),
new OracleParameter(":PHOTO", OracleType.VarChar, 200),
new OracleParameter(":DEPTID", OracleType.Number, 4)
};
parameters[0].Value = entity.ID;
parameters[1].Value = entity.AREANAME;
parameters[2].Value = entity.TYPEID;
parameters[3].Value = entity.LINENAME;
parameters[4].Value = entity.STAKEK;
parameters[5].Value = entity.STAKEM;
parameters[6].Value = entity.SUMMARY;
parameters[7].Value = entity.COMPTIME;
parameters[8].Value = entity.REGTIME;
parameters[9].Value = entity.OWNER;
parameters[10].Value = entity.DETAILED;
parameters[11].Value = entity.STATUS;
parameters[12].Value = entity.REMARK;
parameters[13].Value = entity.PHOTO;
parameters[14].Value = entity.DEPTID;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
private Entity.BASE_AREA GetModel()
{
Entity.BASE_AREA m = new Entity.BASE_AREA();
m.DEPTID = Convert.ToInt32(Session["deptcode"].ToString());
m.TYPEID = Convert.ToInt32(ddlType.SelectedValue);
m.LINENAME = txtLINENAME.Text;
m.AREANAME = txtAREANAME.Text;
m.STAKEK = Convert.ToInt32(txtSTAKEK.Text);
m.STAKEM = Convert.ToInt32(txtSTAKEM.Text);
m.SUMMARY = txtSUMMARY.Text;
m.REGTIME = DateTime.Parse(txtREGTIME.Text);
m.COMPTIME = DateTime.Parse(txtCOMPTIME.Text);
m.OWNER = txtOWNER.Text;
m.DETAILED = txtDETAILED.Text;
m.STATUS = txtSTATUS.Text;
m.REMARK = txtREMARK.Text;
return(m);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Entity.BASE_AREA model = new Entity.BASE_AREA();
model = GetModel();
if (CheckModel(model))
{
model.PHOTO = UpLoadPic();
bll.Add(model);
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;float:left;'>添加成功!</div>";
SetModel(new Entity.BASE_AREA());
}
}
private void InitModelToPage(Entity.BASE_AREA model)
{
if (model == null)
{
return;
}
txtBeginTime.Text = model.REGTIME.ToString("yyyy-MM-dd");
txtDETAILED.Text = model.DETAILED;
txtEndTime.Text = model.COMPTIME.ToString("yyyy-mm-dd");
txtREMARK.Text = model.REMARK;
txtSTATUS.Text = model.STATUS;
lblAreaName.Text = model.AREANAME;
lblLineName.Text = model.LINENAME;
lblPoint.Text = string.Format("K:{0} M:{0}", model.STAKEK.ToString(), model.STAKEM.ToString());
lblPointSummary.Text = model.SUMMARY;
litPic.Text = string.Format("<img src='http://{0}/{1}' width='500' height='250'/>",
Request.Url.Authority,
model.PHOTO);
hidPrimary.Value = model.ID.ToString();
}
public void Add(Entity.BASE_AREA model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_AREA entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_AREA set ");
strSql.Append(" ID = :ID , ");
strSql.Append(" AREANAME = :AREANAME , ");
strSql.Append(" TYPEID = :TYPEID , ");
strSql.Append(" LINENAME = :LINENAME , ");
strSql.Append(" STAKEK = :STAKEK , ");
strSql.Append(" STAKEM = :STAKEM , ");
strSql.Append(" SUMMARY = :SUMMARY , ");
strSql.Append(" COMPTIME = :COMPTIME , ");
strSql.Append(" REGTIME = :REGTIME , ");
strSql.Append(" OWNER = :OWNER , ");
strSql.Append(" DETAILED = :DETAILED , ");
strSql.Append(" STATUS = :STATUS , ");
strSql.Append(" REMARK = :REMARK , ");
strSql.Append(" PHOTO = :PHOTO , ");
strSql.Append(" DEPTID = :DEPTID ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":AREANAME", OracleType.VarChar, 50),
new OracleParameter(":TYPEID", OracleType.Number, 4),
new OracleParameter(":LINENAME", OracleType.VarChar, 50),
new OracleParameter(":STAKEK", OracleType.Number, 4),
new OracleParameter(":STAKEM", OracleType.Number, 4),
new OracleParameter(":SUMMARY", OracleType.VarChar, 50),
new OracleParameter(":COMPTIME", OracleType.DateTime),
new OracleParameter(":REGTIME", OracleType.DateTime),
new OracleParameter(":OWNER", OracleType.VarChar, 50),
new OracleParameter(":DETAILED", OracleType.VarChar, 200),
new OracleParameter(":STATUS", OracleType.VarChar, 200),
new OracleParameter(":REMARK", OracleType.VarChar, 200),
new OracleParameter(":PHOTO", OracleType.VarChar, 200),
new OracleParameter(":DEPTID", OracleType.Number, 4)
};
parameters[0].Value = entity.ID;
parameters[1].Value = entity.AREANAME;
parameters[2].Value = entity.TYPEID;
parameters[3].Value = entity.LINENAME;
parameters[4].Value = entity.STAKEK;
parameters[5].Value = entity.STAKEM;
parameters[6].Value = entity.SUMMARY;
parameters[7].Value = entity.COMPTIME;
parameters[8].Value = entity.REGTIME;
parameters[9].Value = entity.OWNER;
parameters[10].Value = entity.DETAILED;
parameters[11].Value = entity.STATUS;
parameters[12].Value = entity.REMARK;
parameters[13].Value = entity.PHOTO;
parameters[14].Value = entity.DEPTID;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_AREA GetEntity(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, AREANAME, TYPEID, LINENAME, STAKEK, STAKEM, SUMMARY, COMPTIME, REGTIME, OWNER, DETAILED, STATUS, REMARK, PHOTO, DEPTID ");
strSql.Append(" from BASE_AREA ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = ID;
Entity.BASE_AREA entity = new Entity.BASE_AREA();
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());
}
entity.AREANAME = dt.Rows[0]["AREANAME"].ToString();
if (dt.Rows[0]["TYPEID"].ToString() != "")
{
entity.TYPEID = decimal.Parse(dt.Rows[0]["TYPEID"].ToString());
}
entity.LINENAME = dt.Rows[0]["LINENAME"].ToString();
if (dt.Rows[0]["STAKEK"].ToString() != "")
{
entity.STAKEK = decimal.Parse(dt.Rows[0]["STAKEK"].ToString());
}
if (dt.Rows[0]["STAKEM"].ToString() != "")
{
entity.STAKEM = decimal.Parse(dt.Rows[0]["STAKEM"].ToString());
}
entity.SUMMARY = dt.Rows[0]["SUMMARY"].ToString();
if (dt.Rows[0]["COMPTIME"].ToString() != "")
{
entity.COMPTIME = DateTime.Parse(dt.Rows[0]["COMPTIME"].ToString());
}
if (dt.Rows[0]["REGTIME"].ToString() != "")
{
entity.REGTIME = DateTime.Parse(dt.Rows[0]["REGTIME"].ToString());
}
entity.OWNER = dt.Rows[0]["OWNER"].ToString();
entity.DETAILED = dt.Rows[0]["DETAILED"].ToString();
entity.STATUS = dt.Rows[0]["STATUS"].ToString();
entity.REMARK = dt.Rows[0]["REMARK"].ToString();
entity.PHOTO = dt.Rows[0]["PHOTO"].ToString();
if (dt.Rows[0]["DEPTID"].ToString() != "")
{
entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
