public bool Update(com.jwsoft.pm.entpm.model.InventoryMain model) { StringBuilder builder = new StringBuilder(); builder.Append("update pm_Repe_InventoryMain set "); builder.Append("DepositoryID=" + model.DepositoryID + ","); builder.Append("InventoryDate='" + model.InventoryDate + "',"); builder.Append("InventoryPerson='" + model.InventoryPerson + "',"); builder.Append("Remark='" + model.Remark + "',"); builder.Append("TransactState='" + model.TransactState + "',"); builder.Append("UserCode='" + model.UserCode + "',"); builder.Append("RecordDate='" + model.RecordDate + "'"); builder.Append(" where InventoryID=" + model.InventoryID + " "); return(publicDbOpClass.NonQuerySqlString(builder.ToString())); }
public com.jwsoft.pm.entpm.model.InventoryMain GetModel(int InventoryID) { StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" InventoryID,DepositoryID,InventoryDate,InventoryPerson,Remark,TransactState,AuditState,UserCode,RecordDate,RecordID "); builder.Append(" from pm_Repe_InventoryMain "); builder.Append(" where InventoryID=" + InventoryID + " "); com.jwsoft.pm.entpm.model.InventoryMain main = new com.jwsoft.pm.entpm.model.InventoryMain(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["InventoryID"].ToString() != "") { main.InventoryID = int.Parse(set.Tables[0].Rows[0]["InventoryID"].ToString()); } if (set.Tables[0].Rows[0]["DepositoryID"].ToString() != "") { main.DepositoryID = int.Parse(set.Tables[0].Rows[0]["DepositoryID"].ToString()); } if (set.Tables[0].Rows[0]["InventoryDate"].ToString() != "") { main.InventoryDate = DateTime.Parse(set.Tables[0].Rows[0]["InventoryDate"].ToString()); } main.InventoryPerson = set.Tables[0].Rows[0]["InventoryPerson"].ToString(); main.Remark = set.Tables[0].Rows[0]["Remark"].ToString(); main.TransactState = set.Tables[0].Rows[0]["TransactState"].ToString(); if (set.Tables[0].Rows[0]["AuditState"].ToString() != "") { main.AuditState = int.Parse(set.Tables[0].Rows[0]["AuditState"].ToString()); } main.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString(); if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "") { main.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString()); } if (set.Tables[0].Rows[0]["RecordID"].ToString() != "") { main.RecordID = new Guid(set.Tables[0].Rows[0]["RecordID"].ToString()); } return(main); }
public bool Add(com.jwsoft.pm.entpm.model.InventoryMain model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into pm_Repe_InventoryMain("); builder.Append("DepositoryID,InventoryDate,InventoryPerson,Remark,TransactState,UserCode,RecordDate"); builder.Append(")"); builder.Append(" values ("); builder.Append(model.DepositoryID + ","); builder.Append("'" + model.InventoryDate + "',"); builder.Append("'" + model.InventoryPerson + "',"); builder.Append("'" + model.Remark + "',"); builder.Append("'" + model.TransactState + "',"); builder.Append("'" + model.UserCode + "',"); builder.Append("'" + model.RecordDate + "'"); builder.Append(")"); return(publicDbOpClass.NonQuerySqlString(builder.ToString())); }
public bool InitDetailByDepoID(int inventoryID) { com.jwsoft.pm.entpm.action.InventoryMain main = new com.jwsoft.pm.entpm.action.InventoryMain(); StringBuilder builder = new StringBuilder(); StringBuilder builder2 = new StringBuilder(); com.jwsoft.pm.entpm.model.InventoryMain model = new com.jwsoft.pm.entpm.model.InventoryMain(); model = main.GetModel(inventoryID); builder.Append(" select * from pm_Repe_RealTime where DepositoryID=" + model.DepositoryID + " "); DataTable table = publicDbOpClass.DataTableQuary(builder.ToString()); if (table.Rows.Count <= 0) { return(false); } foreach (DataRow row in table.Rows) { builder2.Append(string.Concat(new object[] { " if not exists(select top 1 InventoryDetailID from pm_Repe_InventoryDetail where InventoryID= ", model.InventoryID, " and MaterialId = ", row["MaterialId"].ToString(), " ) " })); builder2.Append(" begin "); builder2.Append(" insert into pm_Repe_InventoryDetail("); builder2.Append(" InventoryID,MaterialId,BookScalar,FactScalar"); builder2.Append(" )"); builder2.Append(" values ("); builder2.Append(" " + model.InventoryID + ","); builder2.Append(" " + row["MaterialId"].ToString() + ","); builder2.Append(" " + row["Amount"].ToString() + ","); builder2.Append(" " + row["Amount"].ToString() + " "); builder2.Append(" )"); builder2.Append(" end "); builder2.Append(" else "); builder2.Append(" begin "); builder2.Append(" update pm_Repe_InventoryDetail set "); builder2.Append(" BookScalar=" + row["Amount"].ToString() + ","); builder2.Append(" FactScalar=" + row["Amount"].ToString()); builder2.Append(" where "); builder2.Append(" InventoryID=" + model.InventoryID); builder2.Append(" and MaterialId = " + row["MaterialId"].ToString() + " "); builder2.Append(" end "); } return(publicDbOpClass.NonQuerySqlString(builder2.ToString())); }
public bool UpdateIsConfirm(int InventoryID) { com.jwsoft.pm.entpm.model.InventoryMain model = this.GetModel(InventoryID); StringBuilder builder = new StringBuilder(); StringBuilder builder2 = new StringBuilder(); builder.Append(" select * from pm_Repe_InventoryDetail where InventoryID=" + model.InventoryID + " "); DataTable table = publicDbOpClass.DataTableQuary(builder.ToString()); if (table.Rows.Count > 0) { foreach (DataRow row in table.Rows) { builder2.Append(string.Concat(new object[] { " if exists(select top 1 RecordID from pm_Repe_RealTime where DepositoryID= ", model.DepositoryID, " and MaterialId = ", row["MaterialId"].ToString(), " ) " })); builder2.Append(" begin "); builder2.Append(" update pm_Repe_RealTime set "); builder2.Append(" Amount=" + row["FactScalar"].ToString()); builder2.Append(" where "); builder2.Append(" DepositoryID=" + model.DepositoryID); builder2.Append(" and MaterialId = " + row["MaterialId"].ToString() + " "); builder2.Append(" end "); builder2.Append(" else "); builder2.Append(" begin "); builder2.Append(" insert into pm_Repe_RealTime("); builder2.Append(" DepositoryID,MaterialId,Amount"); builder2.Append(" )"); builder2.Append(" values ("); builder2.Append(" " + model.DepositoryID + ","); builder2.Append(" " + row["MaterialId"].ToString() + ","); builder2.Append(" " + row["FactScalar"].ToString() + " "); builder2.Append(" )"); builder2.Append(" end "); } if (publicDbOpClass.NonQuerySqlString(builder2.ToString())) { model.TransactState = "1"; return(this.Update(model)); } } return(false); }