protected void btnAdd_Click(object sender, EventArgs e) { ptOfficeResInStorageDetail data = this.GetData(); ptOfficeResStock stockData = this.GetStockData(); if (this.OperateType == "add") { this.amAction.AddStock(stockData); int num = this.amAction.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") { this.amAction.UpdateStock(stockData, this.RecordID); int num = this.amAction.Update(data); if (num > 0) { this.Page.RegisterStartupScript("", "<script>alert('修改成功!');returnValue=true;window.close();</script>"); return; } this.Page.RegisterStartupScript("", "<script>alert('没有相关数据可更新!');</script>"); } }
public int Update(ptOfficeResInStorageDetail model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_OfficeRes_InStorage_Detail set "); builder.Append("Amount=" + model.Amount + ","); builder.Append("HandleMan='" + model.HandleMan + "'"); builder.Append(" where RecordID=" + model.RecordID); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(ptOfficeResInStorageDetail model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_OfficeRes_InStorage_Detail("); builder.Append("InStorageID,MaterialID,InStoragePrice,Amount,HandleMan"); builder.Append(")"); builder.Append(" values ("); builder.Append(model.InStorageID + ","); builder.Append(model.MaterialID + ","); builder.Append(model.InStoragePrice + ","); builder.Append(model.Amount + ","); builder.Append("'" + model.HandleMan + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public ptOfficeResInStorageDetail GetModel(int RecordID) { StringBuilder builder = new StringBuilder(); builder.Append(" select RecordID,InStorageID,MaterialID,InStoragePrice,Amount,HandleMan "); builder.Append(" from OA_OfficeRes_InStorage_Detail "); builder.Append(" where RecordID=" + RecordID); ptOfficeResInStorageDetail detail = new ptOfficeResInStorageDetail(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["RecordID"].ToString() != "") { detail.RecordID = int.Parse(set.Tables[0].Rows[0]["RecordID"].ToString()); } if (set.Tables[0].Rows[0]["InStorageID"].ToString() != "") { detail.InStorageID = int.Parse(set.Tables[0].Rows[0]["InStorageID"].ToString()); } if (set.Tables[0].Rows[0]["MaterialID"].ToString() != "") { detail.MaterialID = int.Parse(set.Tables[0].Rows[0]["MaterialID"].ToString()); } if (set.Tables[0].Rows[0]["InStoragePrice"].ToString() != "") { detail.InStoragePrice = decimal.Parse(set.Tables[0].Rows[0]["InStoragePrice"].ToString()); } if (set.Tables[0].Rows[0]["Amount"].ToString() != "") { detail.Amount = decimal.Parse(set.Tables[0].Rows[0]["Amount"].ToString()); } detail.HandleMan = set.Tables[0].Rows[0]["HandleMan"].ToString(); return(detail); }