////修改采购开票详细表的剩余配额
//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);
}
