/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_TERM GetEntity(decimal TERMID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TERMID, DEPTID, TERMCODE, TERMNAME, SERIALCODE, FORMAT, BRAND, USE, USETIME, SAVEPOINT, REMARK, STATUS, TYPEID ");
strSql.Append(" from BASE_TERM ");
strSql.Append(" where TERMID=:TERMID ");
OracleParameter[] parameters =
{
new OracleParameter(":TERMID", OracleType.Number, 4)
};
parameters[0].Value = TERMID;
Entity.BASE_TERM entity = new Entity.BASE_TERM();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["TERMID"].ToString() != "")
{
entity.TERMID = decimal.Parse(dt.Rows[0]["TERMID"].ToString());
}
if (dt.Rows[0]["DEPTID"].ToString() != "")
{
entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString());
}
entity.TERMCODE = dt.Rows[0]["TERMCODE"].ToString();
entity.TERMNAME = dt.Rows[0]["TERMNAME"].ToString();
entity.SERIALCODE = dt.Rows[0]["SERIALCODE"].ToString();
entity.FORMAT = dt.Rows[0]["FORMAT"].ToString();
entity.BRAND = dt.Rows[0]["BRAND"].ToString();
entity.USE = dt.Rows[0]["USE"].ToString();
if (dt.Rows[0]["USETIME"].ToString() != "")
{
entity.USETIME = DateTime.Parse(dt.Rows[0]["USETIME"].ToString());
}
entity.SAVEPOINT = dt.Rows[0]["SAVEPOINT"].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());
}
return(entity);
}
else
{
return(null);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Entity.BASE_TERM model = GetEntity();
if (ViewState["id"] == null)
{
bll.Add(model);
}
else
{
bll.update(model);
}
Response.Redirect("Term.aspx", true);
}
//初始化实体到页面
private void SetEntity(Entity.BASE_TERM model)
{
DropDownList ddr = (DropDownList)this.Department1.FindControl("ddlDepartment"); //找到用户控件中的子控件
this.txtUSETIME.Text = model.BRAND; //制造厂商
ddr.SelectedValue = model.DEPTID.ToString(); //所属单位；
this.txtFORMAT.Text = model.FORMAT; //规格型号
this.txtRemark.Text = model.REMARK; //备注
this.TxtPosition.Text = model.SAVEPOINT; //存放地点
this.txtSERIALCODE.Text = model.SERIALCODE; //出厂编号
//model.STATUS = 0;//状态（0：正常；1：删除）
this.txtTERMCODE.Text = model.TERMCODE; //设备编号
this.hidPrimary.Value = model.TERMID.ToString(); //主键，编号
this.txtTERMNAME.Text = model.TERMNAME; //设备名称
this.ddlTermType.SelectedValue = model.TYPEID.ToString(); //装备类型
this.txtUse.Text = model.USE; //装备用途
this.txtUSETIME.Text = model.USETIME.ToString(); //投入使用时间
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_TERM entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_TERM(");
strSql.Append("TERMID,DEPTID,TERMCODE,TERMNAME,SERIALCODE,FORMAT,BRAND,USE,USETIME,SAVEPOINT,REMARK,STATUS,TYPEID");
strSql.Append(") values (");
strSql.Append(":TERMID,:DEPTID,:TERMCODE,:TERMNAME,:SERIALCODE,:FORMAT,:BRAND,:USE,:USETIME,:SAVEPOINT,:REMARK,:STATUS,:TYPEID");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":TERMID", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":TERMCODE", OracleType.VarChar, 50),
new OracleParameter(":TERMNAME", OracleType.VarChar, 50),
new OracleParameter(":SERIALCODE", OracleType.VarChar, 50),
new OracleParameter(":FORMAT", OracleType.VarChar, 50),
new OracleParameter(":BRAND", OracleType.VarChar, 50),
new OracleParameter(":USE", OracleType.VarChar, 50),
new OracleParameter(":USETIME", OracleType.DateTime),
new OracleParameter(":SAVEPOINT", OracleType.VarChar, 50),
new OracleParameter(":REMARK", OracleType.VarChar, 50),
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":TYPEID", OracleType.Number, 4)
};
parameters[0].Value = entity.TERMID;
parameters[1].Value = entity.DEPTID;
parameters[2].Value = entity.TERMCODE;
parameters[3].Value = entity.TERMNAME;
parameters[4].Value = entity.SERIALCODE;
parameters[5].Value = entity.FORMAT;
parameters[6].Value = entity.BRAND;
parameters[7].Value = entity.USE;
parameters[8].Value = entity.USETIME;
parameters[9].Value = entity.SAVEPOINT;
parameters[10].Value = entity.REMARK;
parameters[11].Value = entity.STATUS;
parameters[12].Value = entity.TYPEID;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
//从页面获取实体
private Entity.BASE_TERM GetEntity()
{
Entity.BASE_TERM model = new Entity.BASE_TERM();
DropDownList ddr = (DropDownList)this.Department1.FindControl("ddlDepartment"); //找到用户控件中的子控件
model.BRAND = this.txtUSETIME.Text; //制造厂商
model.DEPTID = Convert.ToDecimal(ddr.SelectedValue); //所属单位；
model.FORMAT = this.txtFORMAT.Text; //规格型号
model.REMARK = this.txtRemark.Text; //备注
model.SAVEPOINT = this.TxtPosition.Text; //存放地点
model.SERIALCODE = this.txtSERIALCODE.Text; //出厂编号
model.STATUS = 0; //状态（0：正常；1：删除）
model.TERMCODE = this.txtTERMCODE.Text; //设备编号
model.TERMID = Convert.ToDecimal(this.hidPrimary.Value); //主键，编号
model.TERMNAME = this.txtTERMNAME.Text; //设备名称
model.TYPEID = Convert.ToDecimal(this.ddlTermType.SelectedValue); //装备类型
model.USE = this.txtUse.Text; //装备用途
model.USETIME = Convert.ToDateTime(this.txtUSETIME.Text); //投入使用时间
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (null == Request.QueryString["id"] || "" == Request.QueryString["id"])
{
//添加状态页面
this.LabName.Text = "添加装备";
}
else
{
//编辑状态绑定
this.LabName.Text = "编辑装备信息";
decimal Epid = Convert.ToDecimal(Request.QueryString["id"]);
ViewState["id"] = Request.QueryString["id"];
Entity.BASE_TERM model = bll.getModel(Epid);
SetEntity(model);
}
BinfTermTypeData();
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool update(Entity.BASE_TERM model)
{
return(termDal.Update(model));
}
/// <summary>
/// 添加一条信息
/// </summary>
/// <param name="model"></param>
public void Add(Entity.BASE_TERM model)
{
termDal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_TERM entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_TERM set ");
strSql.Append(" TERMID = :TERMID , ");
strSql.Append(" DEPTID = :DEPTID , ");
strSql.Append(" TERMCODE = :TERMCODE , ");
strSql.Append(" TERMNAME = :TERMNAME , ");
strSql.Append(" SERIALCODE = :SERIALCODE , ");
strSql.Append(" FORMAT = :FORMAT , ");
strSql.Append(" BRAND = :BRAND , ");
strSql.Append(" USE = :USE , ");
strSql.Append(" USETIME = :USETIME , ");
strSql.Append(" SAVEPOINT = :SAVEPOINT , ");
strSql.Append(" REMARK = :REMARK , ");
strSql.Append(" STATUS = :STATUS , ");
strSql.Append(" TYPEID = :TYPEID ");
strSql.Append(" where TERMID=:TERMID ");
OracleParameter[] parameters =
{
new OracleParameter(":TERMID", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":TERMCODE", OracleType.VarChar, 50),
new OracleParameter(":TERMNAME", OracleType.VarChar, 50),
new OracleParameter(":SERIALCODE", OracleType.VarChar, 50),
new OracleParameter(":FORMAT", OracleType.VarChar, 50),
new OracleParameter(":BRAND", OracleType.VarChar, 50),
new OracleParameter(":USE", OracleType.VarChar, 50),
new OracleParameter(":USETIME", OracleType.DateTime),
new OracleParameter(":SAVEPOINT", OracleType.VarChar, 50),
new OracleParameter(":REMARK", OracleType.VarChar, 50),
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":TYPEID", OracleType.Number, 4)
};
parameters[13].Value = entity.TERMID;
parameters[14].Value = entity.DEPTID;
parameters[15].Value = entity.TERMCODE;
parameters[16].Value = entity.TERMNAME;
parameters[17].Value = entity.SERIALCODE;
parameters[18].Value = entity.FORMAT;
parameters[19].Value = entity.BRAND;
parameters[20].Value = entity.USE;
parameters[21].Value = entity.USETIME;
parameters[22].Value = entity.SAVEPOINT;
parameters[23].Value = entity.REMARK;
parameters[24].Value = entity.STATUS;
parameters[25].Value = entity.TYPEID;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}