//新增铜材正料表 public void InsertPMCopperIn(PMCopperFoundryinfo pMCopperFoundryinfo) { SqlParameter[] parm = new SqlParameter[9]; parm[0] = new SqlParameter("@PMCF_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMCopperFoundryinfo.PMCF_ID; parm[1] = new SqlParameter("@PMCI_BillNum", SqlDbType.VarChar, 200); parm[1].Value = pMCopperFoundryinfo.PMCI_BillNum; parm[2] = new SqlParameter("@PMCI_ProductNum", SqlDbType.Decimal); parm[2].Value = pMCopperFoundryinfo.PMCI_ProductNum; parm[3] = new SqlParameter("@PMCI_ProPrice", SqlDbType.Decimal); parm[3].Value = pMCopperFoundryinfo.PMCI_ProPrice; parm[4] = new SqlParameter("@PMCI_BillTotalPrice", SqlDbType.Decimal); parm[4].Value = pMCopperFoundryinfo.PMCI_BillTotalPrice; parm[5] = new SqlParameter("@PMCI_AccountRate", SqlDbType.Decimal); parm[5].Value = pMCopperFoundryinfo.PMCI_AccountRate; parm[6] = new SqlParameter("@PMCI_Pay", SqlDbType.Char); parm[6].Value = pMCopperFoundryinfo.PMCI_Pay; parm[7] = new SqlParameter("@PMCI_Remark", SqlDbType.VarChar, 400); parm[7].Value = pMCopperFoundryinfo.PMCI_Remark; parm[8] = new SqlParameter("@PMCI_Model", SqlDbType.VarChar, 100); parm[8].Value = pMCopperFoundryinfo.PMCI_Model; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PMCopperIn", parm); }
//修改铜材加工价格表 public void UpdatePMCopperProcess(PMCopperFoundryinfo pMCopperFoundryinfo) { SqlParameter[] parm = new SqlParameter[9]; parm[0] = new SqlParameter("@PMCF_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMCopperFoundryinfo.PMCF_ID; parm[1] = new SqlParameter("@PMCP_ID", SqlDbType.UniqueIdentifier); parm[1].Value = pMCopperFoundryinfo.PMCP_ID; parm[2] = new SqlParameter("@PMCP_CopperPrice", SqlDbType.Decimal); parm[2].Value = pMCopperFoundryinfo.PMCP_CopperPrice; parm[3] = new SqlParameter("@PMCP_CopperDiscountRate", SqlDbType.Decimal); parm[3].Value = pMCopperFoundryinfo.PMCP_CopperDiscountRate; parm[4] = new SqlParameter("@PMCP_ZnPrice", SqlDbType.Decimal); parm[4].Value = pMCopperFoundryinfo.PMCP_ZnPrice; parm[5] = new SqlParameter("@PMCP_ZnDiscountRate", SqlDbType.Decimal); parm[5].Value = pMCopperFoundryinfo.PMCP_ZnDiscountRate; parm[6] = new SqlParameter("@PMCP_ProcessCost", SqlDbType.Decimal); parm[6].Value = pMCopperFoundryinfo.PMCP_ProcessCost; parm[7] = new SqlParameter("@PMCP_AccountRate", SqlDbType.Decimal); parm[7].Value = pMCopperFoundryinfo.PMCP_AccountRate; parm[8] = new SqlParameter("@PMCP_NowPrice", SqlDbType.Char, 2); parm[8].Value = pMCopperFoundryinfo.PMCP_NowPrice; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMCopperProcess", parm); }
//查找铜材加工价格表 public DataSet SelectPMCopperProcess(PMCopperFoundryinfo pMCopperFoundryinfo) { SqlParameter[] parm = new SqlParameter[1]; parm[0] = new SqlParameter("@PMCF_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMCopperFoundryinfo.PMCF_ID; return(SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_S_PMCopperProcess", parm)); }
//删除铜材退料表 public void DeletePMCopperReturn(PMCopperFoundryinfo pMCopperFoundryinfo) { SqlParameter[] parm = new SqlParameter[3]; parm[0] = new SqlParameter("@PMCR_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMCopperFoundryinfo.PMCR_ID; parm[1] = new SqlParameter("@PMCF_ID", SqlDbType.UniqueIdentifier); parm[1].Value = pMCopperFoundryinfo.PMCF_ID; parm[2] = new SqlParameter("@PMCR_NetNum", SqlDbType.Decimal); parm[2].Value = pMCopperFoundryinfo.PMCR_NetNum; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_D_PMCopperReturn", parm); }
//新增铜材代工表 public void InsertPMCopperFoundry(PMCopperFoundryinfo pMCopperFoundryinfo) { SqlParameter[] parm = new SqlParameter[4]; parm[0] = new SqlParameter("@PMSI_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMCopperFoundryinfo.PMSI_ID; parm[1] = new SqlParameter("@PMCF_MaterialName", SqlDbType.VarChar, 200); parm[1].Value = pMCopperFoundryinfo.PMCF_MaterialName; parm[2] = new SqlParameter("@PMCF_ReturnTotalNum", SqlDbType.Decimal); parm[2].Value = pMCopperFoundryinfo.PMCF_ReturnTotalNum; parm[3] = new SqlParameter("@PMCF_InTotalNum", SqlDbType.Decimal); parm[3].Value = pMCopperFoundryinfo.PMCF_InTotalNum; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PMCopperFoundry", parm); }
//新增铜材退料表 public void InsertPMCopperReturn(PMCopperFoundryinfo pMCopperFoundryinfo) { SqlParameter[] parm = new SqlParameter[4]; parm[0] = new SqlParameter("@PMCF_ID", SqlDbType.UniqueIdentifier); parm[0].Value = pMCopperFoundryinfo.PMCF_ID; parm[1] = new SqlParameter("@PMCR_Remark", SqlDbType.VarChar, 400); parm[1].Value = pMCopperFoundryinfo.PMCR_Remark; parm[2] = new SqlParameter("@PMCR_Num", SqlDbType.Decimal); parm[2].Value = pMCopperFoundryinfo.PMCR_Num; parm[3] = new SqlParameter("@PMCR_DeductRate", SqlDbType.Decimal); parm[3].Value = pMCopperFoundryinfo.PMCR_DeductRate; SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PMCopperReturn", parm); }
//加工价格表绑定 private void BindGridview4(PMCopperFoundryinfo PMCopperFoundryinfo) { Gridview4.DataSource = pf.SelectPMCopperProcess(PMCopperFoundryinfo); Gridview4.DataBind(); }
//退料表绑定 private void BindGridview3(PMCopperFoundryinfo PMCopperFoundryinfo) { Gridview3.DataSource = pf.SelectPMCopperReturn(PMCopperFoundryinfo); Gridview3.DataBind(); }
public DataSet SelectPMCopperProcess(PMCopperFoundryinfo pMCopperFoundryinfo) { return(IPF.SelectPMCopperProcess(pMCopperFoundryinfo)); }
public void DeletePMCopperReturn(PMCopperFoundryinfo pMCopperFoundryinfo) { IPF.DeletePMCopperReturn(pMCopperFoundryinfo); }
public void DeletePMCopperProcess(PMCopperFoundryinfo pMCopperFoundryinfo) { IPF.DeletePMCopperProcess(pMCopperFoundryinfo); }
public void UpdatePMCopperProcess(PMCopperFoundryinfo pMCopperFoundryinfo) { IPF.UpdatePMCopperProcess(pMCopperFoundryinfo); }
public void UpdatePMCopperReturn(PMCopperFoundryinfo pMCopperFoundryinfo) { IPF.UpdatePMCopperReturn(pMCopperFoundryinfo); }
public void InsertPMCopperProcess(PMCopperFoundryinfo pMCopperFoundryinfo) { IPF.InsertPMCopperProcess(pMCopperFoundryinfo); }
public void InsertPMCopperReturn(PMCopperFoundryinfo pMCopperFoundryinfo) { IPF.InsertPMCopperReturn(pMCopperFoundryinfo); }
//正料表绑定 private void BindGridview2(PMCopperFoundryinfo PMCopperFoundryinfo) { Gridview2.DataSource = pf.SelectPMCopperIn(PMCopperFoundryinfo); Gridview2.DataBind(); }
public DataSet SelectPMCopperReturn(PMCopperFoundryinfo pMCopperFoundryinfo) { return(IPF.SelectPMCopperReturn(pMCopperFoundryinfo)); }