//从页面获取实体
private Entity.BASE_ROAD_TERM GetEntity()
{
Entity.BASE_ROAD_TERM model = new Entity.BASE_ROAD_TERM();
litmsg.Visible = false;
try {
model.COMPTIME = DateTime.Parse(txtCOMPTIME.Text.Trim()); //竣工时间
model.DEPTID = Convert.ToInt32(Session["deptcode"].ToString()); //部门编号
model.ID = Convert.ToInt32(hidPrimary.Value); //id
model.LINENAME = txtLINENAME.Text.Trim(); //公路名称
model.REGTIME = DateTime.Parse(txtREGTIME.Text.Trim()); //登记时间
model.REMARK = txtREMARK.Text.Trim(); //备注
model.ROADNAME = txtRoadName.Text.Trim();
model.STAKEK = Convert.ToInt32(txtSTAKEK.Text.Trim()); //k
model.STAKEM = Convert.ToInt32(txtSTAKEM.Text.Trim()); //m
model.STATUS = Convert.ToInt32(ddlStatus.SelectedValue); //status
model.SUMMARY = txtSUMMARY.Text.Trim(); //位置描述
model.TYPEID = Convert.ToInt32(ddlTermType.SelectedValue); //设备类型
model.ROADNAME = txtRoadName.Text.Trim(); //设备名称
model.PHOTO = ""; //设备照片
return(model);
}
catch (Exception ex) {
litmsg.Visible = true;
litmsg.Text = string.Format("<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;'>{0}</div>", ex.Message);
throw ex;
}
}
//初始化实体到页面
private void SetEntity(Entity.BASE_ROAD_TERM model)
{
txtCOMPTIME.Text = model.COMPTIME.ToString(); //竣工时间
hidPrimary.Value = model.ID.ToString(); //id
txtLINENAME.Text = model.LINENAME; //公路名称
txtREGTIME.Text = model.REGTIME.ToString(); //登记时间
txtREMARK.Text = model.REMARK; //备注
txtRoadName.Text = model.ROADNAME; //设备名称
txtSTAKEK.Text = model.STAKEK.ToString(); //k
txtSTAKEM.Text = model.STAKEM.ToString(); //m
ddlStatus.SelectedValue = model.STATUS.ToString(); //status
txtSUMMARY.Text = model.SUMMARY; //位置描述
ddlTermType.SelectedValue = model.TYPEID.ToString(); //设备类型
//model.DEPTID = Convert.ToInt32(Department1.SelectedValue); //部门编号
}
//submit
protected void btnSubmit_Click(object sender, EventArgs e)
{
//校验逻辑放在客户端用js实现
litmsg.Visible = false;
Entity.BASE_ROAD_TERM model = GetEntity();
//上传图片
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;'>添加成功</div>";
SetEntity(new Entity.BASE_ROAD_TERM());
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_ROAD_TERM entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_ROAD_TERM(");
strSql.Append("ID,ROADNAME,LINENAME,STAKEK,STAKEM,SUMMARY,COMPTIME,REGTIME,PHOTO,REMARK,STATUS,TYPEID,DEPTID");
strSql.Append(") values (");
strSql.Append(":ID,:ROADNAME,:LINENAME,:STAKEK,:STAKEM,:SUMMARY,:COMPTIME,:REGTIME,:PHOTO,:REMARK,:STATUS,:TYPEID,:DEPTID");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":ROADNAME", OracleType.VarChar, 50),
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(":PHOTO", OracleType.VarChar, 200),
new OracleParameter(":REMARK", OracleType.VarChar, 200),
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":TYPEID", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4)
};
parameters[0].Value = entity.ID;
parameters[1].Value = entity.ROADNAME;
parameters[2].Value = entity.LINENAME;
parameters[3].Value = entity.STAKEK;
parameters[4].Value = entity.STAKEM;
parameters[5].Value = entity.SUMMARY;
parameters[6].Value = entity.COMPTIME;
parameters[7].Value = entity.REGTIME;
parameters[8].Value = entity.PHOTO;
parameters[9].Value = entity.REMARK;
parameters[10].Value = entity.STATUS;
parameters[11].Value = entity.TYPEID;
parameters[12].Value = entity.DEPTID;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
protected void Page_Load(object sender, EventArgs e)
{
session = (Utility.UserSession)Session["user"];
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
Model = bll.GetModel(id);
//init model to page
lblRoadName.Text = Model.LINENAME;
lblDriverName.Text = Model.ROADNAME;
lblPoint.Text = string.Format("K:{0} M:{1}", Model.STAKEK.ToString(), Model.STAKEM.ToString());
lblPointSummary.Text = Model.SUMMARY;
txtBeginTime.Text = Model.REGTIME.ToString();
txtEndTime.Text = Model.COMPTIME.ToString();
litPic.Text = string.Format("<img src='http://{0}/{1}' width='500' height='250'/>",
Request.Url.Authority,
Model.PHOTO);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_ROAD_TERM entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_ROAD_TERM set ");
strSql.Append(" ID = :ID , ");
strSql.Append(" ROADNAME = :ROADNAME , ");
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(" PHOTO = :PHOTO , ");
strSql.Append(" REMARK = :REMARK , ");
strSql.Append(" STATUS = :STATUS , ");
strSql.Append(" TYPEID = :TYPEID , ");
strSql.Append(" DEPTID = :DEPTID ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":ROADNAME", OracleType.VarChar, 50),
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(":PHOTO", OracleType.VarChar, 200),
new OracleParameter(":REMARK", OracleType.VarChar, 200),
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":TYPEID", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4)
};
parameters[13].Value = entity.ID;
parameters[14].Value = entity.ROADNAME;
parameters[15].Value = entity.LINENAME;
parameters[16].Value = entity.STAKEK;
parameters[17].Value = entity.STAKEM;
parameters[18].Value = entity.SUMMARY;
parameters[19].Value = entity.COMPTIME;
parameters[20].Value = entity.REGTIME;
parameters[21].Value = entity.PHOTO;
parameters[22].Value = entity.REMARK;
parameters[23].Value = entity.STATUS;
parameters[24].Value = entity.TYPEID;
parameters[25].Value = entity.DEPTID;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_ROAD_TERM GetEntity(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, ROADNAME, LINENAME, STAKEK, STAKEM, SUMMARY, COMPTIME, REGTIME, PHOTO, REMARK, STATUS, TYPEID, DEPTID ");
strSql.Append(" from BASE_ROAD_TERM ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = ID;
Entity.BASE_ROAD_TERM entity = new Entity.BASE_ROAD_TERM();
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.ROADNAME = dt.Rows[0]["ROADNAME"].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.PHOTO = dt.Rows[0]["PHOTO"].ToString();
entity.REMARK = dt.Rows[0]["REMARK"].ToString();
if (dt.Rows[0]["STATUS"].ToString() != "")
{
entity.STATUS = decimal.Parse(dt.Rows[0]["STATUS"].ToString());
}
if (dt.Rows[0]["TYPEID"].ToString() != "")
{
entity.TYPEID = decimal.Parse(dt.Rows[0]["TYPEID"].ToString());
}
if (dt.Rows[0]["DEPTID"].ToString() != "")
{
entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">路产路产设备</param>
public void Add(Entity.BASE_ROAD_TERM model)
{
dal.Add(model);
}
