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())); }