//直接制定采购订单时查找采购订单详细表 public DataSet SelectPMPurchaseOrderDetail_look(PMPurchaseOrderinfo pMPurchaseOrderinfo) { SqlParameter[] parm = new SqlParameter[1]; parm[0] = new SqlParameter("@PMPO_PurchaseOrderID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPurchaseOrderinfo.PMPO_PurchaseOrderID; return(SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_S_PMPurchaseOrderDetail_look", parm)); }
//删除采购订单 public void DeletePMPurchaseOrder(PMPurchaseOrderinfo pMPurchaseOrderinfo) { SqlParameter[] parm = new SqlParameter[1]; parm[0] = new SqlParameter("@PMPO_PurchaseOrderID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPurchaseOrderinfo.PMPO_PurchaseOrderID; SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_D_PurchasingOrder", parm); }
//绑定采购订单和采购订单详细表 public void UpdatePMPurchaseOrderDetail(PMPurchaseOrderinfo pMPurchaseOrderinfo) { SqlParameter[] parm = new SqlParameter[2]; parm[0] = new SqlParameter("@PMPOD_MakeTime", SqlDbType.DateTime); parm[0].Value = pMPurchaseOrderinfo.PMPOD_MakeTime; parm[1] = new SqlParameter("@PMPO_PurchaseOrderID", SqlDbType.UniqueIdentifier); parm[1].Value = pMPurchaseOrderinfo.PMPO_PurchaseOrderID; SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMPurchaseOrderDetail", parm); }
//根据物料查找采购申请详细表 public DataSet SelectPMPurchaseApplyDetail_Material(PMPurchaseOrderinfo pMPurchaseOrderinfo) { SqlParameter[] parm = new SqlParameter[2]; parm[0] = new SqlParameter("@IMMBD_MaterialID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPurchaseOrderinfo.IMMBD_MaterialID; parm[1] = new SqlParameter("@IMUC_ID", SqlDbType.UniqueIdentifier); parm[1].Value = pMPurchaseOrderinfo.IMUC_ID; return(SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_S_PMPurchaseApplyDetail_Material", parm)); }
//向采购申请详细单插入单价 public void InsertPMPurchaseApplyDetailPrice(PMPurchaseOrderinfo pMPurchaseOrderinfo) { SqlParameter[] parm = new SqlParameter[3]; parm[0] = new SqlParameter("@IMMBD_MaterialID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPurchaseOrderinfo.IMMBD_MaterialID; parm[1] = new SqlParameter("@IMUC_ID", SqlDbType.UniqueIdentifier); parm[1].Value = pMPurchaseOrderinfo.IMUC_ID; parm[2] = new SqlParameter("@PMPAD_Price", SqlDbType.Decimal); parm[2].Value = pMPurchaseOrderinfo.PMPAD_Price; SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PMPurchaseApplyDetailPrice", parm); }
//生成采购订单 public void InsertPMPurchaseOrder(PMPurchaseOrderinfo pMPurchaseOrderinfo) { SqlParameter[] parm = new SqlParameter[2]; parm[0] = new SqlParameter("@PMPO_MakeMan", SqlDbType.VarChar, 20); parm[0].Value = pMPurchaseOrderinfo.PMPO_MakeMan; parm[1] = new SqlParameter("@PMPO_State", SqlDbType.VarChar, 20); parm[1].Value = pMPurchaseOrderinfo.PMPO_State; SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PMPurchaseOrder", parm); }
//改变采购订单状态、物料总数 public void UpdatePMPurchaseOrder_State(PMPurchaseOrderinfo pMPurchaseOrderinfo) { SqlParameter[] parm = new SqlParameter[4]; parm[0] = new SqlParameter("@PMPO_PurchaseOrderID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPurchaseOrderinfo.PMPO_PurchaseOrderID; parm[1] = new SqlParameter("@PMPO_State", SqlDbType.VarChar, 20); parm[1].Value = pMPurchaseOrderinfo.PMPO_State; parm[2] = new SqlParameter("@PMPO_TotalMoney", SqlDbType.Decimal); parm[2].Value = pMPurchaseOrderinfo.PMPO_TotalMoney; parm[3] = new SqlParameter("@PMPO_ResidueMoney", SqlDbType.Decimal); parm[3].Value = pMPurchaseOrderinfo.PMPO_ResidueMoney; SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMPurchaseOrder_State", parm); }
//直接制定采购订单时生成采购订单表 public void InsertPMPurchaseOrderMain(PMPurchaseOrderinfo pMPurchaseOrderinfo) { SqlParameter[] parm = new SqlParameter[7]; parm[0] = new SqlParameter("@PMPO_MakeMan", SqlDbType.VarChar, 20); parm[0].Value = pMPurchaseOrderinfo.PMPO_MakeMan; parm[1] = new SqlParameter("@PMPO_PayWay", SqlDbType.VarChar, 20); parm[1].Value = pMPurchaseOrderinfo.PMPO_PayWay; parm[2] = new SqlParameter("@PMPO_PaymentTime", SqlDbType.SmallInt); parm[2].Value = pMPurchaseOrderinfo.PMPO_PaymentTime; parm[3] = new SqlParameter("@PMPO_PlanArrTime", SqlDbType.Date); parm[3].Value = pMPurchaseOrderinfo.PMPO_PlanArrTime; parm[4] = new SqlParameter("@PMSI_ID", SqlDbType.UniqueIdentifier); parm[4].Value = pMPurchaseOrderinfo.PMSI_ID; parm[5] = new SqlParameter("@PMPO_State", SqlDbType.VarChar, 20); parm[5].Value = pMPurchaseOrderinfo.PMPO_State; parm[6] = new SqlParameter("@PMPO_AdvancePayNum", SqlDbType.Decimal); parm[6].Value = pMPurchaseOrderinfo.PMPO_AdvancePayNum; SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PMPurchaseOrderMain", parm); }
//修改采购订单详细表 public void UpdatePMPurchaseOrderDetail_Direct(PMPurchaseOrderinfo pMPurchaseOrderinfo) { SqlParameter[] parm = new SqlParameter[8]; parm[0] = new SqlParameter("@PMPOD_PurchaseDetailID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPurchaseOrderinfo.PMPOD_PurchaseDetailID; parm[1] = new SqlParameter("@PMPOD_Num", SqlDbType.Decimal); parm[1].Value = pMPurchaseOrderinfo.PMPOD_Num; parm[2] = new SqlParameter("@PMPOD_Price", SqlDbType.Decimal); parm[2].Value = pMPurchaseOrderinfo.PMPOD_Price; parm[3] = new SqlParameter("@PMPOD_TotalMoney", SqlDbType.Decimal); parm[3].Value = pMPurchaseOrderinfo.PMPOD_TotalMoney; parm[4] = new SqlParameter("@PMPOD_ProductRequest", SqlDbType.VarChar, 2000); parm[4].Value = pMPurchaseOrderinfo.PMPOD_ProductRequest; parm[5] = new SqlParameter("@PMPOD_Remark", SqlDbType.VarChar, 400); parm[5].Value = pMPurchaseOrderinfo.PMPOD_Remark; parm[6] = new SqlParameter("@IMMBD_MaterialID", SqlDbType.UniqueIdentifier); parm[6].Value = pMPurchaseOrderinfo.IMMBD_MaterialID; parm[7] = new SqlParameter("@IMUC_ID", SqlDbType.UniqueIdentifier); parm[7].Value = pMPurchaseOrderinfo.IMUC_ID; SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMPurchaseOrderDetail_Direct", parm); }
public DataSet SelectPMPurchaseOrderDetail(PMPurchaseOrderinfo pMPurchaseOrderinfo) { return(PMP.SelectPMPurchaseOrderDetail(pMPurchaseOrderinfo)); }
public void InsertPMPurchaseApplyDetailPrice(PMPurchaseOrderinfo pMPurchaseOrderinfo) { PMP.InsertPMPurchaseApplyDetailPrice(pMPurchaseOrderinfo); }
public void UpdatePMPurchaseApplyDetail_One(PMPurchaseOrderinfo pMPurchaseOrderinfo) { PMP.UpdatePMPurchaseApplyDetail_One(pMPurchaseOrderinfo); }
public void InsertPMPurchaseOrderDetail(PMPurchaseOrderinfo pMPurchaseOrderinfo) { PMP.InsertPMPurchaseOrderDetail(pMPurchaseOrderinfo); }
public void InsertPMPurchaseOrder(PMPurchaseOrderinfo pMPurchaseOrderinfo) { PMP.InsertPMPurchaseOrder(pMPurchaseOrderinfo); }
public void UpdatePMPAD_Purchase(PMPurchaseOrderinfo pMPurchaseOrderinfo) { PMP.UpdatePMPAD_Purchase(pMPurchaseOrderinfo); }
public void UpdatePMPurchaseOrderDetail(PMPurchaseOrderinfo pMPurchaseOrderinfo) { PMP.UpdatePMPurchaseOrderDetail(pMPurchaseOrderinfo); }
public DataSet SelectPMPurchaseApplyDetail_Apply(PMPurchaseOrderinfo pMPurchaseOrderinfo) { return(PMP.SelectPMPurchaseApplyDetail_Apply(pMPurchaseOrderinfo)); }
public void DeletePMPurchaseOrderDetail_Direct(PMPurchaseOrderinfo pMPurchaseOrderinfo) { PMP.DeletePMPurchaseOrderDetail_Direct(pMPurchaseOrderinfo); }
//绑定采购订单详细表 private void BindGridview1(PMPurchaseOrderinfo pMPurchaseOrderinfo) { Gridview1.DataSource = pl.SelectPMPurchaseOrderDetail_look(pMPurchaseOrderinfo); Gridview1.DataBind(); }
public void DeletePMPurchaseOrder(PMPurchaseOrderinfo pMPurchaseOrderinfo) { PMP.DeletePMPurchaseOrder(pMPurchaseOrderinfo); }