//直接制定采购订单时查找采购订单详细表
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);
}
