//查找设备生产厂家
public DataSet SelectPMESupply(PMEquipmentinfo pMEquipmentinfo)
{
SqlParameter[] parm = new SqlParameter[1];
parm[0] = new SqlParameter("@PMPO_PurchaseOrderID", SqlDbType.UniqueIdentifier);
parm[0].Value = pMEquipmentinfo.PMPO_PurchaseOrderID;
return(SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_S_PMESupply", parm));
}
//查找设备采购申请审核表
public DataSet SelectPMEquipmentApplyCountersign(PMEquipmentinfo pMEquipmentinfo)
{
SqlParameter[] parm = new SqlParameter[2];
parm[0] = new SqlParameter("@PMEA_ID ", SqlDbType.UniqueIdentifier);
parm[0].Value = pMEquipmentinfo.PMEA_ID;
parm[1] = new SqlParameter("@PMEAC_State", SqlDbType.VarChar, 20);
parm[1].Value = pMEquipmentinfo.PMEAC_State;
return(SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_S_PMEquipmentApplyCountersign", parm));
}
//填写设备单价
public void UpdatePMEquipmentPrice(PMEquipmentinfo pMEquipmentinfo)
{
SqlParameter[] parm = new SqlParameter[2];
parm[0] = new SqlParameter("@PMEA_EquipmentPrice", SqlDbType.Decimal);
parm[0].Value = pMEquipmentinfo.PMEA_EquipmentPrice;
parm[1] = new SqlParameter("@PMEA_ID", SqlDbType.UniqueIdentifier);
parm[1].Value = pMEquipmentinfo.PMEA_ID;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_PMEquipmentPrice", parm);
}
//新增设备采购申请审核部门
public void InsertPMEquipmentApplyCountersign(PMEquipmentinfo pMEquipmentinfo)
{
SqlParameter[] parm = new SqlParameter[3];
parm[0] = new SqlParameter("@PMEA_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = pMEquipmentinfo.PMEA_ID;
parm[1] = new SqlParameter("@PMEAC_SignPartment", SqlDbType.VarChar, 200);
parm[1].Value = pMEquipmentinfo.PMEAC_SignPartment;
parm[2] = new SqlParameter("@PMEAC_State", SqlDbType.VarChar, 20);
parm[2].Value = pMEquipmentinfo.PMEAC_State;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_I_PMEquipmentApplyCountersign", parm);
}
//修改设备采购申请审核表
public void UpdatePMEquipmentApplyCountersign(PMEquipmentinfo pMEquipmentinfo)
{
SqlParameter[] parm = new SqlParameter[4];
parm[0] = new SqlParameter("@PMEAC_SignResult", SqlDbType.VarChar, 20);
parm[0].Value = pMEquipmentinfo.PMEAC_SignResult;
parm[1] = new SqlParameter("@PMEAC_SignOpinion", SqlDbType.VarChar, 400);
parm[1].Value = pMEquipmentinfo.PMEAC_SignOpinion;
parm[2] = new SqlParameter("@PMEAC_SignMan", SqlDbType.VarChar, 20);
parm[2].Value = pMEquipmentinfo.PMEAC_SignMan;
parm[3] = new SqlParameter("@PMEAC_ID", SqlDbType.UniqueIdentifier);
parm[3].Value = pMEquipmentinfo.PMEAC_ID;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_PMEquipmentApplyCountersign", parm);
}
//申请部门部长审核
public void UpdatePMEA_ApplyDepartCheck(PMEquipmentinfo pMEquipmentinfo)
{
SqlParameter[] parm = new SqlParameter[5];
parm[0] = new SqlParameter("@PMEA_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = pMEquipmentinfo.PMEA_ID;
parm[1] = new SqlParameter("@PMEA_ApplyDepartCheckResult", SqlDbType.VarChar, 20);
parm[1].Value = pMEquipmentinfo.PMEA_ApplyDepartCheckResult;
parm[2] = new SqlParameter("@PMEA_ApplyDepartCheckOpinion", SqlDbType.VarChar, 400);
parm[2].Value = pMEquipmentinfo.PMEA_ApplyDepartCheckOpinion;
parm[3] = new SqlParameter("@PMEA_ApplyState", SqlDbType.VarChar, 20);
parm[3].Value = pMEquipmentinfo.PMEA_ApplyState;
parm[4] = new SqlParameter("@PMEA_ApplyDepartCheckMan", SqlDbType.VarChar, 20);
parm[4].Value = pMEquipmentinfo.PMEA_ApplyDepartCheckMan;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_PMEA_ApplyDepartCheck", parm);
}
//新增采购订单详细表
public void InsertPMPurchaseOrderDetail_Equipment(PMEquipmentinfo pMEquipmentinfo)
{
SqlParameter[] parm = new SqlParameter[6];
parm[0] = new SqlParameter("@PMPO_PurchaseOrderID", SqlDbType.UniqueIdentifier);
parm[0].Value = pMEquipmentinfo.PMPO_PurchaseOrderID;
parm[1] = new SqlParameter("@PMPOD_Num", SqlDbType.Decimal);
parm[1].Value = pMEquipmentinfo.PMPOD_Num;
parm[2] = new SqlParameter("@PMPOD_Price", SqlDbType.Decimal);
parm[2].Value = pMEquipmentinfo.PMPOD_Price;
parm[3] = new SqlParameter("@PMPOD_TotalMoney", SqlDbType.Decimal);
parm[3].Value = pMEquipmentinfo.PMPOD_TotalMoney;
parm[4] = new SqlParameter("@PMPOD_Remark", SqlDbType.VarChar, 400);
parm[4].Value = pMEquipmentinfo.PMPOD_Remark;
parm[5] = new SqlParameter("@IMMBD_MaterialID", SqlDbType.UniqueIdentifier);
parm[5].Value = pMEquipmentinfo.IMMBD_MaterialID;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_I_PMPurchaseOrderDetail_Equipment", parm);
}
//新增采购订单
public void InsertPMPurchaseOrder_Equipment(PMEquipmentinfo pMEquipmentinfo)
{
SqlParameter[] parm = new SqlParameter[17];
parm[0] = new SqlParameter("@PMSI_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = pMEquipmentinfo.PMSI_ID;
parm[1] = new SqlParameter("@PMPO_MakeMan", SqlDbType.VarChar, 20);
parm[1].Value = pMEquipmentinfo.PMPO_MakeMan;
parm[2] = new SqlParameter("@PMPO_PlanArrTime", SqlDbType.Date);
parm[2].Value = pMEquipmentinfo.PMPO_PlanArrTime;
parm[3] = new SqlParameter("@PMPO_PayRemindTime", SqlDbType.Date);
parm[3].Value = pMEquipmentinfo.PMPO_PayRemindTime;
parm[4] = new SqlParameter("@PMPO_PayWay", SqlDbType.VarChar, 20);
parm[4].Value = pMEquipmentinfo.PMPO_PayWay;
parm[5] = new SqlParameter("@PMPO_PaymentTime", SqlDbType.SmallInt);
parm[5].Value = pMEquipmentinfo.PMPO_PaymentTime;
parm[6] = new SqlParameter("@PMPO_TotalMoney", SqlDbType.Decimal);
parm[6].Value = pMEquipmentinfo.PMPO_TotalMoney;
parm[7] = new SqlParameter("@PMPO_State", SqlDbType.VarChar, 20);
parm[7].Value = pMEquipmentinfo.PMPO_State;
parm[8] = new SqlParameter("@PMPO_Num", SqlDbType.Decimal);
parm[8].Value = pMEquipmentinfo.PMPO_Num;
parm[9] = new SqlParameter("@PMPOD_Num", SqlDbType.Decimal);
parm[9].Value = pMEquipmentinfo.PMPOD_Num;
parm[10] = new SqlParameter("@PMPOD_Price", SqlDbType.Decimal);
parm[10].Value = pMEquipmentinfo.PMPOD_Price;
parm[11] = new SqlParameter("@PMPOD_TotalMoney", SqlDbType.Decimal);
parm[11].Value = pMEquipmentinfo.PMPOD_TotalMoney;
parm[12] = new SqlParameter("@PMPOD_Remark", SqlDbType.VarChar, 400);
parm[12].Value = pMEquipmentinfo.PMPOD_Remark;
parm[13] = new SqlParameter("@IMMBD_MaterialID", SqlDbType.UniqueIdentifier);
parm[13].Value = pMEquipmentinfo.IMMBD_MaterialID;
parm[14] = new SqlParameter("@PMEA_ID", SqlDbType.UniqueIdentifier);
parm[14].Value = pMEquipmentinfo.PMEA_ID;
parm[15] = new SqlParameter("@PMEA_ApplyState", SqlDbType.VarChar, 20);
parm[15].Value = pMEquipmentinfo.PMEA_ApplyState;
parm[16] = new SqlParameter("@IMUC_ID", SqlDbType.UniqueIdentifier);
parm[16].Value = pMEquipmentinfo.IMUC_ID;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_I_PMPurchaseOrder_Equipment", parm);
}
//修改设备验收表
public void UpdatePMEquipmentCheckAccept(PMEquipmentinfo pMEquipmentinfo)
{
SqlParameter[] parm = new SqlParameter[8];
parm[0] = new SqlParameter("@PMEA_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = pMEquipmentinfo.PMEA_ID;
parm[1] = new SqlParameter("@PMECA_MainTechnologyPara", SqlDbType.VarChar, 400);
parm[1].Value = pMEquipmentinfo.PMECA_MainTechnologyPara;
parm[2] = new SqlParameter("@PMECA_AddOn", SqlDbType.VarChar, 400);
parm[2].Value = pMEquipmentinfo.PMECA_AddOn;
parm[3] = new SqlParameter("@PMECA_MECheck", SqlDbType.VarChar, 400);
parm[3].Value = pMEquipmentinfo.PMECA_MECheck;
parm[4] = new SqlParameter("@PMECA_NullDebugInfo", SqlDbType.VarChar, 400);
parm[4].Value = pMEquipmentinfo.PMECA_NullDebugInfo;
parm[5] = new SqlParameter("@PMECA_DebugConclusion", SqlDbType.VarChar, 400);
parm[5].Value = pMEquipmentinfo.PMECA_DebugConclusion;
parm[6] = new SqlParameter("@PMECA_OnDebugTime", SqlDbType.VarChar, 400);
parm[6].Value = pMEquipmentinfo.PMECA_OnDebugTime;
parm[7] = new SqlParameter("@PMECA_OnDebugInfo", SqlDbType.VarChar, 400);
parm[7].Value = pMEquipmentinfo.PMECA_OnDebugInfo;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_PMEquipmentCheckAccept", parm);
}
public void UpdatePMEquipmentCheckAccept(PMEquipmentinfo pMEquipmentinfo)
{
PMP.UpdatePMEquipmentCheckAccept(pMEquipmentinfo);
}
public DataSet SelectPMEquipmentApplyCountersign(PMEquipmentinfo pMEquipmentinfo)
{
return(PMP.SelectPMEquipmentApplyCountersign(pMEquipmentinfo));
}
public void UpdatePMEquipmentPrice(PMEquipmentinfo pMEquipmentinfo)
{
PMP.UpdatePMEquipmentPrice(pMEquipmentinfo);
}
public void UpdatePMECA_EDCheck(PMEquipmentinfo pMEquipmentinfo)
{
PMP.UpdatePMECA_EDCheck(pMEquipmentinfo);
}
public DataSet SelectPMEquipmentCheckAccept_One(PMEquipmentinfo pMEquipmentinfo)
{
return(PMP.SelectPMEquipmentCheckAccept_One(pMEquipmentinfo));
}
public DataSet SelectPMSI_SDepart_Equipment(PMEquipmentinfo pMEquipmentinfo)
{
return(PMP.SelectPMSI_SDepart_Equipment(pMEquipmentinfo));
}
public void UpdatePMEA_ApplyDepartCheck(PMEquipmentinfo pMEquipmentinfo)
{
PMP.UpdatePMEA_ApplyDepartCheck(pMEquipmentinfo);
}
public void UpdatePMEquipmentApplyCountersign(PMEquipmentinfo pMEquipmentinfo)
{
PMP.UpdatePMEquipmentApplyCountersign(pMEquipmentinfo);
}
public void UpdatePMEquipmentApply(PMEquipmentinfo pMEquipmentinfo)
{
PMP.UpdatePMEquipmentApply(pMEquipmentinfo);
}
public void InsertPMEquipmentApply(PMEquipmentinfo pMEquipmentinfo)
{
PMP.InsertPMEquipmentApply(pMEquipmentinfo);
}
public void DeletePMEquipmentApplyCountersign(PMEquipmentinfo pMEquipmentinfo)
{
PMP.DeletePMEquipmentApplyCountersign(pMEquipmentinfo);
}
public DataSet SelectEquipment_Cost(PMEquipmentinfo pMEquipmentinfo)
{
return(PMP.SelectEquipment_Cost(pMEquipmentinfo));
}
public void InsertPMEquipmentCheckAccept(PMEquipmentinfo pMEquipmentinfo)
{
PMP.InsertPMEquipmentCheckAccept(pMEquipmentinfo);
}
public void UpdatePMEA_GMCheck(PMEquipmentinfo pMEquipmentinfo)
{
PMP.UpdatePMEA_GMCheck(pMEquipmentinfo);
}
public void InsertPMEquipmentApplyCountersign(PMEquipmentinfo pMEquipmentinfo)
{
PMP.InsertPMEquipmentApplyCountersign(pMEquipmentinfo);
}
public void InsertPMPurchaseOrderDetail_Equipment(PMEquipmentinfo pMEquipmentinfo)
{
PMP.InsertPMPurchaseOrderDetail_Equipment(pMEquipmentinfo);
}
public DataSet SelectPMESupply(PMEquipmentinfo pMEquipmentinfo)
{
return(PMP.SelectPMESupply(pMEquipmentinfo));
}
