public ptOfficeResStockCheck GetModel(int CheckRecordID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * ");
builder.Append(" CheckRecordID,DepotID,RecordDate,UserCode,IsConfirm ");
builder.Append(" from OA_OfficeRes_StockCheck ");
builder.Append(" where CheckRecordID=" + CheckRecordID);
ptOfficeResStockCheck check = new ptOfficeResStockCheck();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["CheckRecordID"].ToString() != "")
{
check.CheckRecordID = int.Parse(set.Tables[0].Rows[0]["CheckRecordID"].ToString());
}
if (set.Tables[0].Rows[0]["DepotID"].ToString() != "")
{
check.DepotID = int.Parse(set.Tables[0].Rows[0]["DepotID"].ToString());
}
if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "")
{
check.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString());
}
check.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString();
check.IsConfirm = set.Tables[0].Rows[0]["IsConfirm"].ToString();
return(check);
}
protected void btnStartWF_Click(object sender, EventArgs e)
{
ptOfficeResStockCheck data = this.GetData();
if (this.amAction.Add(data) > 0)
{
this.Bind();
}
}
public int Update(ptOfficeResStockCheck model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_OfficeRes_StockCheck set ");
builder.Append("DepotID=" + model.DepotID + ",");
builder.Append("RecordDate='" + model.RecordDate + "',");
builder.Append("UserCode='" + model.UserCode + "',");
builder.Append("IsConfirm='" + model.IsConfirm + "'");
builder.Append(" where CheckRecordID=" + model.CheckRecordID);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(ptOfficeResStockCheck model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_OfficeRes_StockCheck(");
builder.Append("DepotID,RecordDate,UserCode,IsConfirm");
builder.Append(")");
builder.Append(" values (");
builder.Append(model.DepotID + ",");
builder.Append("'" + model.RecordDate + "',");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + model.IsConfirm + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}