/// <summary>
/// 审核作业票
/// </summary>
/// <param name="strGbno">TallyBillE对象</param>
/// <returns></returns>
public bool AuditTB(TallyBillE tb)
{
//校验作业票是否是重复生成
if (tb.Pmno != null)
{
string strSql = string.Format(@"update vw_reg_tallybill set mark_audit='{0}',audittime=to_date('{1}', 'yyyy/mm/dd hh24:mi:ss'),auditor='{2}' ,auditorname='{3}'
where tbno='{4}'",
tb.Mark_Audit, tb.AuditTime, tb.Auditor, tb.Auditorname, tb.Tbno);
da.ExecuteNonQuery(strSql);
}
return(true);
}
/// <summary>
/// 保存作业票
/// </summary>
/// <param name="strGbno">TallyBillE对象</param>
/// <returns></returns>
public bool SaveTB(TallyBillE tb)
{
//校验作业票是否是重复生成
if (tb.Pmno != string.Empty)
{
string strFilter = string.Format(" where tbno='{0}'", tb.Tbno);
string strSql = string.Format("select * from tb_hs_tallybill{0}", strFilter);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)//已存在，更新
{
string strUpdate_Hs_Tallybill = @"update vw_reg_tallybill set code_department='{0}',amount='{1}',weight='{2}',code_tallyman='{3}',tallyman='{4}',code_company='{5}', modifier='{6}',modifiername='{7}',modifytime=to_date('{10}', 'yyyy/mm/dd hh24:mi:ss'),amount2='{8}',mark_finish='{9}'" + strFilter;
strSql = string.Format(strUpdate_Hs_Tallybill, tb.Code_Department, tb.Amount, tb.Weight, tb.Code_Tallyman, tb.Tallyman, tb.Code_Company,
tb.Creator, tb.Creatorname, tb.Amount2, tb.Mark_finish, tb.AuditTime);
da.ExecuteNonQuery(strSql);
}
else//不存在，插入
{
string strInsert_Hs_Tallybill = "insert into vw_reg_tallybill(tbno,pmno,gbno,signdate,code_department,taskno,cgno,code_storage,code_booth,CODE_ALLOCATION,vgno,cabin,code_carrier,carriernum,NSNO_BARGE,bargepro,pieceweight,amount,weight,volume,code_measure,begintime,endtime,code_operation,code_operation_fact,code_quality,code_workflow,code_trainroad,workteam,code_worktime,code_teamtype,code_tallyman,tallyman,code_storagelast,code_boothlast,CODE_ALLOCATIONLAST,vgnolast,cabinlast,code_carrierlast,carriernumlast,NSNO_BARGELAST,bargeprolast,carrier1,carrier1num,carrier2,carrier2num,code_opstype,remark,gbdisplay,tallynum,gbnolast,gbdisplaylast,gbnofirst,containernum,parenttbno,gbnofromstock,code_company,code_section,trainnum,tallydate,mark_comp_plan,mark_comp_goodsbill,mark_comp_ship,code_billtype,creator,creatorname,createtime,code_motorcade,code_storage_stock,code_booth_stock,CODE_ALLOCATION_STOCK,code_opstype_fact,drivernum,workernum,amount2,code_workteam,machine,CODE_WORKINGAREA,CODE_WORKINGAREALAST,mark_finish,CARRIER1A,CARRIER2A) " +
" values('{0}','{1}','{2}',to_date('{3}','yyyy-mm-dd hh24:mi:ss'),'{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}', '{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}','{35}','{36}','{37}','{38}','{39}','{40}','{41}','{42}','{43}','{44}','{45}','{46}','{47}','{48}','{49}','{50}','{51}','{52}','{53}','{54}','{55}','{56}','{57}','{58}',to_date('{59}','yyyy-mm-dd hh24:mi:ss'),'{60}','{61}','{62}','{63}','{64}','{65}',to_date('{79}', 'yyyy/mm/dd hh24:mi:ss'),'{66}','{67}','{68}','{69}','{70}','{71}','{72}','{73}','{74}','{75}','{76}','{77}','{78}','{79}','{80}')";
strSql = string.Format(strInsert_Hs_Tallybill, tb.Tbno, tb.Pmno, tb.Gbno, tb.Signdate.ToString(),
tb.Code_Department, tb.Taskno, tb.Cgno, tb.Code_Storage, tb.Code_Booth, tb.code_allocation, tb.Vgno,
tb.Cabin, tb.Code_Carrier, tb.Carriernum, tb.NSNO_BARGE, tb.Bargepro, tb.Pieceweight,
tb.Amount, tb.Weight, tb.Volume, tb.Code_Measure, tb.Begintime, tb.Endtime,
tb.Code_Operation, tb.Code_Operation_Fact, tb.Code_Quality, tb.Code_workflow, tb.Code_trainroad, tb.Workteam,
tb.Code_Worktime, tb.Code_Teamtype, tb.Code_Tallyman, tb.Tallyman, tb.Code_Storagelast,
tb.Code_Boothlast, tb.code_allocationlast, tb.Vgnolast, tb.Cabinlast, tb.Code_Carrierlast,
tb.Carriernumlast, tb.NSNO_BARGELAST, tb.Bargeprolast, tb.Carrier1, tb.Carrier1num, tb.Carrier2, tb.Carrier2num,
tb.Code_Opstype, tb.Remark, tb.Gbdisplay, tb.Tallynum, tb.Gbnolast,
tb.Gbdisplaylast, tb.Gbnofirst, tb.Containernum,
tb.Parenttbno, tb.Gbnofromstock, tb.Code_Company, tb.Code_Section, tb.Trainnum, tb.Tallydate,
tb.Mark_comp_plan, tb.Mark_comp_goodsbill, tb.Mark_comp_ship, tb.Code_billtype,
tb.Creator, tb.Creatorname, tb.Code_motorcade, tb.Code_Storage_Stock, tb.Code_Booth_Stock, tb.code_allocationstock,
tb.Code_opstype_fact, tb.Drivernum,
tb.Workernum, tb.Amount2, tb.Code_Workteam, tb.Machine, tb.code_workingarea, tb.code_workingarealast, tb.Mark_finish, tb.Carrier1A, tb.Carrier2A);
da.ExecuteNonQuery(strSql);
}
}
return(true);
}
/// <summary>
/// 校验和赋值数量数据
/// </summary>
/// <param name="amount">件数</param>
/// <param name="weight">件数2</param>
/// <param name="count">重量</param>
/// <param name="count">数量</param>
/// <param name="count">车数</param>
/// <param name="count">TallyBillE对象</param>
/// <returns></returns>
private string VerifyAndSetQuantityData(string amount, string amount2, string weight, string count, string trainNum, ref TallyBillE tb)
{
string strJson = string.Empty;
try
{
tb.Amount = Format.ConToInt32(amount);
}
catch
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "件数格式输入不正确！").DicInfo());
return(strJson);
}
try
{
tb.Amount2 = Format.ConToInt32(amount2);
}
catch
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "件数2格式输入不正确！").DicInfo());
return(strJson);
}
try
{
if (string.IsNullOrWhiteSpace(weight))
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "请输入重量！").DicInfo());
return(strJson);
}
tb.Weight = Format.ConToDecimal(weight);
}
catch
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "重量格式输入不正确！").DicInfo());
return(strJson);
}
try
{
tb.Worknum = Format.ConToDecimal(count);
}
catch
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "数量格式输入不正确！").DicInfo());
return(strJson);
}
try
{
tb.Trainnum = Format.ConvertToDecimal(trainNum);
}
catch
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "车数格式输入不正确！").DicInfo());
return(strJson);
}
return(strJson);
}
/// <summary>
/// 保存班组
/// </summary>
/// <param name="strGbno">TallyBillE对象</param>
/// <returns></returns>
private string SaveWorkTeam(TallyBillE tb)
{
string strJson = string.Empty;
if (tb.TeamWorkData != string.Empty)
{
List <TeamWork> listTeamWork = JsonConvert.DeserializeObject <List <TeamWork> >(tb.TeamWorkData);
for (int iList = 0; iList < listTeamWork.Count; iList++)
{
Nullable <int> amount = null;
Nullable <decimal> weight = null;
Nullable <decimal> count = null;
TeamWork tw = listTeamWork[iList];
/*
*判断班组是否被选中，
* 1选中：判断是否已经存在；存在，更新；不存在，插入；
* 2未选中：判断是否已经存在；存在，删除；不存在，不用管；
*/
string strFilter = string.Format(" where tbno='{0}' and pmno='{1}' and code_workteam='{2}' and workno='{3}'", tb.Tbno, tb.Pmno, tw.code_workteam, tw.workno);
string strSql = string.Format("select * from TB_TALLY_WORKER{0}", strFilter);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql);
if (tw.select == "1")
{
if (string.IsNullOrWhiteSpace(tw.begintime) || string.IsNullOrWhiteSpace(tw.endtime))
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "班组起、至时间不能为空！").DicInfo());
return(strJson);
}
if (!TokenTool.VerifyHoursAndMinute(tw.begintime) || !TokenTool.VerifyHoursAndMinute(tw.endtime))
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "班组起、至时间格式不正确！").DicInfo());
return(strJson);
}
strJson = VerifyAndSetQuantityData(tw.amount, tw.weight, tw.count, ref amount, ref weight, ref count);
if (!string.IsNullOrWhiteSpace(strJson))
{
return(strJson);
}
Nullable <decimal> strWeightConfirm = tb.Mark_finish == '1' ? count : null;
if (dt.Rows.Count > 0)//已存在，更新
{
strSql =
string.Format(@"update TB_TALLY_WORKER set start_time='{0}',end_time='{1}',amount='{2}',weight='{3}',worknum='{4}',weight_confirm='{5}',modifytime=to_date('{6}','yyyy-mm-dd hh24:mi:ss'),modifier='{7}',modifiername='{8}'",
tw.begintime.Remove(2, 1), tw.endtime.Remove(2, 1), amount, weight, count, strWeightConfirm, tb.AuditTime, tb.Creator, tb.Creatorname);
}
else//不存在，插入
{
strSql =
string.Format(@"insert into TB_TALLY_WORKER(pmno,tbno,code_workteam,workno,start_time,end_time,amount,weight,worknum,code_department,weight_confirm,createtime,creator,creatorname)
values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}',to_date('{11}','yyyy-mm-dd hh24:mi:ss'),'{12}','{13}')",
tb.Pmno, tb.Tbno, tw.code_workteam, tw.workno, tw.begintime.Remove(2, 1), tw.endtime.Remove(2, 1), amount, weight, count, tb.Code_Department, strWeightConfirm, tb.AuditTime, tb.Creator, tb.Creatorname);
}
}
else
{
if (dt.Rows.Count > 0)//已存在，删除
{
strSql =
string.Format("delete from TB_TALLY_WORKER{0}", strFilter);
}
}
da.ExecuteNonQuery(strSql);
}
}
return(strJson);
}
protected void Page_Load(object sender, EventArgs e)
{
////http://218.92.115.55/M_DL_Gwtxc/Service/Slip/SaveTallyBill.aspx
var codeCompany = Request.Params["CodeCompany"];
var codeDepartment = Request.Params["CodeDepartment"];
var pmno = Request.Params["Pmno"];
var cgno = Request.Params["Cgno"];
var codeTallyman = Request.Params["CodeTallyman"];
var tallyman = Request.Params["Tallyman"];
var vgno = Request.Params["Vgno"];
var cabin = Request.Params["Cabin"];
var codeCarrier = Request.Params["CodeCarrier"];
var carrierNum = Request.Params["CarrierNum"];
var codeNvessel = Request.Params["CodeNvessel"];
var bargepro = Request.Params["Bargepro"];
var codeStorage = Request.Params["CodeStorage"];
var codeBooth = Request.Params["CodeBooth"];
var codeAllocation = Request.Params["CodeAllocation"];
var allocation = Request.Params["Allocation"].Trim();
//var allocation = Request.Params["CodeAllocation"];
var carrier1 = Request.Params["Carrier1"];
var carrier1Num = Request.Params["Carrier1Num"];
var vgnoLast = Request.Params["VgnoLast"];
var cabinLast = Request.Params["CabinLast"];
var codeCarrierLast = Request.Params["CodeCarrierLast"];
var carrierNumLast = Request.Params["CarrierNumLast"];
var codeNvesselLast = Request.Params["CodeNvesselLast"];
var bargeproLast = Request.Params["BargeproLast"];
var codeStorageLast = Request.Params["CodeStorageLast"];
var codeBoothLast = Request.Params["CodeBoothLast"];
var codeAllocationLast = Request.Params["CodeAllocationLast"].Trim();
var allocationLast = Request.Params["AllocationLast"].Trim();
//var allocationLast = Request.Params["CodeAllocationLast"].Trim();
var carrier2 = Request.Params["Carrier2"];
var carrier2Num = Request.Params["Carrier2num"];
var codeGoodsBill = Request.Params["CodeGoodsBill"];
var goodsBillDisplay = Request.Params["GoodsBillDisplay"];
var codeGbBusiness = Request.Params["CodeGbBusiness"];
var gbBusinessDisplay = Request.Params["GbBusinessDisplay"];
var codeSpecialMark = Request.Params["CodeSpecialMark"];
var codeWorkingArea = Request.Params["CodeWorkingArea"];
var codeWorkingAreaLast = Request.Params["CodeWorkingAreaLast"];
var quality = Request.Params["Quality"];
var amount = Request.Params["Amount"].Trim();
var weight = Request.Params["Weight"].Trim();
var count = Request.Params["Count"].Trim();
var amount2 = Request.Params["Amount2"].Trim();
var weight2 = Request.Params["Weight2"].Trim();
var count2 = Request.Params["Count2"].Trim();
var trainNum = Request.Params["TrainNum"].Trim();
var machine = Request.Params["Machine"];
var workTeam = Request.Params["WorkTeam"];
var tbno = Request.Params["Tbno"].Trim();
var markFinish = Request.Params["MarkFinish"].Trim();
var codeOperationFact = Request.Params["CodeOperationFact"];
tallyman = "PDA测试员";
// string message = string.Format(@"vgno:'{0}', cabin:'{1}', codeCarrier:'{2}', carrierNum:'{3}',codeNvessel:'{4}',
// bargepro:'{5}',codeStorage:'{6}',codeBooth:'{7}',codeAllocation:'{8}', +
// vgnoLast:'{9}', cabinLast:'{10}', codeCarrierLast:'{11}', carrierNumLast:'{12}',codeNvesselLast:'{13}',
// bargeproLast:'{14}',codeStorageLast:'{15}',codeBoothLast:'{16}',codeAllocationLast:'{17}' , +
// carrier1:'{18}', carrier1Num:'{19}', carrier2:'{20}', carrier2Num:'{21}'",
// vgno, cabin, codeCarrier, carrierNum, codeNvessel, bargepro, codeStorage, codeBooth, codeAllocation, vgnoLast, cabinLast, codeCarrierLast, carrierNumLast, codeNvesselLast, bargeproLast, codeStorageLast, codeBoothLast, codeAllocationLast, carrier1, carrier1Num, carrier2, carrier2Num);
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, message).DicInfo());
// return;
////测试
//codeCompany = "14";
//codeDepartment = "24";
//pmno = "20151010000161";
//cgno = "d1bff20fa2d54a0b87e4385a5cb46914";
//codeTallyman = "227";
//tallyman = "申";
//vgno = "20151003000002";
//cabin = "";
//codeCarrier = "";
//carrierNum = "";
//CodeNvessel = "";
//bargepro = "";
//codeStorage = "1";
//codeBooth = "185";
//codeAllocation = "";
//carrier1 = "中韩之星_2099999";
//carrier1Num = "";
//vgnoLast = "";
//cabinLast = "";
//codeCarrierLast = "";
//carrierNumLast = "";
//codeNvesselLast = "";
//bargeproLast = "";
//codeStorageLast = "111";
//codeBoothLast = "183";
//codeAllocationLast = "";
//carrier2 = "009场";
//carrier2Num = "无";
//codeGoodsBill = "1facb087e4654ddead033fb25552e358";
//goodsBillDisplay = "淮钢/铁矿石/散/0吨/进口/内贸/中韩之星_20151003_1/b/0/12232";
//codeGbBusiness = "1facb087e4654ddead033fb25552e358";
//gbBusinessDisplay = "淮钢/铁矿石/散/0吨/进口/内贸/中韩之星_20151003_1/b/0/12232";
//codeSpecialMark = "";
//codeWorkingArea = "";
//codeWorkingAreaLast = "";
//quality = "合格";
//amount = "123";
//weight = "123.4";
//count = Request.Params["Count"];
//amount2 = Request.Params["Amount2"];
//weight2 = Request.Params["Weight2"];
//count2 = Request.Params["Count2"];
//machine = Request.Params["Machine"];
//workTeam = Request.Params["WorkTeam"];
//trainNum = "23";
//tbno = "20151112064082";
////tbno = string.Empty;
//markFinish = "1";
//var codeCompany = "14";
//var codeDepartment = "24";
//var pmno = "20151010000161";
//var cgno = "d1bff20fa2d54a0b87e4385a5cb46914";
//var codeTallyman = "227";
//var tallyman = "薛辉";
//var vgno = "20151003000002";
//var cabin = "";
//var codeCarrier = "";
//var carrierNum = "";
//var codeNvessel = "";
//var bargepro = "";
//var codeStorage = "";
//var codeBooth = "";
//var codeAllocation = "";
//var carrier1 = "中韩之星_2099999";
//var carrier1Num = "";
//var vgnoLast = "";
//var cabinLast = "";
//var codeCarrierLast = "";
//var carrierNumLast = "";
//var codeNvesselLast = "";
//var bargeproLast = "";
//var codeStorageLast = "";
//var codeBoothLast = "";
//var codeAllocationLast = "";
//var carrier2 = "";
//var carrier2Num = "";
//var codeGoodsBill = "1facb087e4654ddead033fb25552e358";
//var goodsBillDisplay = "淮钢/铁矿石/散/0吨/进口/内贸/中韩之星_20151003_1/b/0/12232";
//var codeGbBusiness = "";
//var gbBusinessDisplay = "";
//var codeSpecialMark = "101";
//var codeWorkingArea = "66D0FE5D86DB45AFB4B572C9AF09D939";
//var codeWorkingAreaLast = "66D0FE5D86DB45AFB4B572C9AF09D939";
//var quality = "合格";
//var amount = "10";
//var weight = "123";
//var count = "11";
//var amount2 = "";
//var weight2 = "";
//var count2 = "";
////var machine = "[{\"endtime\"1412\"\",\"amount\":\"\",\"pmno\":\"20151021000241\",\"weight\":\"\",\"workno\":\"\",\"count\":\"\",\"begintime\":\"1512\",\"select\":\"1\",\"name\":\"111\",\"code_machine\":\"2C-6-11\",\"machine\":\"6t叉车\"},{\"endtime\":\"\",\"amount\":\"\",\"pmno\":\"20151021000241\",\"weight\":\"\",\"workno\":\"\",\"count\":\"\",\"begintime\":\"\",\"select\":\"1\",\"name\":\"\",\"code_machine\":\"2Q-25-01\",\"machine\":\"牵引车\"}]";
//var machine = "[{\"endtime\":\"15:33\",\"amount\":\"11\",\"pmno\":\"20151010000161\",\"weight\":\"12.3\",\"workno\":\"3\",\"count\":\"\",\"begintime\":\"14:12\",\"select\":\"1\",\"name\":\"\",\"code_machine\":\"2ZJK-2D-12\",\"machine\":\"集卡\"}]";
//var workTeam = "";
//var trainNum = "";
////var tbno = "20151112064117";
//var tbno = string.Empty;
//var markFinish = "0";
//调发货标志
string strMarkExchange = string.Empty;
string strTallydate = string.Empty;
string strTaskNo = string.Empty;
string strGbno = string.Empty;
string strGbdisplay = string.Empty;
string strGbnolast = string.Empty;
string strGbdisplaylast = string.Empty;
string strCodeMeasure = string.Empty;
string strCodeOpstype = string.Empty;
string strCodeBillType = string.Empty;
string strGbnoFromStock = string.Empty;
string strCodeStorageStock = string.Empty;
string strCodeBoothStock = string.Empty;
string strCodeAllocationStock = string.Empty;
string strGbnoFirst = string.Empty;
string strCodeOperation = string.Empty;
string strCodeOperationFact = string.Empty;
string strCodeOpstypeFact = string.Empty;
string strCodeWorkflow = string.Empty;
string strCodeWorkTime = string.Empty;
string strCodeTeamType = string.Empty;
string strCodeTrainRode = string.Empty;
string strCodeMotorcade = string.Empty;
string strBeginTime = string.Empty;
string strEndTime = string.Empty;
string strNsnoBarge = string.Empty;
string strNsnoBargeLast = string.Empty;
DateTime strCurTime = DateTime.Now;
TallyBillE tallybille = new TallyBillE();
try
{
//获取调发货标志
string strSql =
string.Format("select mark_exchange,mark_last from vw_hc_consign where cgno='{0}'", cgno);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strMarkExchange = Convert.ToString(dt.Rows[0]["mark_exchange"]);;
}
//获取理货日期、进出库类别代码、分解过程的进出库类别代码
strSql =
string.Format(@"select code_storage,code_storagelast,mark_tallybill,code_operation,code_operation_fact,CODE_CARRIER_S,CODE_CARRIER_E,vgdisplay,vgno,cabin,code_carrier,nvessel,
code_nvessel,carrier1,nsno,tallydate,code_opstype,code_workflow,code_worktime,code_teamtype,code_trainroad,code_motorcade,begintime,endtime,nsno_barge,nsno_bargelast
from vw_ps_mission where pmno='{0}'",
pmno);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strTallydate = Convert.ToString(dt.Rows[0]["tallydate"]);
strCodeOpstype = Convert.ToString(dt.Rows[0]["code_opstype"]);
strCodeOpstypeFact = Convert.ToString(dt.Rows[0]["code_opstype"]);
strCodeWorkflow = Convert.ToString(dt.Rows[0]["code_workflow"]);
strCodeWorkTime = Convert.ToString(dt.Rows[0]["code_worktime"]);
strCodeTeamType = Convert.ToString(dt.Rows[0]["code_teamtype"]);
strCodeTrainRode = Convert.ToString(dt.Rows[0]["code_trainroad"]);
strCodeMotorcade = Convert.ToString(dt.Rows[0]["code_motorcade"]);
strBeginTime = Convert.ToString(dt.Rows[0]["begintime"]);
strEndTime = Convert.ToString(dt.Rows[0]["endtime"]);
strNsnoBarge = Convert.ToString(dt.Rows[0]["nsno_barge"]);
strNsnoBargeLast = Convert.ToString(dt.Rows[0]["nsno_bargelast"]);
strCodeOperation = Convert.ToString(dt.Rows[0]["code_operation"]);
strCodeOperationFact = Convert.ToString(dt.Rows[0]["code_operation_fact"]);
}
//获取任务号、目的票货编码、目的票货描述
strSql =
string.Format(@"select GBDISPLAY,GBNO,MARK_EXCHANGE,HZGOODSBILL,MARK_LAST,CODE_CARRIER_S,CODE_CARRIER_E,TASKNO from VW_HC_CONSIGN_GBNO where code_company='{0}' and cgno='{1}'",
codeCompany, cgno);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strTaskNo = Convert.ToString(dt.Rows[0]["taskno"]);
}
strGbnolast = codeGbBusiness;
strGbdisplaylast = gbBusinessDisplay;
//获取计量单位编码、票货类型、源票货编码、源票货描述....
strSql =
string.Format(@"select code_measure from tb_hc_goodsbill where gbno='{0}'",
codeGoodsBill);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strCodeMeasure = Convert.ToString(dt.Rows[0]["code_measure"]);
}
strCodeBillType = "0";
strGbno = codeGoodsBill;
strGbdisplay = goodsBillDisplay;
//校验和赋值货位（堆）数据
Json = VerifyAndSetAllocationData(codeCompany, codeStorage, allocation, codeBooth, strCodeOpstype, ref codeAllocation);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
Json = VerifyAndSetAllocationData(codeCompany, codeStorageLast, allocationLast, codeBoothLast, strCodeOpstype, ref codeAllocationLast);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
if (strMarkExchange == "1")//调发货
{
strGbno = codeGbBusiness;
strGbdisplay = gbBusinessDisplay;
//strSql =
// string.Format("select gbno,exdisplay,gbdisplay,code_storage,code_booth,storage,booth from vw_hc_consign_adjust2 where cgno='{0}'", cgno);
//dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql);
//if (dt.Rows.Count > 0)
//{
// codeStorage = Convert.ToString(dt.Rows[0]["code_storage"]);
// codeBooth = Convert.ToString(dt.Rows[0]["code_booth"]);
// carrier1 = Convert.ToString(dt.Rows[0]["storage"]);
// carrier1Num = Convert.ToString(dt.Rows[0]["booth"]);
//}
//codeStorage = Convert.ToString(dt.Rows[0]["code_storage"]);
//codeBooth = Convert.ToString(dt.Rows[0]["code_booth"]);
//carrier1 = Convert.ToString(dt.Rows[0]["storage"]);
//carrier1Num = Convert.ToString(dt.Rows[0]["booth"]);
strGbnoFromStock = codeGoodsBill;
strCodeStorageStock = codeStorage;
strCodeBoothStock = codeBooth;
if (strCodeOpstype == "1")//作业方式属于进港
{
//判断是否已存在，存在返回编码，不存在则插入，并取回生成的编码
strCodeAllocationStock = InsertAllocation(codeCompany, strCodeStorageStock, allocation, strCodeBoothStock);
}
else
{
strCodeAllocationStock = codeAllocation;
}
}
//获取原始票货编码
strGbnoFirst = GetGbnofirst(strGbno);
//获取理货单编码
if (markFinish == "0" && string.IsNullOrWhiteSpace(tbno))
{
tbno = GetTbno();
}
if (markFinish == "1" && string.IsNullOrWhiteSpace(tbno))
{
tbno = GetTbno();
}
//赋值
tallybille.Code_Company = codeCompany;
tallybille.Code_Department = codeDepartment;
tallybille.Cgno = cgno;
tallybille.Pmno = pmno;
tallybille.Code_Tallyman = codeTallyman;
tallybille.Tallyman = tallyman;
tallybille.Vgno = vgno;
tallybille.Cabin = cabin;
tallybille.Code_Carrier = codeCarrier;
tallybille.Carriernum = carrierNum;
tallybille.Code_nvessel = codeNvessel;
tallybille.Bargepro = bargepro;
tallybille.Code_Storage = codeStorage;
tallybille.Code_Booth = codeBooth;
tallybille.code_allocation = codeAllocation;
tallybille.Carrier1 = carrier1;
tallybille.Carrier1num = carrier1Num;
tallybille.Vgnolast = vgnoLast;
tallybille.Cabinlast = cabinLast;
tallybille.Code_Carrierlast = codeCarrierLast;
tallybille.Carriernumlast = carrierNumLast;
tallybille.Code_nvessellast = codeNvesselLast;
tallybille.Bargeprolast = bargeproLast;
tallybille.Code_Storagelast = codeStorageLast;
tallybille.Code_Boothlast = codeBoothLast;
tallybille.code_allocationlast = codeAllocationLast;
tallybille.Carrier2 = carrier2;
tallybille.Carrier2num = carrier2Num;
tallybille.Code_SpecialMark = codeSpecialMark;
tallybille.code_workingarea = codeWorkingArea;
tallybille.code_workingarealast = codeWorkingAreaLast;
tallybille.Code_Quality = quality == "合格" ? "01" : "02";
tallybille.Creator = codeTallyman;
tallybille.Creatorname = tallyman;
tallybille.Carrier1A = allocation;
tallybille.Carrier2A = allocationLast;
tallybille.Signdate = Convert.ToDateTime(strTallydate);
tallybille.Tallydate = Convert.ToDateTime(strTallydate);
tallybille.Code_Opstype = strCodeOpstype;
tallybille.Code_opstype_fact = strCodeOpstypeFact;
tallybille.Code_workflow = strCodeWorkflow;
tallybille.Code_Worktime = strCodeWorkTime;
tallybille.Code_Teamtype = strCodeTeamType;
tallybille.Code_trainroad = strCodeTrainRode;
tallybille.Code_motorcade = strCodeMotorcade;
tallybille.Begintime = strBeginTime;
tallybille.Endtime = strEndTime;
tallybille.NSNO_BARGE = strNsnoBarge;
tallybille.NSNO_BARGELAST = strNsnoBargeLast;
tallybille.Taskno = strTaskNo;
tallybille.Gbnolast = strGbnolast;
tallybille.Gbdisplaylast = strGbdisplaylast;
tallybille.Gbno = strGbno;
tallybille.Gbdisplay = strGbdisplay;
tallybille.Code_billtype = strCodeBillType;
tallybille.Gbnofromstock = strGbnoFromStock;
tallybille.Code_Storage_Stock = strCodeStorageStock;
tallybille.Code_Booth_Stock = strCodeBoothStock;
tallybille.code_allocationstock = strCodeAllocationStock;
tallybille.Gbnofirst = strGbnoFirst;
tallybille.Code_Operation = strCodeOperation;
tallybille.Code_Operation_Fact = strCodeOperationFact;
tallybille.Tbno = tbno;
tallybille.Mark_finish = Convert.ToChar(markFinish);
tallybille.MachineData = machine;
tallybille.TeamWorkData = workTeam;
tallybille.Mark_Audit = "1";
tallybille.AuditTime = strCurTime;
tallybille.Auditor = codeTallyman;
tallybille.Auditorname = tallyman;
//Json = JsonConvert.SerializeObject(new DicPackage(false, null, machine + '+' + workTeam).DicInfo());
//return;
//Json = JsonConvert.SerializeObject(new DicPackage(false, null, amount + weight).DicInfo());
//校验和赋值数量数据
Json = VerifyAndSetQuantityData(amount, amount2, weight, count, trainNum, ref tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
da.BeginTransaction();
//暂存或提交数据
if (tallybille.Mark_finish == '1')//提交
{
if (!SaveTB(tallybille))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "提交失败！").DicInfo());
}
Json = SaveMachine(tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
Json = SaveWorkTeam(tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
//if (!AuditTB(tallybille))
//{
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, "提交失败！").DicInfo());
//}
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "提交成功！").DicInfo());
}
else//暂存
{
if (!SaveTB(tallybille))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "暂存失败！").DicInfo());
}
Json = SaveMachine(tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
Json = SaveWorkTeam(tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "暂存成功！").DicInfo());
}
da.CommitTransaction();
//string strKeyPath = "Software\\HarborSoft\\NHarborService";
//new DataAccessC(strKeyPath).GetDataSetByStoredProcedure("{ call PK_TALLYBILL_ACCOUNT.P_TALLYBILL_PIECERATE_MATCH('" + tallybille.Tbno + "')}");
}
catch (Exception ex)
{
da.RollbackTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：提交数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}