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);
}
}
