protected void btnAdd_Click(object sender, EventArgs e)
{
ptOfficeResInStorage data = this.GetData();
if (this.OperateType == "add")
{
int num = this.hrAction.Add(data);
if (num > 0)
{
this.Page.RegisterStartupScript("", "<script>alert('添加成功!');returnValue=true;window.close();</script>");
}
else
{
this.Page.RegisterStartupScript("", "<script>alert('没有相关数据可添加!');</script>");
}
}
if (this.OperateType == "upd")
{
int num = this.hrAction.Update(data);
if (num > 0)
{
this.Page.RegisterStartupScript("", "<script>alert('修改成功!');returnValue=true;window.close();</script>");
return;
}
this.Page.RegisterStartupScript("", "<script>alert('没有相关数据可更新!');</script>");
}
}
private void EditDisplay()
{
ptOfficeResInStorage model = this.hrAction.GetModel(this.InStorageID);
if (model != null)
{
this.txtBillCode.Text = model.BillCode;
this.txtInDate.Text = model.InDate.ToShortDateString();
this.txtRemark.Text = model.Remark;
this.txtTransactor.Text = model.Transactor;
this.DDLStorage.SelectedValue = model.DepotID.ToString();
}
}
public int Update(ptOfficeResInStorage model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_OfficeRes_InStorage set ");
builder.Append("DepotID=" + model.DepotID + ",");
builder.Append("BillCode='" + model.BillCode + "',");
builder.Append("InDate='" + model.InDate + "',");
builder.Append("Transactor='" + model.Transactor + "',");
builder.Append("Remark='" + model.Remark + "',");
builder.Append("UserCode='" + model.UserCode + "',");
builder.Append("RecordDate='" + model.RecordDate + "'");
builder.Append(" where InStorageID=" + model.InStorageID);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(ptOfficeResInStorage model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_OfficeRes_InStorage(");
builder.Append("DepotID,BillCode,InDate,Transactor,Remark,UserCode,RecordDate");
builder.Append(")");
builder.Append(" values (");
builder.Append(model.DepotID + ",");
builder.Append("'" + model.BillCode + "',");
builder.Append("'" + model.InDate + "',");
builder.Append("'" + model.Transactor + "',");
builder.Append("'" + model.Remark + "',");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + model.RecordDate + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public ptOfficeResInStorage GetModel(int InStorageID)
{
StringBuilder builder = new StringBuilder();
builder.Append(" select InStorageID,DepotID,BillCode,InDate,Transactor,Remark,UserCode,RecordDate ");
builder.Append(" from OA_OfficeRes_InStorage ");
builder.Append(" where InStorageID=" + InStorageID);
ptOfficeResInStorage storage = new ptOfficeResInStorage();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["InStorageID"].ToString() != "")
{
storage.InStorageID = int.Parse(set.Tables[0].Rows[0]["InStorageID"].ToString());
}
if (set.Tables[0].Rows[0]["DepotID"].ToString() != "")
{
storage.DepotID = int.Parse(set.Tables[0].Rows[0]["DepotID"].ToString());
}
storage.BillCode = set.Tables[0].Rows[0]["BillCode"].ToString();
if (set.Tables[0].Rows[0]["InDate"].ToString() != "")
{
storage.InDate = DateTime.Parse(set.Tables[0].Rows[0]["InDate"].ToString());
}
storage.Transactor = set.Tables[0].Rows[0]["Transactor"].ToString();
storage.Remark = set.Tables[0].Rows[0]["Remark"].ToString();
storage.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString();
if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "")
{
storage.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString());
}
return(storage);
}
