public void huaDong() { try { string SHIPDETAILID = null; if (txtNumber != null) { SHIPDETAILID = txtNumber.Text.Trim(); } string pageIndexAndCount = winFormPager1.PageIndex + "." + winFormPager1.PageSize; //ResultModelOfArrayOfModel_Huadong_Tms_Orderd4FqxSXX count = cs.GetHuadongQuery(null); //ResultModelOfint result=cs.GethuadongTmsOrderCount(); //cs.Timeout = 10000; //ResultModelOfArrayOfModel_Huadong_Tms_Orderd4FqxSXX huadong = cs.GetHuadongQuery(pageIndexAndCount); //ResultModelOfint result = cs.GethuadongWaybillNumberCount(SHIPDETAILID); ResultModelOfint result = cs.GethuadongWaybillVagueCount(SHIPDETAILID); winFormPager1.DrawControl(result.Data); //ResultModelOfArrayOfModel_Huadong_Tms_Orderd4FqxSXX huadong = cs.GetHuadongWaybillNumberQuery(SHIPDETAILID,pageIndexAndCount); ResultModelOfArrayOfModel_Huadong_Tms_Orderd4FqxSXX huadong = cs.GetHuadongWaybillVagueQuery(SHIPDETAILID, pageIndexAndCount); if (huadong.Code != 0) { MessageBox.Show(huadong.Message); } else { dataGridView1.AutoGenerateColumns = false; dataGridView1.Rows.Clear();//清空数据 foreach (Model_Huadong_Tms_Order item in huadong.Data) { int rowIndex = dataGridView1.Rows.Add(); dataGridView1.Rows[rowIndex].Cells[0].Value = item.RelationIdk__BackingField; dataGridView1.Rows[rowIndex].Cells[1].Value = item.Codek__BackingField; dataGridView1.Rows[rowIndex].Cells[2].Value = item.SRCEXPNOk__BackingField; dataGridView1.Rows[rowIndex].Cells[3].Value = item.ROADIDk__BackingField; dataGridView1.Rows[rowIndex].Cells[4].Value = item.SHIPDETAILIDk__BackingField; dataGridView1.Rows[rowIndex].Cells[5].Value = item.TOTALIDk__BackingField; dataGridView1.Rows[rowIndex].Cells[6].Value = item.LEGCODEk__BackingField; dataGridView1.Rows[rowIndex].Cells[7].Value = item.SHIPMENTCODEk__BackingField; dataGridView1.Rows[rowIndex].Cells[8].Value = item.OPERATIONTYPEk__BackingField; if (Convert.ToDateTime(item.DEMANDARRIVETIMEk__BackingField.ToString("yyyy-MM-dd")) > DateTime.MinValue && Convert.ToDateTime(item.DEMANDARRIVETIMEk__BackingField.ToString("yyyy-MM-dd")).Year != 1) { dataGridView1.Rows[rowIndex].Cells[9].Value = item.DEMANDARRIVETIMEk__BackingField; } else { dataGridView1.Rows[rowIndex].Cells[9].Value = null; } dataGridView1.Rows[rowIndex].Cells[10].Value = item.TOGTRANSNAMEk__BackingField; dataGridView1.Rows[rowIndex].Cells[11].Value = item.RECEIVEMANk__BackingField; dataGridView1.Rows[rowIndex].Cells[12].Value = item.RECEIVEPHONEk__BackingField; dataGridView1.Rows[rowIndex].Cells[13].Value = item.RECEIVEADDRk__BackingField; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 上传第三方运单号 /// </summary> private static void UploadThirdOrder() { ResultModelOfint result = new ResultModelOfint(); //List<Model_Huadong_Tms_Order> list = new List<Model_Huadong_Tms_Order>(); string msg = string.Empty; string err = string.Empty; Model_ThirdPartOrder hdOrder = null; try { //根据每次查询运单数量为条件查询几条信息 DataTable dt = HuadongTmsOrderServer.GethuadongTmsOrder(Common._MaxUploadOrderCount); if (dt != null && dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; hdOrder = new Model_ThirdPartOrder(); hdOrder.Idk__BackingField = Convert.ToInt32(row["id"]); hdOrder.RelationIdk__BackingField = row["relationId"].ToString(); hdOrder.OperateAtk__BackingField = row["OperateAt"].ToString(); result = Common._PdaServer.UploadThirdPartyOrder(hdOrder); //foreach (DataRow row in dt.Rows) //{ // Model_Huadong_Tms_Order huadong = new Model_Huadong_Tms_Order(); // huadong.Idk__BackingField = Convert.ToInt32(row["id"]); // huadong.RelationIdk__BackingField = row["relationId"].ToString(); // list.Add(huadong); // msg = huadong.RelationIdk__BackingField; //} //FrmParent.ParentForm.SetNewInfo("正在上报第三方运单" + msg + ",请稍候...", null); ////后台接口,上传数据 //result = Common._PdaServer.UploadHuadongTmsOrder(list.ToArray()); } } catch (Exception ex) { err = ex.Message; throw ex; } finally { if (result.Data == 1 || result.Data == 2) { HuadongTmsOrderServer.DeleteUploadHuadongTmsOrder(new List <string>() { hdOrder.RelationIdk__BackingField }); if (result.Data == 2 && hdOrder != null) { WaybillServer.DeleteThirdNodeByOptAt(hdOrder.RelationIdk__BackingField, hdOrder.OperateAtk__BackingField); } } else if (string.IsNullOrEmpty(err)) { err = result.Message; } err = err == null ? string.Empty : err; FrmParent.ParentForm.SetNewInfo(string.Format("{0}{1} {2}", (msg.Length == 0 ? "没有待上报的第三方运单." : "上报第三方运单"), msg, (err.Length == 0 ? (msg.Length == 0 ? "" : "成功") : "失败 " + err)), err.Length == 0); } }
/// <summary> /// 绑定数据 /// </summary> public void getCustomerLoad(int provinceId, int cityId, int county, string pageIndexAndCount) { try { //ResultModelOfArrayOfModel_Customerd4FqxSXX count = cs.GetCustomerListByRole(Enum_Role.Sender, true, provinceId, true, cityId, true, null); //ResultModelOfint result = cs.GetCustomerListByRoleCount(Enum_Role.Sender, true, provinceId, true, cityId, true); //winFormPager1.DrawControl(count.Data.Count<Model_Customer>()); //ResultModelOfArrayOfModel_Customerd4FqxSXX customer = cs.GetCustomerListByRole(Enum_Role.Sender, true, provinceId, true, cityId, true, pageIndexAndCount); ResultModelOfint result = cs.GetCustomerListByCountyCount(Enum_Role.Sender, true, provinceId, true, cityId, true, county, true); winFormPager1.DrawControl(result.Data); ResultModelOfArrayOfModel_Customerd4FqxSXX customer = cs.GetCustomerListByCounty(Enum_Role.Sender, true, provinceId, true, cityId, true, county, true, pageIndexAndCount); //if (count.Data.Count<Model_Customer>()<=0) if (result.Data <= 0) { contextMenuStrip1.Enabled = false; } else { contextMenuStrip1.Enabled = true; } if (customer.Code != 0) { MessageBox.Show(customer.Message); } else { dataGridView1.AutoGenerateColumns = false; dataGridView1.Rows.Clear(); foreach (Model_Customer item in customer.Data) { int rowIndex = dataGridView1.Rows.Add(); dataGridView1.Rows[rowIndex].Cells[0].Value = item.Idk__BackingField; dataGridView1.Rows[rowIndex].Cells[1].Value = item.FullNamek__BackingField; dataGridView1.Rows[rowIndex].Cells[2].Value = item.ContactPersonk__BackingField; dataGridView1.Rows[rowIndex].Cells[3].Value = item.Accountk__BackingField; dataGridView1.Rows[rowIndex].Cells[4].Value = item.ContactTelk__BackingField; dataGridView1.Rows[rowIndex].Cells[5].Value = item.ProvinceNamek__BackingField + "-" + item.CityNamek__BackingField + "-" + item.CountyNamek__BackingField; dataGridView1.Rows[rowIndex].Cells[6].Value = item.ContactAddressk__BackingField; dataGridView1.Rows[rowIndex].Cells[7].Value = item.CreateAtk__BackingField.ToString("yyyy-MM-dd HH:mm:ss"); if (item.Activedk__BackingField == Enum_Active.Enabled) { dataGridView1.Rows[rowIndex].Cells[8].Value = "启用"; } else { dataGridView1.Rows[rowIndex].Cells[8].Value = "停用"; } dataGridView1.Rows[rowIndex].Cells[9].Value = item.Remarkk__BackingField.Split('|')[1]; dataGridView1.Rows[rowIndex].Tag = item; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void RegionEdit() { try { if (region != null) { if (RegionDate()) { Model_Region regions = new Model_Region(); if (nanber == 0 || nanber == 2) { //修改 regions.Idk__BackingField = region.Idk__BackingField; regions.ParentIdk__BackingField = region.ParentIdk__BackingField; } else { //添加 regions.ParentIdk__BackingField = region.Idk__BackingField; } regions.Codek__BackingField = txtcode.Text.Trim(); regions.Namek__BackingField = txtname.Text.Trim(); regions.Levelk__BackingField = 0; regions.Orderk__BackingField = 0; regions.NameEnglishk__BackingField = string.Empty; regions.NameShortEnglishk__BackingField = string.Empty; ResultModelOfint regint = cs.RegionEdit(regions); if (regint.Code != 0) { MessageBox.Show(regint.Message); } else { MessageBox.Show("操作成功"); if (nanber == 0 || nanber == 1) { _frmadministrativecontrol.Refurbish(); } if (nanber == 2) { _frmseeadministratve.Refurbish(); } this.Close(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 加载运单主体信息 /// </summary> public void waybillbaseLoad(string waybillNumber, string pageIndexAndCount, string startTime, string endTime, int senderId, int receiverId) { try { if (startTime != null && endTime != null) { if (Convert.ToDateTime(startTime) > Convert.ToDateTime(endTime)) { MessageBox.Show("开始时间不能大于结束时间"); return; } } ResultModelOfint result = cs.GetQueryClientsListCount(waybillNumber, startTime, endTime, senderId, true, receiverId, true); winFormPager1.DrawControl(result.Data); if (result.Data <= 0) { contextMenuStrip1.Enabled = false; } else { contextMenuStrip1.Enabled = true; } ResultModelOfArrayOfModel_Waybill_Based4FqxSXX waybill = cs.GetQueryClientsList(waybillNumber, pageIndexAndCount, startTime, endTime, senderId, true, receiverId, true); if (waybill.Code != 0) { MessageBox.Show(waybill.Message); } else { dataGridView1.AutoGenerateColumns = false; dataGridView1.Rows.Clear(); foreach (Model_Waybill_Base item in waybill.Data) { int rowIndex = dataGridView1.Rows.Add(); dataGridView1.Rows[rowIndex].Cells[0].Value = item.Numberk__BackingField; dataGridView1.Rows[rowIndex].Cells[1].Value = item.ReceiverOrgk__BackingField; dataGridView1.Rows[rowIndex].Cells[2].Value = item.ReceiverPersonk__BackingField; dataGridView1.Rows[rowIndex].Cells[3].Value = item.ReceiverTelk__BackingField; dataGridView1.Rows[rowIndex].Cells[4].Value = item.ReceiverAddressk__BackingField; dataGridView1.Rows[rowIndex].Cells[5].Value = item.BeginAtk__BackingField.ToString("yyyy-MM-dd HH:mm:ss"); dataGridView1.Rows[rowIndex].Tag = item; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void GetColdChainData() { try { pictureBox1.Show(); if (lbStartTime.Text.Trim() == null && lbEndTime.Text.Trim() == null) { return; } //获取显示的标题行 ResultModelOfArrayOfModel_AiInfod4FqxSXX biaoti = cs.GetAiInfoByStorageId(node.StorageIdk__BackingField, true, null); if (biaoti.Code != 0) { MessageBox.Show(biaoti.Message); } else { dataGridView2.Columns.Clear(); //dataGridView2.Columns[0].HeaderText = "记录时间"; dataGridView2.Columns.Add("记录时间", "记录时间"); foreach (Model_AiInfo item in biaoti.Data) { dataGridView2.Columns.Add(item.PpointNamek__BackingField, item.PpointNamek__BackingField); } dataGridView2.Columns.Add("报警状态", "报警状态"); } //线程 调用提示文字框 //waitForm = null; //Thread waitThread = new Thread(new ThreadStart(this._ShowWaitForm)); //waitThread.Start(); //Thread.Sleep(100); string pageIndexAndCount = winFormPager1.PageIndex + "." + winFormPager1.PageSize; ResultModelOfint result = cs.GetWaybillNodeHistDataCount(node.StorageIdk__BackingField, true, lbStartTime.Text.Trim(), lbEndTime.Text.Trim()); winFormPager1.DrawControl(result.Data); //根据冷库id、开始时间、结束时间(下一个开始时间)查询冷链数据 ResultModelOfArrayOfArrayOfstringuHEDJ7Dj nodedatalist = cs.GetWaybillNodeHistDataList(node.StorageIdk__BackingField, true, lbStartTime.Text.Trim(), lbEndTime.Text.Trim(), pageIndexAndCount); //ResultModelOfArrayOfArrayOfstringuHEDJ7Dj count = cs.GetWaybillNodeHistDataList(node.StorageIdk__BackingField, true, lbStartTime.Text.Trim(), lbEndTime.Text.Trim(), null); //winFormPager1.DrawControl(count.Data.Count<String[]>()); if (nodedatalist.Code != 0) { MessageBox.Show(nodedatalist.Message); } else { //Thread.Sleep(100); //if (waitThread != null) //{ // waitForm.Close(); //waitThread.Abort(); //} pictureBox1.Hide(); dataGridView2.Rows.Clear(); foreach (String[] item in nodedatalist.Data) { int rowIndex = dataGridView2.Rows.Add(); for (int i = 0; i < item.Length; i++) { if (item[i] != item[item.Length - 1]) { //如果是第一列设置宽度和时间格式 if (item[i] == item[0]) { dataGridView2.Columns[i].Width = 130; dataGridView2.Columns[i].Resizable = DataGridViewTriState.False; dataGridView2.Rows[rowIndex].Cells[i].Value = DateTime.Parse(item[i]).ToString("yyyy-MM-dd HH:mm:ss"); } else { //如果不为空和非负浮点数的值显示一位小数点后的数字 if (item[i].ToString() != string.Empty && IsInteger(item[i].ToString()) == true) { dataGridView2.Rows[rowIndex].Cells[i].Value = Math.Round(Convert.ToDecimal(item[i]), 1); } else { dataGridView2.Rows[rowIndex].Cells[i].Value = "- -"; } } } else { if (item[item.Length - 1] == 0.ToString()) { dataGridView2.Rows[rowIndex].Cells[i].Value = "正常"; } else { dataGridView2.Rows[rowIndex].Cells[i].Value = "报警"; } } dataGridView2.Rows[rowIndex].Tag = item; } dataGridView2.Rows[rowIndex].Tag = item; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void GetColdChainDatas(string startTime, string endTime, string pageIndexAndCount) { try { if (coldstoragepda == null) { return; } if (startTime != null && endTime != null) { if (Convert.ToDateTime(startTime) > Convert.ToDateTime(endTime)) { MessageBox.Show("开始时间不能大于结束时间!"); return; } pictureBox1.Show(); //获取显示的标题行 ResultModelOfArrayOfModel_AiInfod4FqxSXX biaoti = cs.GetAiInfoByStorageId(coldstoragepda.StorageIdk__BackingField, true, null); if (biaoti.Code != 0) { MessageBox.Show(biaoti.Message); } else { dataGridView1.Columns.Clear(); dataGridView1.Columns.Add("记录时间", "记录时间"); foreach (Model_AiInfo item in biaoti.Data) { dataGridView1.Columns.Add(item.PpointNamek__BackingField, item.PpointNamek__BackingField); } dataGridView1.Columns.Add("报警状态", "报警状态"); } //线程 调用提示文字框 //waitForm = null; //Thread waitThread = new Thread(new ThreadStart(this._ShowWaitForm)); //waitThread.Start(); //Thread.Sleep(100); //根据冷库id、开始时间、结束时间(下一个开始时间)查询冷链数据 //ResultModelOfArrayOfArrayOfstringuHEDJ7Dj count = cs.GetWaybillNodeHistDataList(coldstoragepda.StorageIdk__BackingField, true, startTime, endTime, null); //winFormPager1.DrawControl(count.Data.Count<String[]>()); ResultModelOfint result = cs.GetWaybillNodeHistDataCount(coldstoragepda.StorageIdk__BackingField, true, startTime, endTime); winFormPager1.DrawControl(result.Data); ResultModelOfArrayOfArrayOfstringuHEDJ7Dj nodedatalist = cs.GetWaybillNodeHistDataList(coldstoragepda.StorageIdk__BackingField, true, startTime, endTime, pageIndexAndCount); if (nodedatalist.Code != 0) { MessageBox.Show(nodedatalist.Message); } else { //Thread.Sleep(100); //if (waitThread != null) //{ // waitForm.Close(); //waitThread.Abort(); //} pictureBox1.Hide(); dataGridView1.Rows.Clear(); foreach (String[] item in nodedatalist.Data) { int rowIndex = dataGridView1.Rows.Add(); for (int i = 0; i < item.Length; i++) { //判断是否为最后一列 if (item[i] != item[item.Length - 1]) { //设置第一列的时间宽度 if (item[i] == item[0]) { dataGridView1.Columns[i].Width = 130; //dataGridView1.Columns[i].Resizable = DataGridViewTriState.False; dataGridView1.Rows[rowIndex].Cells[i].Value = DateTime.Parse(item[i]).ToString("yyyy-MM-dd HH:mm:ss"); } else { //显示一位小数,不为空和非负浮点数 if (item[i] != string.Empty && IsInteger(item[i]) == true) { dataGridView1.Rows[rowIndex].Cells[i].Value = Math.Round(Convert.ToDecimal(item[i]), 1); } else { dataGridView1.Rows[rowIndex].Cells[i].Value = "- -"; } } } else { if (item[item.Length - 1] == "0") { dataGridView1.Rows[rowIndex].Cells[i].Value = "正常"; } else { dataGridView1.Rows[rowIndex].Cells[i].Value = "报警"; } } } } } } else { MessageBox.Show("请选择开始时间和结束时间!"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void AvGue() { try { string fullname = null; int provid = 0; int cityid = 0; int countyid = 0; if (txtDownstream.Text.Trim() != string.Empty) { fullname = txtDownstream.Text.Trim(); } if (cmbProvince.Text != "中国" && cmbCity.Text != "中国" && cmbCounty.Text != "中国") { provid = Convert.ToInt32(cmbProvince.SelectedValue); cityid = Convert.ToInt32(cmbCity.SelectedValue); countyid = Convert.ToInt32(cmbCounty.SelectedValue); } string pageIndexAndCount = winFormPager1.PageIndex + "." + winFormPager1.PageSize; Model_Customer customeravgue = new Model_Customer(); customeravgue.FullNamek__BackingField = fullname; customeravgue.ProvinceIdk__BackingField = provid; customeravgue.CityIdk__BackingField = cityid; customeravgue.CountyIdk__BackingField = countyid; //ResultModelOfint avguecount = cs.GetVagueQueryCount(customeravgue); ResultModelOfint avguecount = cs.GetConsigneeCountyCount(customeravgue); winFormPager1.DrawControl(avguecount.Data); //ResultModelOfArrayOfModel_Customerd4FqxSXX avgue = cs.GetVagueQuery(customeravgue, pageIndexAndCount); ResultModelOfArrayOfModel_Customerd4FqxSXX avgue = cs.GetConsigneeCounty(customeravgue, pageIndexAndCount); if (avguecount.Data <= 0) { contextMenuStrip1.Enabled = false; } else { contextMenuStrip1.Enabled = true; } if (avgue.Code != 0) { MessageBox.Show(avgue.Message); } else { dataGridView1.AutoGenerateColumns = false; dataGridView1.Rows.Clear(); foreach (Model_Customer item in avgue.Data) { int rowIndex = dataGridView1.Rows.Add(); dataGridView1.Rows[rowIndex].Cells[0].Value = item.Idk__BackingField; dataGridView1.Rows[rowIndex].Cells[1].Value = item.FullNamek__BackingField; dataGridView1.Rows[rowIndex].Cells[2].Value = item.ContactPersonk__BackingField; dataGridView1.Rows[rowIndex].Cells[3].Value = item.Accountk__BackingField; dataGridView1.Rows[rowIndex].Cells[4].Value = item.ContactTelk__BackingField; dataGridView1.Rows[rowIndex].Cells[5].Value = item.ProvinceNamek__BackingField + "-" + item.CityNamek__BackingField + "-" + item.CountyNamek__BackingField; dataGridView1.Rows[rowIndex].Cells[6].Value = item.ContactAddressk__BackingField; dataGridView1.Rows[rowIndex].Cells[7].Value = item.CreateAtk__BackingField.ToString("yyyy-MM-dd HH:mm:ss"); if (item.Activedk__BackingField == Enum_Active.Enabled) { dataGridView1.Rows[rowIndex].Cells[8].Value = "启用"; } else { dataGridView1.Rows[rowIndex].Cells[8].Value = "停用"; } dataGridView1.Rows[rowIndex].Cells[9].Value = item.Remarkk__BackingField.Split('|')[1]; dataGridView1.Rows[rowIndex].Tag = item; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }