public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
string sql = @"
update WK04 set WK04004=getdate() where WK04001=@wo and WK04002=@wc and WK04004 is null
";
BaseAdo ba = new BaseAdo();
ba.ExecuteSql(sql,
new SqlParameter("@wo", this.WorkOrder),
new SqlParameter("@wc", this.WorkCenter));
return this;
}
public override BaseSearchModel Insert()
{
BaseAdo ba = new BaseAdo();
StringBuilder sbRights = new StringBuilder("-1");
foreach (string item in Rights)
{
sbRights.Append("," + item);
}
string sql = @"delete from UR04 where UR04002=@roleid
insert into UR04(UR04002,UR04003)
select @roleid,UR03001 from UR03 where UR03001 in (" + sbRights + ")";
ba.ExecuteSql(sql, new SqlParameter("@roleid", this.RoleID));
return this;
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
string sql = @"
declare @bid varchar(30)
declare @hid int
declare @i int
set @i=0
while @i<@printcount
begin
exec PROC_GETID 'RW01',@bid output
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
values(@bid,getdate(),@userid,@username,@dj,N'创建条码标签')
insert into RW01(RW01001,RW01002,RW01003,RW01004,RW01005,RW01006,RW01033,RW01018,RW01024,RW01025,RW01027,RW01032,RW01034,RW01035,RW01037,RW01038,RW01040,RW01041,RW01042,RW01043)
values(@bid,@stock,@stockname,@stockspec,@unit,@qty,@wo,@remark,@userid,@username,@dj,1,@company,@Batch,@ProductionTime ,@ValidityTime,@tqty,@type,@pagecode,'WO')
insert into RW04(RW04002,RW04003,RW04004,RW04005) values(getdate(),@dj,@bid,N'创建条码')
set @i=@i+1
end
";
ModelAdo<StockModel> adoStock = new ModelAdo<StockModel>();
StockModel sm = adoStock.GetModelByID(this.StockCode);
BaseAdo ba = new BaseAdo();
ba.ExecuteSql(sql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@stock", this.StockCode),
new SqlParameter("@stockname", this.StockName),
new SqlParameter("@stockspec", this.StockSpec),
new SqlParameter("@unit", this.Unit),
new SqlParameter("@qty", this.UnitQty),
new SqlParameter("@tqty", sm.StockType == "02" ? 1 : sm.UQTY),
new SqlParameter("@type", sm.StockType),
new SqlParameter("@wo", this.WorkOrder),
new SqlParameter("@remark", this.Remark),
new SqlParameter("@company", this.Company),
new SqlParameter("@printcount", this.BarcodeQty),
new SqlParameter("@Batch", this.Batch),
new SqlParameter("@ProductionTime", this.ProductDate),
new SqlParameter("@ValidityTime", this.LifeDate),
new SqlParameter("@pagecode", this.PageCode),
new SqlParameter("@dj", this.Danju));
return this;
/*
string sql = @"
declare @dj varchar(30)
exec PROC_GETID 'FG03',@dj output
declare @bid varchar(30)
declare @hid int
declare @i int
insert into FG03(FG03001,FG03002,FG03003,FG03004,FG03005,FG03006,FG03007,FG03008)
values(@dj,getdate(),@userid,@username,'','','',N'创建条码')
set @i=0
while @i<@printcount
begin
exec PROC_GETID 'FG01',@bid output
insert into FG02(FG02002,FG02003,FG02004,FG02005,FG02010,FG02011)
values(@bid,getdate(),@userid,@username,@dj,N'创建条码标签')
insert into FG01(FG01001,FG01002,FG01003,FG01004,FG01005,FG01006,FG01012,FG01013,FG01014,FG01015,FG01018,FG01024,FG01025,FG01027,FG01032,FG01037,FG01033,FG01034,FG01035,FG01036,FG01038)
values(@bid,@stock,@stockname,@stockspec,@unit,@qty,'','','','',@remark,@userid,@username,@dj,1,@company,@workorder,@productdate,@lifedate,@pagecode,@lifeday)
insert into FG04(FG04002,FG04003,FG04004,FG04005) values(getdate(),@dj,@bid,N'创建条码')
set @i=@i+1
end
";
BaseAdo ba = new BaseAdo();
ba.ExecuteSql(sql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@workorder", this.WorkOrder),
new SqlParameter("@stock", this.StockCode),
new SqlParameter("@stockname", this.StockName),
new SqlParameter("@stockspec", this.StockSpec),
new SqlParameter("@unit", this.Unit),
new SqlParameter("@qty", this.UnitQty),
new SqlParameter("@remark", this.Remark),
new SqlParameter("@company", this.Company),
new SqlParameter("@printcount", this.BarcodeQty),
new SqlParameter("@productdate", this.ProductDate.ToString("yyyy-MM-dd")),
new SqlParameter("@lifedate", this.ProductDate.AddDays(this.LifeDate).ToString("yyyy-MM-dd")),
new SqlParameter("@lifeday", this.LifeDate),
new SqlParameter("@pagecode", this.PageCode));
return this;
* */
}
public override BaseSearchModel Insert()
{
using (TransactionScope ts = new TransactionScope())
{
string sql = @"
declare @dj varchar(30)
exec PROC_GETID 'RW03',@dj output
--单据头
insert into RW03(RW03001,RW03002,RW03003,RW03004,RW03005,RW03006,RW03007,RW03008)
values(@dj,getdate(),@userid,@username,'','','',N'US导入创建条码')
--装箱标签
insert into RW07(RW07001,RW07002,RW07003,RW07004,RW07005,RW07006,RW07007,RW07008)
select RW13017,getdate(),@userid,@username,0,'',0,2 from RW13 where RW13003=@impno and isnull(RW13006,'')<>'' and isnull(RW13017,'')<>'' and isnull(RW13007,'')<>'' and RW13010 not in (select RW01001 from RW01) group by RW13017
--单据明细
insert into RW04(RW04002,RW04003,RW04004,RW04005)
select getdate(),@dj,RW13010,N'US导入创建条码' from RW13 where RW13003=@impno and isnull(RW13006,'')<>'' and isnull(RW13007,'')<>'' and RW13010 not in (select RW01001 from RW01)
--历史记录
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
select RW13010,getdate(),@userid,@username,@dj,N'US导入创建条码' from RW13 where RW13003=@impno and isnull(RW13006,'')<>'' and isnull(RW13007,'')<>'' and RW13010 not in (select RW01001 from RW01)
--原材料
insert into RW01(RW01001,RW01002,RW01003,RW01004,RW01005,RW01006,RW01012,RW01013,RW01014,RW01015,RW01024,RW01025,RW01027,RW01031,RW01032,RW01034,RW01035,RW01037,RW01038,RW01041,RW01043,RW01044,RW01045)
select RW13010,RW13007,RW13008,RW13009,RW13015,RW13014,RW13018,RW13019,RW13005,RW13006,@userid,@username,@dj,RW13017,1,RW13016,RW13011,RW13012,RW13013,RW13022,'PO',RW13020,RW13021
from RW13 where RW13003=@impno and isnull(RW13006,'')<>'' and isnull(RW13007,'')<>'' and RW13010 not in (select RW01001 from RW01)
--删除成功的
delete from RW13 where RW13010 in (select RW01001 from RW01)
";
BaseAdo ba = new BaseAdo();
ba.ExecuteSql(sql, new SqlParameter("@userid", this.LoginUserID), new SqlParameter("@username", this.LoginUserName), new SqlParameter("@impno", IMPNO));
ModelAdo<USBarcodeModel> adoUB = new ModelAdo<USBarcodeModel>();
this.ReturnUSBarcodes = adoUB.GetList("RW13003=@impno", "", "", new SqlParameter("@impno", IMPNO));
ModelAdo<USBarcodeGroup> adoUBG = new ModelAdo<USBarcodeGroup>();
this.ReturnUSBarcodeGroups = adoUBG.GetList("RW13003=@impno", "", "", new SqlParameter("@impno", IMPNO));
ts.Complete();
return this;
}
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
lock (objLock)
{
using (TransactionScope ts = new TransactionScope())
{
BaseAdo ba = new BaseAdo();
BaseAdo bascala = new BaseAdo() { ConnectionStr = SysConfig.DBScalaConnection };
string sqlpo = @"
select * from view_poline where PC01001=@po and SC01003=@stockspec and Company=@company
select * from view_Stock where SC01003=@stockspec and Company=@company
";
string sql = @"
insert into RW13(RW13002,RW13003,RW13004,RW13005,RW13006,RW13007,RW13008,RW13009,RW13010,RW13011,RW13012,RW13013,RW13014,RW13015,RW13016,RW13017,RW13018,RW13019,RW13020,RW13021,RW13022)
values(getdate(),@IMPNO,@userid,@po,@poline,@stockcode,@stockname,@stockspec,@lpn,@supplierbatch,@productdate,@exdate,@qty,@unit,@company,@boxid,@supcode,@supname,@pounit,@saleunit,@stocktype)";
string strImport = System.Text.Encoding.ASCII.GetString(this.Bytes);
string[] strImportLine = strImport.Replace("\r", " ").Split('\n');
IMPNO = Guid.NewGuid().ToString();
for (int i = 1; i < strImportLine.Length; i++)
{
string BarcodeId = "";//导入文件中获取
string PackageId = "";//导入文件中获取
string StockCode = "";
string StockName = "";
string StockSpec = "";//导入文件中获取
string StockUnit = "";//导入文件中获取
string PO = "";//导入文件中获取
decimal StockUnitQty = 0;//导入文件中获取
string Company = "";//导入文件中获取
string SupplierBatch = "";//导入文件中获取
string supplierCode = "";
string supplierName = "";
double purunit = 1;
double saleunit = 1;
string stockType = "02";
string poline = "";
DateTime ProductionTime = DateTime.Now;//导入文件中获取
DateTime ValidityTime = DateTime.Now;//导入文件中获取
string[] strImprotLineItem = strImportLine[i].Split(';');
switch (strImprotLineItem[0])
{
case "11117": Company = "31"; break;
case "11116": Company = "32"; break;
default: Company = "-"; break;
}
PO = strImprotLineItem[2];
StockSpec = strImprotLineItem[3];
PackageId = strImprotLineItem[5];
BarcodeId = strImprotLineItem[6];
SupplierBatch = strImprotLineItem[7];
StockUnitQty = decimal.Parse(strImprotLineItem[10]);
DateTime.TryParse(strImprotLineItem[15], out ProductionTime);
DateTime.TryParse(strImprotLineItem[16], out ValidityTime);
DataSet ds = bascala.GetDataSet(sqlpo, new SqlParameter("@Company", Company), new SqlParameter("@stockspec", StockSpec), new SqlParameter("@po", PO));
if (ds.Tables[0].Rows.Count > 0)
{
poline = ds.Tables[0].Rows[0]["PC03002"] + "";
supplierCode = ds.Tables[0].Rows[0]["PL01001"] + "";
supplierName = ds.Tables[0].Rows[0]["PL01002"] + "";
}
if (ds.Tables[1].Rows.Count > 0)
{
double.TryParse(ds.Tables[1].Rows[0]["SC01072"] + "", out purunit);
double.TryParse(ds.Tables[1].Rows[0]["SC01073"] + "", out saleunit);
stockType = ds.Tables[1].Rows[0]["SC01035"] + "";
StockCode = ds.Tables[1].Rows[0]["SC01001"] + "";
StockName = ds.Tables[1].Rows[0]["SC01002"] + "";
StockUnit = ds.Tables[1].Rows[0]["UNIT"] + "";
}
ba.ExecuteSql(sql, new SqlParameter("@IMPNO", IMPNO),
new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@po", PO),
new SqlParameter("@poline", poline),
new SqlParameter("@stockcode", StockCode),
new SqlParameter("@stockname", StockName),
new SqlParameter("@stockspec", StockSpec),
new SqlParameter("@lpn", BarcodeId),
new SqlParameter("@supplierbatch", SupplierBatch),
new SqlParameter("@productdate", ProductionTime),
new SqlParameter("@exdate", ValidityTime),
new SqlParameter("@qty", StockUnitQty),
new SqlParameter("@unit", StockUnit),
new SqlParameter("@company", Company),
new SqlParameter("@boxid", PackageId),
new SqlParameter("@supcode", supplierCode),
new SqlParameter("@supname", supplierName),
new SqlParameter("@pounit", purunit),
new SqlParameter("@saleunit", saleunit),
new SqlParameter("@stocktype", stockType));
}
ModelAdo<USBarcodeModel> adoUB = new ModelAdo<USBarcodeModel>();
this.ReturnUSBarcodes = adoUB.GetList("RW13003=@impno", "", "", new SqlParameter("@impno", IMPNO));
ModelAdo<USBarcodeGroup> adoUBG = new ModelAdo<USBarcodeGroup>();
this.ReturnUSBarcodeGroups = adoUBG.GetList("RW13003=@impno", "", "", new SqlParameter("@impno", IMPNO));
ts.Complete();
}
}
return this;
}
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
//①：解析获取的文件数据，依据每行来读取。
//②：替换对应公司，17-31,16-32[[不存在回滚]]
//③：替换PART_CODE，通过SC01003，找到对应的StockName，StockCode[不存在回滚]
//④：条码编号：[存在回滚]
//⑤：是否存在装箱号条码。有：判断装箱条码中是否存在，如果存在：直接并入该装箱号条码。如果不存在：新建
//⑥：插入原材料： 1：插入，父单据号表；
// 2：插入，子单据号明细表；
// 3：插入，原材料条码表；
// 4：插入，条码历史记录表；
lock (objLock)
{
using (TransactionScope ts = new TransactionScope())
{
try
{
BaseAdo ba = new BaseAdo();
string sql = @"
declare @billid varchar(30)
exec PROC_GETID 'RW03',@billid output
--单据头
insert into RW03(RW03001,RW03002,RW03003,RW03004,RW03005,RW03006,RW03007,RW03008)
values(@billid,getdate(),@userid,@username,'','','',N'创建条码')
select @billid t";
DataSet dsBillId = ba.GetDataSet(sql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName));
string BillId = ""; //总单据号
if (dsBillId != null && dsBillId.Tables[0].Rows.Count > 0)
{
BillId = dsBillId.Tables[0].Rows[0][0] + "";
}
string strImport = System.Text.Encoding.ASCII.GetString(this.Bytes);
string[] strImportLine = strImport.Replace("\r", " ").Split('\n');
for (int i = 1; i < strImportLine.Length; i++)
{
string BarcodeId = "";//导入文件中获取
string PackageId = "";//导入文件中获取
string StockCode = "";
string StockName = "";
string StockSpec = "";//导入文件中获取
string StockUnit = "";//导入文件中获取
string PO = "";//导入文件中获取
decimal StockUnitQty = 0;//导入文件中获取
string Company = "";//导入文件中获取
string SupplierBatch = "";//导入文件中获取
DateTime ProductionTime = DateTime.Now;//导入文件中获取
DateTime ValidityTime = DateTime.Now;//导入文件中获取
string[] strImprotLineItem = strImportLine[i].Split(';');
if (strImprotLineItem[0].Contains("17"))
{
Company = "31";
}
else if (strImprotLineItem[0].Contains("16"))
{
Company = "32";
}
else
{
throw new Exception("未找到相对应的公司信息！");
}
PO = strImprotLineItem[2];
StockSpec = strImprotLineItem[3];
PackageId = strImprotLineItem[5];
BarcodeId = strImprotLineItem[6];
SupplierBatch = strImprotLineItem[7];
StockUnitQty = decimal.Parse(strImprotLineItem[10]);
DateTime.TryParse(strImprotLineItem[15], out ProductionTime);
DateTime.TryParse(strImprotLineItem[16], out ValidityTime);
ModelAdo<RWBarcodeModel> adoBarcode = new ModelAdo<RWBarcodeModel>();
RWBarcodeModel rwModel = adoBarcode.GetModelByID(BarcodeId);
if (rwModel != null && rwModel.ID.Length >= 1)
{
throw new Exception(BarcodeId + "已存在于条码系统中！");
}
if (!string.IsNullOrEmpty(PackageId))
{
ModelAdo<PackingModel> adoPackage = new ModelAdo<PackingModel>();
PackingModel packageModel = adoPackage.GetModelByID(PackageId);
if (packageModel != null)
{
}
else
{
string sqlPackage = @"
--装箱单
insert into RW07(RW07001,RW07002,RW07003,RW07004,RW07005,RW07006,RW07007,RW07008)
values(@packageid,getdate(),@userid,@username,0,'',0,2)";
ba.ExecuteSql(sqlPackage, new SqlParameter("packageid", PackageId),
new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName));
}
}
ModelAdo<StockModel> adoStock = new ModelAdo<StockModel>();
List<StockModel> Stocks = adoStock.GetList("SC01003=@stockspec", "", "", new SqlParameter("@stockspec", StockSpec));
if (Stocks != null && Stocks.Count >= 1)
{
StockCode = Stocks[0].StockCode;
StockName = Stocks[0].StockName;
StockUnit = Stocks[0].Unit;
StockUnitQty = Stocks[0].UQTY;
}
else
{
//throw new Exception("未找到相对应的物料信息！");
continue;
}
string barcodeSql = @"
--单据明细
insert into RW04(RW04002,RW04003,RW04004,RW04005) values(getdate(),@billid,@barcodeid,N'创建条码')
--历史记录
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
values(@barcodeid,getdate(),@userid,@username,@billid,N'创建条码标签')
--原材料
insert into RW01(RW01001,RW01002,RW01003,RW01004,RW01005,RW01006,RW01014,RW01024,RW01025,RW01027,RW01031,RW01032,RW01034,RW01035,RW01037,RW01038,RW01040,RW01041,RW01043)
values(@barcodeid,@stock,@stockname,@stockspec,@unit,@qty,@po,@userid,@username,@billid,@packageid,1,@company,@supplierbatch,@productiontime ,@validitytime,@tqty,@stype,'PO')
";
ba.ExecuteSql(barcodeSql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@stock", StockCode),
new SqlParameter("@stockname", StockName),
new SqlParameter("@barcodeid", BarcodeId),
new SqlParameter("@stockspec", StockSpec),
new SqlParameter("@packageid", PackageId),
new SqlParameter("@unit", StockUnit),
new SqlParameter("@qty", StockUnitQty),
new SqlParameter("@tqty", Stocks[0].UQTY),
new SqlParameter("@po", PO),
new SqlParameter("@stype", Stocks[0].StockType),
new SqlParameter("@company", Company),
new SqlParameter("@supplierbatch", SupplierBatch),
new SqlParameter("@productiontime", ProductionTime),
new SqlParameter("@validitytime", ValidityTime),
new SqlParameter("@billid", BillId));
}
ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
}
return this;
}
/*
/// <summary>
/// 创建条码信息
/// 1：插入，父单据号表；
/// 2：插入，子单据号明细表；
/// 3：插入，原材料条码表；
/// 4：插入，条码历史记录表；
/// </summary>
/// <returns></returns>
public override BaseSearchModel Insert()
{
ModelAdo<RWBarcodeModel> adoBarcode = new ModelAdo<RWBarcodeModel>();
ModelAdo<BillDetailModel> adoBillDetail = new ModelAdo<BillDetailModel>();
ModelAdo<RWHistoryModel> adoBarcodeHistroy = new ModelAdo<RWHistoryModel>();
List<RWBarcodeModel> listBarcode = new List<RWBarcodeModel>();
for (int i = 0; i < BarcodeQTY; i++)
{
RWBarcodeModel barcodeModel = new RWBarcodeModel()
{
Bill = billModel.ID,
CompanyCode = this.Company,
StockUnit = this.UNITPO,
StockCode = this.StockCode,
StockName = this.StockName,
StockSpec = this.StockSpec,
StockUnitQty = this.UNITQTY,
SupplierCode = this.SupplierCode,
SupplierName = this.SupplierName,
Warehouse = this.Warehouse,
SO = this.PO,
Status = 1,
POLine = this.LineNum,
WarehouseInTime = DateTime.Now,
WarehouseOutTime = DateTime.Now,
Remark1 = Remark
};
adoBarcode.Insert(barcodeModel);
listBarcode.Add(barcodeModel);
BillDetailModel billDetailModel = new BillDetailModel()
{
CreateTime = DateTime.Now,
BillID = billModel.ID,
BarcodeID = barcodeModel.ID,
Remark = billModel.Remark
};
adoBillDetail.Insert(billDetailModel);
RWHistoryModel historyModel = new RWHistoryModel()
{
CreateTime = DateTime.Now,
BillID = billModel.ID,
BarcodeID = barcodeModel.ID,
Remark = billModel.Remark
};
adoBarcodeHistroy.Insert(historyModel);
}
this.RWBarcodeModels = listBarcode.ToArray();
return this;
}
* */
public override BarcodeModel.MODEL.BaseSearchModel Insert()
{
string sql = @"
declare @bid varchar(30)
declare @hid int
declare @i int
set @i=0
while @i<@printcount
begin
exec PROC_GETID 'RW01',@bid output
insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
values(@bid,getdate(),@userid,@username,@dj,N'创建条码标签')
insert into RW01(RW01001,RW01002,RW01003,RW01004,RW01005,RW01006,RW01012,RW01013,RW01014,RW01015,RW01018,RW01024,RW01025,RW01027,RW01032,RW01034,RW01035,RW01037,RW01038,RW01040,RW01041,RW01043,RW01044,RW01045)
values(@bid,@stock,@stockname,@stockspec,@unit,@qty,@sup,@supname,@po,@poline,@remark,@userid,@username,@dj,1,@company,@SupplierBatch,@ProductionTime ,@ValidityTime,@tqty,@type,'PO',@unitpur,@unitsale)
insert into RW04(RW04002,RW04003,RW04004,RW04005) values(getdate(),@dj,@bid,N'创建条码')
set @i=@i+1
end
";
ModelAdo<StockModel> adoStock = new ModelAdo<StockModel>();
StockModel sm = adoStock.GetModelByID(this.StockCode);
BaseAdo ba = new BaseAdo();
ba.ExecuteSql(sql, new SqlParameter("@userid", this.LoginUserID),
new SqlParameter("@username", this.LoginUserName),
new SqlParameter("@stock", this.StockCode),
new SqlParameter("@stockname", this.StockName),
new SqlParameter("@stockspec", this.StockSpec),
new SqlParameter("@unit", this.UNITWH),
new SqlParameter("@qty", this.UNITQTY),
new SqlParameter("@tqty", this.Type == "02" ? 1 : sm.UQTY),
new SqlParameter("@type", sm.StockType),
new SqlParameter("@po", this.PO),
new SqlParameter("@poline", this.LineNum),
new SqlParameter("@sup", this.SupplierCode),
new SqlParameter("@supname", this.SupplierName),
new SqlParameter("@remark", this.Remark),
new SqlParameter("@company", this.Company),
new SqlParameter("@SupplierBatch", this.SupplierBatch),
new SqlParameter("@printcount", this.BarcodeQTY),
new SqlParameter("@ProductionTime", this.ProductionTime),
new SqlParameter("@ValidityTime", this.ValidityTime),
new SqlParameter("@dj", this.Danju),
new SqlParameter("@unitpur", this.PODivisor),
new SqlParameter("@unitsale", this.SODivisor));
return this;
}