using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DAL
|
{
|
public class ClsProduct_Add:DBUtility.ClsXt_BaseBill
|
{
|
public Model.ClsProduct_Base omodel1 = new Model.ClsProduct_Base();
|
public Model.ClsProduct_gyjd omodel2 = new Model.ClsProduct_gyjd();
|
public Model.ClsProduct_material omodel3 = new Model.ClsProduct_material();
|
|
public SQLHelper.ClsCNK3 oCn = new SQLHelper.ClsCNK3();
|
|
public ClsProduct_Add()
|
{
|
base.MvarItemKeySub = "Product_Base";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "Product_Base";
|
base.MvarReportTitle = "费用单明细记录";
|
base.BillType = "18020";
|
}
|
|
#region 固定代码
|
|
~ClsProduct_Add()
|
{
|
|
}
|
|
#endregion 自定义方法
|
|
//修改单据
|
public override bool DeleteBill(long lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
oCn.BeginTran();
|
//删除重复记录
|
//oCn.RunProc("Delete From CB_ItemMoneyBill_Tmp where HYear=" + omodel.HYear.ToString() + " and HPeriod=" + omodel.HPeriod.ToString() + " and HItMoneyID=" + omodel.HItMoneyID.ToString());
|
sReturn = "删除单据成功！";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//新增单据
|
public override bool AddBill(ref string sReturn)
|
{
|
try
|
{
|
DataSet Ds = new DataSet();
|
oCn.BeginTran();
|
//主表
|
oCn.RunProc("Insert Into Product_Base " +
|
"(kname,pname,ptuhao,jixing,pcolour,qita" +
|
") " +
|
" values('" + omodel1.kname + "','" + omodel1.pname + "','" + omodel1.ptuhao + "','" + omodel1.jixing + "','" + omodel1.pcolour + "','" + omodel1.qita + "'" +
|
") ");
|
//得到物料ID
|
//Ds = oCn.RunProcReturn("select id from Product_Base where kname='" + omodel1.kname + "' and pname='" + omodel1.pname + "' and ptuhao='" + omodel1.ptuhao + "' and jixing='" + omodel1.jixing + "' and pcolour='" + omodel1.pcolour + "' and qita='" + omodel1.qita + "' order by id");
|
Ds = oCn.RunProcReturn("select @@IDENTITY", "Product_Base");
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
else
|
{
|
omodel1.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
|
}
|
//
|
oCn.RunProc("Insert Into Product_gyjd " +
|
"(product_id,strg1,strg2,strg3,strg4,strg5" +
|
",strg6,strg7,strg8,strg9,strg10" +
|
",strg11,strg12,strg13,strg14" +
|
") " +
|
" values(" + omodel1.HInterID.ToString() + ",'" + omodel2.strg1 + "','" + omodel2.strg2 + "','" + omodel2.strg3 + "','" + omodel2.strg4 + "','" + omodel2.strg5 + "'" +
|
",'" + omodel2.strg6 + "','" + omodel2.strg7 + "','" + omodel2.strg8 + "','" + omodel2.strg9 + "','" + omodel2.strg10 + "'" +
|
",'" + omodel2.strg11 + "','" + omodel2.strg12 + "','" + omodel2.strg13 + "','" + omodel2.strg14 + "'" +
|
") ");
|
//
|
oCn.RunProc("Insert Into Product_material " +
|
"(product_id,strm1,strm2,strm3,strm4,strm5" +
|
",strm6,strm7,strm8,strm9,strm10" +
|
",strm11,strm12,strm13,strm14,strm15,strm16" +
|
") " +
|
" values(" + omodel1.HInterID.ToString() + ",'" + omodel3.strm1 + "','" + omodel3.strm2 + "','" + omodel3.strm3 + "','" + omodel3.strm4 + "','" + omodel3.strm5 + "'" +
|
",'" + omodel3.strm6 + "','" + omodel3.strm7 + "','" + omodel3.strm8 + "','" + omodel3.strm9 + "','" + omodel3.strm10 + "'" +
|
",'" + omodel3.strm11 + "','" + omodel3.strm12 + "','" + omodel3.strm13 + "','" + omodel3.strm14 + "','" + omodel3.strm15 + "','" + omodel3.strm16 + "'" +
|
") ");
|
sReturn = "新增单据成功！";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
|
|
|
}
|
}
|
