using com.hnshituo.core.webapp.vo; using Common; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; using JC_MeasuringSystem; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace CraneScaleSystem { public partial class frmCraneScaleDb : Form { public frmCraneScaleDb() { InitializeComponent(); ClsControlPack.ShowGridCaption(ultraGridYb.DisplayLayout.Bands[0]); } private CoreAppUser userinfo = null; MeterWorkCarActualFirstService firstService = new MeterWorkCarActualFirstService(); MeterWorkCraneActualService craneActualService = new MeterWorkCraneActualService(); private void frmCraneScaleDb_Load(object sender, EventArgs e) { userinfo = ((ST_MainForm)(this.MdiParent)).AppUser; ClsControlPack.SetUltraGridRowFilter(ref ultraGridYb, true); ValueList vValid = new ValueList(); //状态（0=作废，1=有效，2=结净） vValid.ValueListItems.Add("2", "生成"); vValid.ValueListItems.Add("1", "有效"); vValid.ValueListItems.Add("0", "作废"); ultraGridYb.DisplayLayout.Bands[0].Columns["valueFlag"].ValueList = vValid.Clone(); ValueList vValidFst = new ValueList(); //状态（0=作废，1=有效，2=结净） vValidFst.ValueListItems.Add("2", "校磅"); vValidFst.ValueListItems.Add("1", "皮重"); vValidFst.ValueListItems.Add("0", "毛重");//weightType ultraGridYb.DisplayLayout.Bands[0].Columns["weightType"].ValueList = vValidFst.Clone(); } private void btnQuery_Click(object sender, EventArgs e) { doQuery(); } private void doQuery() { MeterWorkCraneActual mwca = new MeterWorkCraneActual(); mwca.startTime = Convert.ToDateTime($"{DateTime.Now.ToString("yyyy")}-01-01 00:00:00"); mwca.endTime = DateTime.Now; mwca.valueFlag = "1"; //mwca.weightType = "0"; //实际上需要生成1次数据的只有毛重数据 RESTfulResult> result = craneActualService.doQueryWf(mwca); if (result.Succeed) { if (result.Data == null || result.Data.Count == 0) { meterWorkCraneActualBindingSource.DataSource = new List(); CleanForm(); } else { meterWorkCraneActualBindingSource.DataSource = result.Data;//.Where(s => s.weightType != "1").ToList(); } ClsControlPack.RefreshAndAutoSize(ultraGridYb, true); } else { MessageBox.Show("查询失败：" + result.ResultMessage); } } private void btnCreateFirstDb_Click(object sender, EventArgs e) { if (!(meterWorkCraneActualBindingSource.DataSource is List)) return; //操作日志 MeterMonitorNote monitorNote = new MeterMonitorNote(); monitorNote.baseSpotNo = ""; monitorNote.baseSpotName = "贵金属吊钩秤"; monitorNote.operationContent = "贵金属数据生成"; monitorNote.operationTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); monitorNote.meterManNo = userinfo.userid; monitorNote.meterManName = userinfo.username; monitorNote.meterNoteSource = "0"; string msg = ""; string sPreNo = ""; List lmwca = (List)meterWorkCraneActualBindingSource.DataSource; foreach (MeterWorkCraneActual actual in lmwca) { if (actual.weightType == "0") { if (sPreNo != actual.predictionNo) { monitorNote.carNo = actual.carNo; MeterWorkCarActualFirst first = new MeterWorkCarActualFirst(); //相同名称的均赋值一次 EntityBase entityBase = new EntityBase(); first = entityBase.format(actual, first); first.meterNum = lmwca.Where(s => s.weightType == "0" && s.predictionNo == actual.predictionNo).Count(); first.meterWeight = lmwca.Where(s => s.weightType == "0" && s.predictionNo == actual.predictionNo).Sum(s => s.meterWeight); //执行一次生成，然后再赋值，继续下一轮 RESTfulResult res = firstService.doCraneDbWf(first, monitorNote); if (!res.Succeed) { msg = "生成异常："+res.ResultMessage; break; } sPreNo = actual.predictionNo; } } } if (!string.IsNullOrEmpty(msg)) { MessageBox.Show(msg); } doQuery(); } private void ultraGridYb_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ugr = ultraGridYb.ActiveRow; if (ugr != null) { foreach (UltraGridCell uc in ugr.Cells) { foreach (Control cn in gbBottom.Controls) { if (cn is TextBox) { if (cn.Name.Substring(3).ToLower() == uc.Column.Key.ToLower()) { cn.Text = uc.Text; break; } } } } } } private void CleanForm() { foreach (Control cn in gbBottom.Controls) { if (cn is TextBox) { cn.Text = ""; } } } private void btnCreateNetDB_Click(object sender, EventArgs e) { if (!(meterWorkCraneActualBindingSource.DataSource is List)) return; //操作日志 MeterMonitorNote monitorNote = new MeterMonitorNote(); monitorNote.baseSpotNo = ""; monitorNote.baseSpotName = "贵金属吊钩秤"; monitorNote.operationContent = "贵金属数据二次生成"; monitorNote.operationTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); monitorNote.meterManNo = userinfo.userid; monitorNote.meterManName = userinfo.username; monitorNote.meterNoteSource = "0"; string msg = ""; string sPreNo = ""; List lmwca = (List)meterWorkCraneActualBindingSource.DataSource; foreach (MeterWorkCraneActual actual in lmwca) { if (actual.weightType == "1") { if (sPreNo != actual.predictionNo) { RESTfulResult> resx = firstService.doQueryByCarNo(new MeterWorkCarActualFirst { predictionNo = actual.predictionNo, carNo = actual.carNo, baseSpotNo = "00018", valueFlag = "1" }); if (resx.Succeed) { if (resx.Data != null && resx.Data.Count > 0) { monitorNote.carNo = actual.carNo; MeterWorkCarActualFirst first = new MeterWorkCarActualFirst(); //相同名称的均赋值一次 EntityBase entityBase = new EntityBase(); first = entityBase.format(actual, first); //这个重量应该是汽车一次表中同预报编号，未结净的车信息的meterNum值*(当前重量/件数)，然后取整 first.meterWeight = int.Parse(((actual.meterWeight / actual.meterNum) * first.meterNum) + ""); MeterWorkCarActual netDb = new MeterWorkCarActual(); EntityBase entityB = new EntityBase(); netDb = entityBase.format(actual, netDb); netDb.netTime = DateTime.Now; netDb.netManNo = userinfo.userid; netDb.netManName = userinfo.username; netDb.netWeight = resx.Data[0].meterWeight - first.meterWeight; netDb.actualFirst1No = resx.Data[0].actualFirstNo; netDb.netSpot3No = first.baseSpotNo; netDb.netSpot3Name = first.baseSpotName; netDb.grossMode = "1"; netDb.tareMode = "1"; netDb.grossManNo = resx.Data[0].createManNo; netDb.grossManName = resx.Data[0].createManName; netDb.grossTime = resx.Data[0].createTime; netDb.grossWeight = resx.Data[0].meterWeight; netDb.baseSpot1No = resx.Data[0].baseSpotNo; netDb.baseSpot1Name = resx.Data[0].baseSpotName; netDb.tareManNo = first.createManNo; netDb.tareManName = first.createManName; netDb.tareTime = first.createTime; netDb.tareWeight = first.meterWeight; netDb.valueFlag = "0"; netDb.netMode = "1"; netDb.baseSpot2No = first.baseSpotNo; netDb.baseSpot2Name = first.baseSpotName; netDb.uploadFlag = "0"; netDb.netManNo = first.createManNo; //净重计量员编码 netDb.netManName = first.createManName; //净重计量员名称 netDb.netSpot3No = PbCache.sportInfo.baseSpotNo; //净重计量点编号 netDb.netSpot3Name = PbCache.sportInfo.baseSpotName; //净重计量点 //执行一次生成，然后再赋值，继续下一轮 RESTfulResult res = firstService.doCraneNetDbWf(first, netDb, monitorNote); if (!res.Succeed) { msg = "生成异常：" + res.ResultMessage; break; } sPreNo = actual.predictionNo; } } } } } if (!string.IsNullOrEmpty(msg)) { MessageBox.Show(msg); } doQuery(); } } }