| | |
|---|
| | | // mes.data = null; |
|---|
| | | // return mes; |
|---|
| | | //} |
|---|
| | | |
|---|
| | | //获取主表最大ID |
|---|
| | | sql = @"select ISNULL(IDENT_CURRENT('TMateriel_Info')+1,1) as id"; |
|---|
| | | var dt = DapperHelper.selecttable(sql); |
|---|
| | | |
|---|
| | | //写入存货分类 |
|---|
| | | sql = @"insert into TMateriel_Info(partcode,partname,partspec,idunit,idunitgroup,isSingleUnit,idSubUnitByReport,idUnitByStock,idUnitByPurchase,idUnitBySale,idunitbymanufacture, |
|---|
| | | sql = @"insert into TMateriel_Info(noid,partcode,partname,partspec,idunit,idunitgroup,isSingleUnit,idSubUnitByReport,idUnitByStock,idUnitByPurchase,idUnitBySale,idunitbymanufacture, |
|---|
| | | idinventoryclass,isPurchase,isSale,isMadeSelf,isMaterial,isMadeRequest,idwarehouse,status,lm_user,lm_date,data_sources) |
|---|
| | | values(@partcode,@partname,@partspec,@idunit,@idunitgroup,@isSingleUnit,@idSubUnitByReport,@idUnitByStock,@idUnitByPurchase,@idUnitBySale,@idunitbymanufacture, |
|---|
| | | values(@noid,@partcode,@partname,@partspec,@idunit,@idunitgroup,@isSingleUnit,@idSubUnitByReport,@idUnitByStock,@idUnitByPurchase,@idUnitBySale,@idunitbymanufacture, |
|---|
| | | @idinventoryclass,@isPurchase,@isSale,@isMadeSelf,@isMaterial,@isMadeRequest,@idwarehouse,@status,@lm_user,@lm_date,@data_sources)"; |
|---|
| | | list.Add(new |
|---|
| | | { |
|---|
| | | str = sql, |
|---|
| | | parm = new |
|---|
| | | { |
|---|
| | | partcode=partcode, |
|---|
| | | noid = int.Parse(dt.Rows[0]["ID"].ToString()), |
|---|
| | | partcode =partcode, |
|---|
| | | partname=partname, |
|---|
| | | partspec=partspec, |
|---|
| | | idunit=unittypcode=="1"?unitcode:unitsubcode, |
|---|
