/// <summary>
/// 获取最大ID编号
/// </summary>
/// <returns></returns>
public string GetMaxID()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select max(OBSERVEDID) as ID");
strSql.Append(" from BASE_OBSERVED ");
Entity.BASE_OBSERVED entity = new Entity.BASE_OBSERVED();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString());
string id = string.Empty;
if (dt.Rows.Count > 0)
{
if (null == dt.Rows[0]["ID"] || "" == dt.Rows[0]["ID"].ToString())
{
id = "-1";
}
else
{
id = dt.Rows[0]["ID"].ToString();
}
}
else
{
id = "-1";
}
return(id);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.BASE_OBSERVED entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_OBSERVED(");
strSql.Append("OBSERVEDID,PATROLUSER,WEATHER,DEPTID,STATE,REMARK");
strSql.Append(") values (");
strSql.Append(":OBSERVEDID,:PATROLUSER,:WEATHER,:DEPTID,:STATE,:REMARK");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":OBSERVEDID", OracleType.Number, 4),
new OracleParameter(":PATROLUSER", OracleType.VarChar, 50),
new OracleParameter(":WEATHER", OracleType.VarChar, 50),
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":STATE", OracleType.Number, 4),
new OracleParameter(":REMARK", OracleType.VarChar, 500)
};
parameters[0].Value = entity.OBSERVEDID;
parameters[1].Value = entity.PATROLUSER;
parameters[2].Value = entity.WEATHER;
parameters[3].Value = entity.DEPTID;
parameters[4].Value = entity.STATE;
parameters[5].Value = entity.REMARK;
return(OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
private void PatrolAdd(Entity.BASE_OBSERVED model)
{
decimal Pid = Convert.ToDecimal(bll.GetMaxID()); //获取最新添加的巡逻日志编号
string sqlwhere = "1=1 and PID=" + Pid + " and to_char(BEGINTIME,'yyyy-MM-dd')=to_char(sysdate,'yyyy-MM-dd')"; //查询当前巡逻日志下是否有巡查处理情况
if (handlingbll.GetList(sqlwhere).Rows.Count > 0)
{
Entity.BASE_HANDLING handlingmodel = GetHandlingEntity(Pid, 3);
handlingbll.Add(handlingmodel);//添加巡查处理情况
}
else
{
int a = bll.Add(model);//添加电子巡逻日志
if (a > 0)
{
decimal newPid = Convert.ToDecimal(bll.GetMaxID()); //获取最新添加的巡逻日志编号
Entity.BASE_HANDLING handlingmodel = GetHandlingEntity(newPid, 3);
handlingbll.Add(handlingmodel); //添加巡查处理情况
}
else
{
//提示添加巡逻日志失败
}
}
}
//获取实体
private Entity.BASE_OBSERVED GetEntity()
{
Entity.BASE_OBSERVED model = new Entity.BASE_OBSERVED();
DropDownList ddr = (DropDownList)this.Department1.FindControl("ddlDepartment");//找到用户控件中的子控件
model.DEPTID = Convert.ToInt32(ddr.SelectedValue);
model.PATROLUSER = txtPATROLUSER.Text.Trim();
//model.BEGINTIME = DateTime.Parse(txtBEGINTIME.Text.Trim());
//model.ENDDATE = DateTime.Parse(txtENDTIME.Text.Trim());
//model.LOG = txtLog.Text.Trim();
model.WEATHER = txtWEATHER.Text.Trim();
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (null != Request.QueryString["id"] || "" != Request.QueryString["id"])
{
decimal Epid = Convert.ToDecimal(Request.QueryString["id"]);
ViewState["id"] = Request.QueryString["id"];
Entity.BASE_OBSERVED model = bll.GetModel(Epid);
this.deptname.InnerHtml = getDeptName(model.DEPTID);
this.divuser.InnerHtml = model.PATROLUSER;
this.weather.InnerHtml = model.WEATHER;
//this.starttime.InnerHtml = model.BEGINTIME.ToShortDateString();
//this.endtime.InnerHtml = model.ENDDATE.ToShortDateString();
//this.result.InnerHtml = model.LOG;
}
}
}
//将实体赋值到页面
private void SetEntity(Entity.BASE_OBSERVED model)
{
DropDownList ddr = (DropDownList)this.Department1.FindControl("ddlDepartment");//找到用户控件中的子控件
if (model.DEPTID == 0)
{
ddr.SelectedValue = "1";
}
else
{
ddr.SelectedValue = model.DEPTID.ToString();
}
txtPATROLUSER.Text = model.PATROLUSER;
//txtBEGINTIME.Text = model.BEGINTIME.ToString("yyyy-MM-dd");
//txtENDTIME.Text = model.ENDDATE.ToString("yyyy-MM-dd");
//txtLog.Text = model.LOG;
txtWEATHER.Text = model.WEATHER;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_OBSERVED GetEntity(decimal OBSERVEDID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select OBSERVEDID, PATROLUSER, WEATHER, DEPTID, STATE, REMARK ");
strSql.Append(" from BASE_OBSERVED ");
strSql.Append(" where OBSERVEDID=:OBSERVEDID ");
OracleParameter[] parameters =
{
new OracleParameter(":OBSERVEDID", OracleType.Number, 4)
};
parameters[0].Value = OBSERVEDID;
Entity.BASE_OBSERVED entity = new Entity.BASE_OBSERVED();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["OBSERVEDID"].ToString() != "")
{
entity.OBSERVEDID = decimal.Parse(dt.Rows[0]["OBSERVEDID"].ToString());
}
entity.PATROLUSER = dt.Rows[0]["PATROLUSER"].ToString();
entity.WEATHER = dt.Rows[0]["WEATHER"].ToString();
if (dt.Rows[0]["DEPTID"].ToString() != "")
{
entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString());
}
if (dt.Rows[0]["STATE"].ToString() != "")
{
entity.STATE = decimal.Parse(dt.Rows[0]["STATE"].ToString());
}
entity.REMARK = dt.Rows[0]["REMARK"].ToString();
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 按钮事件：提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
Entity.BASE_OBSERVED model = GetEntity();
if (CheckFormSubmit())
{
if (ViewState["id"] == null)
{
PatrolAdd(model);//添加人工巡逻日志
}
else
{
bll.update(model);
}
Response.Redirect("ElectronicPatrol.aspx", true);
}
else
{
return;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_OBSERVED entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_OBSERVED set ");
strSql.Append(" OBSERVEDID = :OBSERVEDID , ");
strSql.Append(" PATROLUSER = :PATROLUSER , ");
strSql.Append(" WEATHER = :WEATHER , ");
strSql.Append(" DEPTID = :DEPTID , ");
strSql.Append(" STATE = :STATE , ");
strSql.Append(" REMARK = :REMARK ");
strSql.Append(" where OBSERVEDID=:OBSERVEDID ");
OracleParameter[] parameters =
{
new OracleParameter(":OBSERVEDID", OracleType.Number, 4),
new OracleParameter(":PATROLUSER", OracleType.VarChar, 50),
new OracleParameter(":WEATHER", OracleType.VarChar, 50),
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":STATE", OracleType.Number, 4),
new OracleParameter(":REMARK", OracleType.VarChar, 500)
};
parameters[0].Value = entity.OBSERVEDID;
parameters[1].Value = entity.PATROLUSER;
parameters[2].Value = entity.WEATHER;
parameters[3].Value = entity.DEPTID;
parameters[4].Value = entity.STATE;
parameters[5].Value = entity.REMARK;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (null == Request.QueryString["id"] || "" == Request.QueryString["id"])
{
//添加状态页面
this.LabName.Text = "添加巡逻日志";
ShowTimes();
}
else
{
//编辑状态绑定
this.LabName.Text = "编辑电子巡逻日志";
decimal Epid = Convert.ToDecimal(Request.QueryString["id"]);
ViewState["id"] = Request.QueryString["id"];
Entity.BASE_OBSERVED model = bll.GetModel(Epid);
SetEntity(model);
}
}
}
/// <summary>
/// 更新一条人工巡逻日志信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool update(Entity.BASE_OBSERVED model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
public int Add(Entity.BASE_OBSERVED model)
{
return(dal.Add(model));
}
