////修改采购开票详细表的剩余配额 //public void UpdatePMBD_Remaining(string condition) //{ // SqlParameter parm = new SqlParameter("@Condition", condition); // SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction, // CommandType.StoredProcedure, "Proc_U_PMBD_Remaining", parm); //} //查找没有开票的采购订单 public DataSet SelectPMPurchaseOrder_Pay(PMPaymentBillinfo pMPaymentBillinfo) { SqlParameter[] parm = new SqlParameter[1]; parm[0] = new SqlParameter("@PMSI_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPaymentBillinfo.PMSI_ID; return(SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_S_PMPurchaseOrder_Pay", parm)); }
//计算对应供应商的欠款总额和应付款 public void UpdatePMPaymentBill(PMPaymentBillinfo pMPaymentBillinfo) { SqlParameter[] parm = new SqlParameter[1]; parm[0] = new SqlParameter("@PMSI_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPaymentBillinfo.PMSI_ID; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMPaymentBill", parm); }
//修改采购订单的开票状况 public void UpdatePMPO_AlreadyBill(PMPaymentBillinfo pMPaymentBillinfo) { SqlParameter[] parm = new SqlParameter[2]; parm[0] = new SqlParameter("@PMPO_PurchaseOrderNum", SqlDbType.VarChar, 100); parm[0].Value = pMPaymentBillinfo.PMPO_PurchaseOrderNum; parm[1] = new SqlParameter("@PMPO_AlreadyBill", SqlDbType.Char, 2); parm[1].Value = pMPaymentBillinfo.PMPO_AlreadyBill; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMPO_AlreadyBill", parm); }
//修改采购付款开票表的欠款和应付款 public void UpdatePMPB_TDBill(PMPaymentBillinfo pMPaymentBillinfo) { SqlParameter[] parm = new SqlParameter[3]; parm[0] = new SqlParameter("@PMPB_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPaymentBillinfo.PMPB_ID; parm[1] = new SqlParameter("@PMPB_TotalDebt", SqlDbType.Decimal); parm[1].Value = pMPaymentBillinfo.PMPB_TotalDebt; parm[2] = new SqlParameter("@PMPB_Due", SqlDbType.Decimal); parm[2].Value = pMPaymentBillinfo.PMPB_Due; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMPB_TDBill", parm); }
//修改采购订单的结款状况 public void UpdatePMPO_AlreadyPay(PMPaymentBillinfo pMPaymentBillinfo) { SqlParameter[] parm = new SqlParameter[3]; parm[0] = new SqlParameter("@PMPO_PurchaseOrderID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPaymentBillinfo.PMPO_PurchaseOrderID; parm[1] = new SqlParameter("@PMPO_AlreadyPay", SqlDbType.Char, 2); parm[1].Value = pMPaymentBillinfo.PMPO_AlreadyPay; parm[2] = new SqlParameter("@PMPO_ResidueMoney", SqlDbType.Decimal); parm[2].Value = pMPaymentBillinfo.PMPO_ResidueMoney; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMPO_AlreadyPay", parm); }
//修改采购付款详细表 public void UpdatePMPaymentIDetail(PMPaymentBillinfo pMPaymentBillinfo) { SqlParameter[] parm = new SqlParameter[4]; parm[0] = new SqlParameter("@PMPD_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPaymentBillinfo.PMPD_ID; parm[1] = new SqlParameter("@PMPD_PayTime", SqlDbType.Date); parm[1].Value = pMPaymentBillinfo.PMPD_PayTime; parm[2] = new SqlParameter("@PMPD_PayWay", SqlDbType.VarChar, 20); parm[2].Value = pMPaymentBillinfo.PMPD_PayWay; parm[3] = new SqlParameter("@PMPD_Pay", SqlDbType.Decimal); parm[3].Value = pMPaymentBillinfo.PMPD_Pay; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMPaymentIDetail", parm); }
//修改采购开票详细表 public void UpdatePMBillDetial(PMPaymentBillinfo pMPaymentBillinfo) { SqlParameter[] parm = new SqlParameter[7]; parm[0] = new SqlParameter("@PMBD_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMPaymentBillinfo.PMBD_ID; parm[1] = new SqlParameter("@PMBD_TotalBill", SqlDbType.Decimal); parm[1].Value = pMPaymentBillinfo.PMBD_TotalBill; parm[2] = new SqlParameter("@PMBD_BillNum", SqlDbType.VarChar, 200); parm[2].Value = pMPaymentBillinfo.PMBD_BillNum; parm[3] = new SqlParameter("@PMBD_BillDate", SqlDbType.Date); parm[3].Value = pMPaymentBillinfo.PMBD_BillDate; parm[4] = new SqlParameter("@PMBD_PayOff", SqlDbType.Char, 2); parm[4].Value = pMPaymentBillinfo.PMBD_PayOff; parm[5] = new SqlParameter("@PMBD_OrderNum", SqlDbType.VarChar, 1000); parm[5].Value = pMPaymentBillinfo.PMBD_OrderNum; parm[6] = new SqlParameter("@PMBD_Remark", SqlDbType.VarChar, 400); parm[6].Value = pMPaymentBillinfo.PMBD_Remark; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMBillDetial", parm); }
public void UpdatePMPaymentIDetail(PMPaymentBillinfo pMPaymentBillinfo) { PMP.UpdatePMPaymentIDetail(pMPaymentBillinfo); }
public void DeletePMBillDetial(PMPaymentBillinfo pMPaymentBillinfo) { PMP.DeletePMBillDetial(pMPaymentBillinfo); }
public void UpdatePMBillDetial(PMPaymentBillinfo pMPaymentBillinfo) { PMP.UpdatePMBillDetial(pMPaymentBillinfo); }
public DataSet SelectPMPaymentIDetail(PMPaymentBillinfo pMPaymentBillinfo) { return(PMP.SelectPMPaymentIDetail(pMPaymentBillinfo)); }
public void UpdatePMPaymentBill_Payment(PMPaymentBillinfo pMPaymentBillinfo) { PMP.UpdatePMPaymentBill_Payment(pMPaymentBillinfo); }
public DataSet SelectPMPurchaseOrder_Pay(PMPaymentBillinfo pMPaymentBillinfo) { return(PMP.SelectPMPurchaseOrder_Pay(pMPaymentBillinfo)); }
//相应供应商的采购付款详细表 private void BindGridview2(PMPaymentBillinfo PMPaymentBillinfo) { Gridview2.DataSource = ppb.SelectPMPaymentIDetail(PMPaymentBillinfo); Gridview2.DataBind(); }
public void DeletePMPaymentIDetail(PMPaymentBillinfo pMPaymentBillinfo) { PMP.DeletePMPaymentIDetail(pMPaymentBillinfo); }
public void UpdatePMPO_AlreadyPay(PMPaymentBillinfo pMPaymentBillinfo) { PMP.UpdatePMPO_AlreadyPay(pMPaymentBillinfo); }
public void InsertPMPaymentIDetail(PMPaymentBillinfo pMPaymentBillinfo) { PMP.InsertPMPaymentIDetail(pMPaymentBillinfo); }
public void UpdatePMPB_TDBill(PMPaymentBillinfo pMPaymentBillinfo) { PMP.UpdatePMPB_TDBill(pMPaymentBillinfo); }
public void InsertPMBillDetial(PMPaymentBillinfo pMPaymentBillinfo) { PMP.InsertPMBillDetial(pMPaymentBillinfo); }