protected void btnAdd_Click(object sender, EventArgs e)
{
ptOfficeResDepot data = this.GetData();
if (this.OperateType == "add")
{
int num = this.mcAction.Add(data);
if (num > 0)
{
this.JS.Text = "returnValue=true;window.close();";
}
else
{
this.JS.Text = "没有相关数据可添加!";
}
}
if (this.OperateType == "upd")
{
int num = this.mcAction.Update(data);
if (num > 0)
{
this.JS.Text = "returnValue=true;window.close();";
return;
}
this.JS.Text = "没有相关数据可更新!";
}
}
public ptOfficeResDepot GetModel(int DepotID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * ");
builder.Append(" DepotID,CorpCode,DepotName,Remark,IsValid ");
builder.Append(" from OA_OfficeRes_Depot ");
builder.Append(" where DepotID=" + DepotID);
ptOfficeResDepot depot = new ptOfficeResDepot();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["DepotID"].ToString() != "")
{
depot.DepotID = int.Parse(set.Tables[0].Rows[0]["DepotID"].ToString());
}
depot.CorpCode = set.Tables[0].Rows[0]["CorpCode"].ToString();
depot.DepotName = set.Tables[0].Rows[0]["DepotName"].ToString();
depot.Remark = set.Tables[0].Rows[0]["Remark"].ToString();
depot.IsValid = set.Tables[0].Rows[0]["IsValid"].ToString();
return(depot);
}
public int Update(ptOfficeResDepot model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_OfficeRes_Depot set ");
builder.Append("CorpCode='" + model.CorpCode + "',");
builder.Append("DepotName='" + model.DepotName + "',");
builder.Append("Remark='" + model.Remark + "',");
builder.Append("IsValid='" + model.IsValid + "'");
builder.Append(" where DepotID=" + model.DepotID);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(ptOfficeResDepot model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_OfficeRes_Depot(");
builder.Append("CorpCode,DepotName,Remark,IsValid");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.CorpCode + "',");
builder.Append("'" + model.DepotName + "',");
builder.Append("'" + model.Remark + "',");
builder.Append("'" + model.IsValid + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
