//新增铜材正料表
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));
}
