private void FRM_DingDanGuanLi_Update_SelectHuoWu_Load(object sender, EventArgs e)
{
DataTable dtHuoWu = myDingDanGuanLi_UpdateClient.frmDingDanGuanLi_Update_SelectHuoWu().Tables[0];
dgvHuoWu.DataSource = dtHuoWu;
this.dgvHuoWu = PublicStaticMothd.SetDgv(dgvHuoWu);
}
private void btnChaXun_Select_Click(object sender, EventArgs e)
{
string 动态条件 = "";
if (chkRiQi.Checked)
{
动态条件 += " and ( PW_货运单表.接单时间 between '"
+ dtpKaiShi.Value.ToShortDateString()
+ " 00:00:00.000' and '"
+ dtpJieShu.Value.ToShortDateString()
+ " 23:59:59.999' )";
}
if (chkShouHuoFang.Checked)
{
动态条件 += " and PW_货运单表.收货方ID = " + cboShouHuoFang.SelectedValue.ToString();
}
if (chkTuoYunFang.Checked)
{
动态条件 += " and PW_货运单表.托运方ID = " + cboTuoYunFang.SelectedValue.ToString();
}
if (chkDingDanHao.Checked)
{
动态条件 += " and PW_货运单表.单据编号 = " + txtDingDanHao.Text;
}
dgvHuoYunDan.DataSource = myFRM_PeiZaiFaHuoFenBaoClient.
btnChaXun_Select_Click_SelectDingDanXinXi_DongTai(动态条件).Tables[0];
dgvHuoYunDan = PublicStaticMothd.SetDgv(dgvHuoYunDan);
if (dgvHuoYunDan.RowCount <= 0)
{
((DataTable)dgvMingXi.DataSource).Rows.Clear();
((DataTable)dgvFenBao.DataSource).Rows.Clear();
MessageBox.Show("无符合当前条件的记录，请改变条件后重新查询！");
}
}
private void FRM_XianLuGuanLi_Update_Load(object sender, EventArgs e)
{
this.dgvKeXuanXianLu = PublicStaticMothd.SetDgv(dgvKeXuanXianLu);
this.dgvZuiZhongXianLu = PublicStaticMothd.SetDgv(dgvZuiZhongXianLu);
//绑定网点下拉框
DataTable dt = myFRM_XianLuGuanLi_InsertClient.FRM_XianLuGuanLi_Insert_Load_ChaXunWangDianXinXi().Tables[0];
DataTable dt2 = dt.Copy();
this.cboQiShiWangDian.DataSource = dt;
this.cboQiShiWangDian.DisplayMember = "网点名称";
this.cboQiShiWangDian.ValueMember = "网点ID";
this.cboJieShuWangDian.DataSource = dt2;
this.cboJieShuWangDian.DisplayMember = "网点名称";
this.cboJieShuWangDian.ValueMember = "网点ID";
dgvZuiZhongXianLu.AutoGenerateColumns = false;
//根据线路ID查询线路信息和线路明细信息
DataTable dtXianLuZuiZhong = myFRM_XianLuGuanLi_UpdateClient.FRM_XianLuGuanLi_Update_Load_ChaXunXianLuXinXi(XianLuID).Tables[0];
DataTable dtXianLuZuiMingXi = myFRM_XianLuGuanLi_UpdateClient.FRM_XianLuGuanLi_Update_Load_ChaXunXianLuMingXiXinXi(XianLuID).Tables[0];
//给相应控件绑定值
txtXianLuMingCheng.Text = dtXianLuZuiZhong.Rows[0]["线路名称"].ToString();
this.txtZhuJiMa.Text = dtXianLuZuiZhong.Rows[0]["助记码"].ToString();
if (dtXianLuZuiMingXi.Rows.Count > 0) //如果存在线路明细
{
dgvZuiZhongXianLu.DataSource = dtXianLuZuiMingXi; //绑定dgv
cboQiShiWangDian.SelectedValue = dtXianLuZuiMingXi.Rows[0]["起始网点ID"]; //以线路明细的第一行的起始网点ID作为cboQiShiWangDian下拉框的值绑定
this.cboJieShuWangDian.SelectedValue = dtXianLuZuiMingXi.Rows[dtXianLuZuiZhong.Rows.Count - 1]["终止网点ID"]; //以线路明细的第最后行的终止网点ID作为cboJieShuWangDian下拉框的值绑定
}
bolWanCheng = true;
}
private void FRM_XianLuGuanLi_WangDianGuanLi_Load(object sender, EventArgs e)
{
this.dgvWangDianXinXi = PublicStaticMothd.SetDgv(dgvWangDianXinXi);
this.dgvXiangLinWangDianXinXi = PublicStaticMothd.SetDgv(dgvXiangLinWangDianXinXi);
this.rbtWangDianMingCheng.Checked = true;
ShuaXin();
}
private void FRM_PeiZaiFaHuoPeiZai_Insert_Load(object sender, EventArgs e)
{
#region 下拉框的绑定
this.dgvPeiZaiFaHuoMingXi = PublicStaticMothd.SetDgv(dgvPeiZaiFaHuoMingXi);
this.dgvPeiZaiFaHuoMingXi.ReadOnly = false;
this.dgvSiJi = PublicStaticMothd.SetDgv(dgvSiJi);
//始发网点下拉框
DataTable dtFaHuoWangDian = myPeiZaiFaHuoPeiZai_Insert.frmPeiZaiFaHuo_Insert_SelectcboWiangDian().Tables[0];
cboFaHuoWangDian.DataSource = dtFaHuoWangDian;
cboFaHuoWangDian.DisplayMember = "网点名称";
cboFaHuoWangDian.ValueMember = "网点ID";
cboFaHuoWangDian.SelectedIndex = -1;
//收货网点下拉框
DataTable dtMuDiWangDian = myPeiZaiFaHuoPeiZai_Insert.frmPeiZaiFaHuo_Insert_SelectcboWiangDian().Tables[0];
cboMuDiWangDian.DataSource = dtMuDiWangDian;
cboMuDiWangDian.DisplayMember = "网点名称";
cboMuDiWangDian.ValueMember = "网点ID";
cboMuDiWangDian.SelectedIndex = -1;
cboXianLuXuanZhe.Visible = false;
txtPeiZaiFaHuoDanBianHao.Text = ShengChengDanHao();
//车辆信息下拉框
DataTable dtCheliang = myPeiZaiFaHuoPeiZai_Insert.frmPeiZaiFaHuo_Insert_SelectcboCheLiang().Tables[0];
cboXuanZheCheLiang.DataSource = dtCheliang;
cboXuanZheCheLiang.DisplayMember = "车牌号";
cboXuanZheCheLiang.ValueMember = "车辆ID";
#endregion
dgvPeiZaiFaHuoMingXi.RowHeadersVisible = false;
bolStartFinish = true;
}
private void FRM_PeiZaiFaHuoShiShiPeiZai_Load(object sender, EventArgs e)
{
this.dgvFenBao = PublicStaticMothd.SetDgv(dgvFenBao);
dgvFenBao.ReadOnly = false;
#region 查询绑定下拉框
dgvFenBao.RowHeadersVisible = false;
//绑定始发网点下拉框
DataTable dtQiShiWangDian = myPeiZaiFaHuo_ShiShiPeiZaiClient.frmPeiZaiFaHuo_ShiShiPeiZai_SelectcboWiangDian().Tables[0];
cboShiFaWangDian.DataSource = dtQiShiWangDian;
cboShiFaWangDian.DisplayMember = "网点名称";
cboShiFaWangDian.ValueMember = "网点ID";
//绑定揽收状态下拉框
DataTable dtLanShouZhuangTai = myPeiZaiFaHuo_ShiShiPeiZaiClient.frmPeiZaiFaHuo_ShiShiPeiZai_SelectcboLanShouZhuangTai().Tables[0];
cboDingDanZhuangTai.DataSource = dtLanShouZhuangTai;
cboDingDanZhuangTai.DisplayMember = "货物揽收状态";
cboDingDanZhuangTai.ValueMember = "货物揽收状态ID";
//绑定目的网点下拉框
DataTable dtMuDiWangDian = myPeiZaiFaHuo_ShiShiPeiZaiClient.frmPeiZaiFaHuo_ShiShiPeiZai_SelectcboWiangDian().Tables[0];
cboMuDiWangDian.DataSource = dtMuDiWangDian;
cboMuDiWangDian.DisplayMember = "网点名称";
cboMuDiWangDian.ValueMember = "网点ID";
//加载分包dgv
DataTable dtLoadFenBao = myPeiZaiFaHuo_ShiShiPeiZaiClient.frmPeiZaiFaHuo_ShiShiPeiZai_LoadFenBao().Tables[0];
dgvFenBao.DataSource = dtLoadFenBao;
#endregion
}
private void FRM_QuanXianZu_Update_Load(object sender, EventArgs e)
{
DataTable dtQuanXianMoKuai = BLL_QuanXianZu_Update.FRM_QuanXianZu_Update_Load_ChaXunQuanXianZuMoKuai(QuanXianZuID).Tables[0];
dgvMoKuai.DataSource = dtQuanXianMoKuai;
this.dgvMoKuai = PublicStaticMothd.SetDgv(dgvMoKuai);
dgvMoKuai.ReadOnly = false;
}
private void FRM_ChuCheDengJi_Load(object sender, EventArgs e)
{
#region 定义窗体大小、窗体位置
this.Left = PublicStaticObject.MainLeft;
this.Top = PublicStaticObject.MainTop;
this.Width = PublicStaticObject.MainWidth;
this.Height = PublicStaticObject.MainHeight;
#endregion
dgvCheLiangPeiZaiXinXi.AllowUserToAddRows = false;
DataTable dtWangDian =
myFRM_ChuCheDengJiClient.
FRM_ChuCheDengJi_Load_ChaXunWangDian().Tables[0];
DataTable dtWangDian2 = dtWangDian.Copy();
DataTable dtZhuangTai =
myFRM_ChuCheDengJiClient.
FRM_ChuCheDengJi_Load_ChaXunZhuangTai().Tables[0];
//加载起始网点下拉框
cboKaiShi.DataSource = dtWangDian;
cboKaiShi.DisplayMember = "网点名称";
cboKaiShi.ValueMember = "网点ID";
//加载目的网点下拉框
cboJieShu.DataSource = dtWangDian2;
cboJieShu.DisplayMember = "网点名称";
cboJieShu.ValueMember = "网点ID";
//加载状态下拉框
cboZhuangTai.DataSource = dtZhuangTai;
cboZhuangTai.DisplayMember = "状态";
cboZhuangTai.ValueMember = "状态ID";
dgvCheLiangPeiZaiXinXi = PublicStaticMothd.SetDgv(dgvCheLiangPeiZaiXinXi);
//查询车辆表
dtCheLiang = myFRM_ChuCheDengJiClient.FRM_ChuCheDengJi_Load_ChaXunCheLiang().Tables[0];
//生成车辆视图
for (int i = 0; i < dtCheLiang.Rows.Count; i++)
{
PictureBox pb = new PictureBox(); //创建一个图片框控件
pb.Size = new Size(150, 100);
pb.Tag = dtCheLiang.Rows[i]; //把当前行数据放到tag对象中
int 车辆状态ID = (int)dtCheLiang.Rows[i]["状态ID"];
switch (车辆状态ID)
{
case 1: pb.BackgroundImage = Properties.Resources.停运; break;
case 2: pb.BackgroundImage = Properties.Resources.空闲; break;
case 3: pb.BackgroundImage = Properties.Resources.卸货; break;
case 4: pb.BackgroundImage = Properties.Resources.配载; break;
case 5: pb.BackgroundImage = Properties.Resources.运送; break;
}
pb.BackgroundImageLayout = ImageLayout.Stretch;
pb.Paint += new PaintEventHandler(pb_Paint);
pb.MouseEnter += new EventHandler(pb_MouseEnter);
pb.MouseLeave += new EventHandler(pb_MouseLeave);
pb.MouseClick += new MouseEventHandler(pb_MouseClick);
flpCheLiang.Controls.Add(pb);//将pb添加到flp控件中
}
}
private void FRM_QuanXianZu_Insert_Load(object sender, EventArgs e)
{
dgvMoKuai.AutoGenerateColumns = false;
dtMoKuai = BLL_QuanXianZu_Insert.FRM_QuanXianZu_Insert_Load_ChaXunMoKuai().Tables[0];
dtMoKuai.Columns.Add(new DataColumn("选择", System.Type.GetType("System.Boolean")));
dgvMoKuai.DataSource = dtMoKuai;
this.dgvMoKuai = PublicStaticMothd.SetDgv(dgvMoKuai);
dgvMoKuai.ReadOnly = false;
}
private void FRM_XianLuGuanLi_WangDianGuanLi_Insert_Load(object sender, EventArgs e)
{
this.dgvXiangLinWangDian = PublicStaticMothd.SetDgv(dgvXiangLinWangDian);
DataTable dt = myFRM_XianLuGuanLi_WangDianGuanLi_InsertClient.FRM_XianLuGuanLi_WangDianGuanLi_Insert_Load_ChaXunWangDianXinXi().Tables[0]; //查询全部网点信息
this.dgvXiangLinWangDian.AllowUserToAddRows = false; //禁止增加行
this.dgvXiangLinWangDian.AllowUserToResizeRows = false; //禁止改变行大小
this.dgvXiangLinWangDian.DataSource = dt; //绑定dgv
停用否 = "false";
}
BLL物流管理系统.用户权限管理.BLL_YongHuQuanXian.BLL_YongHuQuanXianClient(); //实例化BLL
private void FRM_YongHuQuanXian_Load(object sender, EventArgs e)
{
DataTable dt = myBLL_BLL_YongHuQuanXia.FRM_YongHuQuanXian_Load_ChaXunYongHu().Tables[0];
dgv_User.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //设定选定行的模式
dgv_User.AutoGenerateColumns = false;
dgv_User.DataSource = dt;
dgv_User = PublicStaticMothd.SetDgv(dgv_User);
dgv_User.MultiSelect = true;
}
private void FRM_QuanXianZu_Load(object sender, EventArgs e)
{
this.dgvAuthGroup = PublicStaticMothd.SetDgv(dgvAuthGroup);
this.dgvMoKuai = PublicStaticMothd.SetDgv(dgvMoKuai);
dgvAuthGroup.AutoGenerateColumns = false;
dgvAuthGroup.DataSource = BLL_QuanXianZu.FRM_QuanXianZu_Load_ChaXunQuanXianZu().Tables[0];
int QuanXianZuID = Convert.ToInt32(dgvAuthGroup.CurrentRow.Cells["权限组ID"].Value.ToString());
dgvMoKuai.DataSource = BLL_QuanXianZu.FRM_QuanXianZu_dgvAuthGroup_CellClick_ChaXunMoKuai(QuanXianZuID).Tables[0];
}
private void FRM_PeiZaiFaHuoFenBao_Update_Load(object sender, EventArgs e)
{
txtDingDanBianHao.Text = str订单编号;
txtJiLianWangDian.Text = str寄件网点;
txtShouHuoWangDian.Text = str收货网点;
dgvMingXi.AutoGenerateColumns = false;
dgvMingXi.DataSource = myFRM_PeiZaiFaHuoFenBao_UpdateClient.
FRM_PeiZaiFaHuoFenBao_Update_Load_SelectDingDanMingXi(int货运单ID).Tables[0];
dgvMingXi.Columns["单据编号"].Frozen = true; //冻结"单据编号"列
dgvMingXi.Columns["货物名称"].Frozen = true; //冻结"货物名称"列
dgvFenBao = PublicStaticMothd.SetDgv(dgvFenBao);
}
private void dgvHuoYunDan_SelectionChanged(object sender, EventArgs e)
{
if (dgvHuoYunDan.CurrentRow != null)
{
int int货运单ID = Convert.ToInt32(dgvHuoYunDan.CurrentRow.Cells["货运单ID"].Value);
dgvMingXi.DataSource = myFRM_PeiZaiFaHuoFenBaoClient.
dgvHuoYunDan_SelectionChanged_SelectDingDanMingXi(int货运单ID).Tables[0];
dgvMingXi = PublicStaticMothd.SetDgv(dgvMingXi);
if (dgvMingXi.Rows.Count < 1)
{
((DataTable)dgvFenBao.DataSource).Rows.Clear();
}
}
}
private void FRM_XianLuGuanLi_Insert_Load(object sender, EventArgs e)
{
//绑定线路下拉框
this.dgvKeXuanXianLu = PublicStaticMothd.SetDgv(dgvKeXuanXianLu);
this.dgvZuiZhongXianLu = PublicStaticMothd.SetDgv(dgvZuiZhongXianLu);
DataTable dt = myFRM_XianLuGuanLi_InsertClient.FRM_XianLuGuanLi_Insert_Load_ChaXunWangDianXinXi().Tables[0];
DataTable dt2 = myFRM_XianLuGuanLi_InsertClient.FRM_XianLuGuanLi_Insert_Load_ChaXunWangDianXinXi().Tables[0];
this.cboQiShiWangDian.DataSource = dt;
this.cboQiShiWangDian.DisplayMember = "网点名称";
this.cboQiShiWangDian.ValueMember = "网点ID";
this.cboJieShuWangDian.DataSource = dt2;
this.cboJieShuWangDian.DisplayMember = "网点名称";
this.cboJieShuWangDian.ValueMember = "网点ID";
}
private void dgvMingXi_SelectionChanged(object sender, EventArgs e)
{
if (dgvMingXi.Rows.Count > 0)
{
if (dgvMingXi.CurrentRow != null)
{
int int货运单明细ID = Convert.ToInt32(dgvMingXi.CurrentRow.Cells["货运单明细ID"].Value);
dgvFenBao.DataSource = myFRM_PeiZaiFaHuoFenBaoClient.
dgvMingXi_SelectionChanged_SelectFenBao(int货运单明细ID).Tables[0];
dgvFenBao = PublicStaticMothd.SetDgv(dgvFenBao);
}
}
else
{
((DataTable)dgvFenBao.DataSource).Rows.Clear();
}
}
private void FRM_PeiZaiFaHuo_Load(object sender, EventArgs e)
{
this.Left = PublicStaticObject.MainLeft;
this.Top = PublicStaticObject.MainTop;
this.Width = PublicStaticObject.MainWidth;
this.Height = PublicStaticObject.MainHeight;
cboTuoYunFang.DataSource = myFRM_PeiZaiFaHuoFenBaoClient.FRM_PeiZaiFaHuo_Load_SelectKeHu().Tables[0];
cboTuoYunFang.DisplayMember = "客户全称";
cboTuoYunFang.ValueMember = "客户ID";
cboShouHuoFang.DataSource = myFRM_PeiZaiFaHuoFenBaoClient.FRM_PeiZaiFaHuo_Load_SelectKeHu().Tables[0];
cboShouHuoFang.DisplayMember = "客户全称";
cboShouHuoFang.ValueMember = "客户ID";
///btnChaXun_Select_Click_SelectDingDanXinXi是不定条件查询方法，条件为空即查询所有数据
dgvHuoYunDan.DataSource = myFRM_PeiZaiFaHuoFenBaoClient.btnChaXun_Select_Click_SelectDingDanXinXi().Tables[0];
dgvHuoYunDan = PublicStaticMothd.SetDgv(dgvHuoYunDan);
}
private void FRM_XianLuGuanLi_WangDianGuanLi_Update_Load(object sender, EventArgs e)
{
//给各个变量相应赋值
int网点ID = Convert.ToInt32(myDR.Cells["网点ID"].Value.ToString().Trim());
string 网点名称 = myDR.Cells["网点名称"].Value.ToString().Trim();
this.txtWangDianMingCheng.Text = 网点名称;
this.dgvXiangLinWangDian = PublicStaticMothd.SetDgv(dgvXiangLinWangDian);
//以网点ID为条件查询网点表格网点邻居表
DataTable dt = myFRM_XianLuGuanLi_WangDianGuanLi_UpdateClient.FRM_XianLuGuanLi_WangDianGuanLi_Update_Load_ChaXunWangDianXinXi(int网点ID).Tables[0];
DataTable dt2 = myFRM_XianLuGuanLi_WangDianGuanLi_UpdateClient.FRM_XianLuGuanLi_WangDianGuanLi_Update_Load_ChaXunWangDianXinXi_JvLi(int网点ID).Tables[0];
//实例化表对象并设置列的属性
DataTable dt3 = new DataTable();
DataColumn dc = new DataColumn();
dc = dt3.Columns.Add("选中否", Type.GetType("System.Boolean"));
dc = dt3.Columns.Add("网点ID", Type.GetType("System.Int32"));
dc = dt3.Columns.Add("网点名称", Type.GetType("System.String"));
dc = dt3.Columns.Add("距离", Type.GetType("System.String"));
//遍历网点表
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow newRow = dt3.NewRow();
newRow["网点ID"] = dt.Rows[i]["网点ID"].ToString().Trim();
newRow["网点名称"] = dt.Rows[i]["网点名称"].ToString().Trim();
//遍历网点邻居表
for (int j = 0; j < dt2.Rows.Count; j++)
{
if (dt.Rows[i]["网点ID"].ToString().Trim() == dt2.Rows[j]["相邻网点ID"].ToString().Trim())//如果网点表的网点ID与网店邻居表的相邻网店ID相等时：
{
//给行对象的单元格相应赋值
newRow["距离"] = dt2.Rows[j]["距离"].ToString().Trim();
newRow["选中否"] = true;
}
}
dt3.Rows.Add(newRow); //把行对象加到表对象李
}
this.dgvXiangLinWangDian.AllowUserToAddRows = false;
this.dgvXiangLinWangDian.AllowUserToResizeRows = false;
this.dgvXiangLinWangDian.DataSource = dt3;//绑定数据
停用否 = "false";
}
private void FRM_SiJiGuanLi_Load(object sender, EventArgs e)
{
bool b = 用户权限管理.authCheck.checkAuthByType(this,
System.Reflection.MethodBase.GetCurrentMethod().Name);
if (!b)
{
MessageBox.Show("没有该权限，请联系管理员！");
this.Close();
return;
}
this.Left = PublicStaticObject.MainLeft;
this.Top = PublicStaticObject.MainTop;
this.Width = PublicStaticObject.MainWidth;
this.Height = PublicStaticObject.MainHeight;
this.dgvDaoRu = PublicStaticMothd.SetDgv(dgvDaoRu);
dgvSiJiXinXi.AutoGenerateColumns = false;
System.Data.DataTable dt司机信息 = BLL_FRM_SiJiGuanLi.FRM_SiJiGuanLi_Load_ChaXunSiJiXinXi().Tables[0];
dsSiJiGuanLi1.Tables["dtSiJiXinXi"].Merge(dt司机信息);
}
private void FRM_XianLuGuanLi_Load(object sender, EventArgs e)
{
this.dgvXianLuWangDianXinXi = PublicStaticMothd.SetDgv(dgvXianLuWangDianXinXi);
this.dgvXianLuXinXi = PublicStaticMothd.SetDgv(dgvXianLuXinXi);
//设置窗体的位置和大小
this.Left = PublicStaticObject.MainLeft;
this.Top = PublicStaticObject.MainTop;
this.Width = PublicStaticObject.MainWidth;
this.Height = PublicStaticObject.MainHeight;
dgvXianLuXinXi.AutoGenerateColumns = false;
this.dgvXianLuWangDianXinXi.AutoGenerateColumns = false;
DataTable dt = myFRM_XianLuGuanLi_InsertClient.FRM_XianLuGuanLi_Insert_Load_ChaXunWangDianXinXi().Tables[0]; //查询所有网点
DataTable dt2 = dt.Copy(); //复制dtWangDian再赋值给dtWangDian2
this.cboQiShiWangDian.DataSource = dt; //设定cboQiShiWangDian的数据源为dtWangDian
this.cboQiShiWangDian.DisplayMember = "网点名称"; //设定cboQiShiWangDian的显示成员为列名为“网点名称”的列
this.cboQiShiWangDian.ValueMember = "网点ID"; //设定cboQiShiWangDian的值成员为列名为“网点ID”的列
this.cboJieShuWangDian.DataSource = dt2;
this.cboJieShuWangDian.DisplayMember = "网点名称";
this.cboJieShuWangDian.ValueMember = "网点ID";
dgvXianLuXinXi.DataSource = myFRM_XianLuGuanLiClient.FRM_XianLuGuanLi_Load_ChaXunQuanBuXianLu().Tables[0];//查询所有线路并绑定到dgv
}
private void FRM_DaoDaDengJi_Load(object sender, EventArgs e)
{
#region 定义窗体位置、窗体大小
this.Left = PublicStaticObject.MainLeft;
this.Top = PublicStaticObject.MainTop;
this.Width = PublicStaticObject.MainWidth;
this.Height = PublicStaticObject.MainHeight;
#endregion
dgvCheLiangPeiZaiXinXi.AllowUserToAddRows = false;
DataTable dtWangDian = myFRM_DaoDaDengJiClient.
FRM_DaoDaDengJi_Load_ChaXunWangDian().Tables[0];
DataTable dtWangDian2 = dtWangDian.Copy();
DataTable dtWangDian3 = dtWangDian.Copy();
DataTable dtZhuangTai = myFRM_DaoDaDengJiClient.
FRM_DaoDaDengJi_Load_ChaXunZhuangTai().Tables[0];
//绑定起始网点
cboKaiShi.DataSource = dtWangDian;
cboKaiShi.DisplayMember = "网点名称";
cboKaiShi.ValueMember = "网点ID";
//绑定目标网点
cboJieShu.DataSource = dtWangDian2;
cboJieShu.DisplayMember = "网点名称";
cboJieShu.ValueMember = "网点ID";
//绑定状态
cboZhuangTai.DataSource = dtZhuangTai;
cboZhuangTai.DisplayMember = "状态";
cboZhuangTai.ValueMember = "状态ID";
//绑定到达网点
this.cboDaoDa.DataSource = dtWangDian3;
cboDaoDa.DisplayMember = "网点名称";
cboDaoDa.ValueMember = "网点ID";
//绑定车辆配载信息dgv
dgvCheLiangPeiZaiXinXi = PublicStaticMothd.SetDgv(dgvCheLiangPeiZaiXinXi);
dtCheLiang = myFRM_DaoDaDengJiClient.
FRM_DaoDaDengJi_Load_ChaXunQuanBuCheLiang().Tables[0]; //查询车辆表
createPictuerBoxstrCarList(dtCheLiang);
}
private void FRM_PeiZaiFaHuoPeiZai_Load(object sender, EventArgs e)
{
#region 定义窗体位置、窗体大小
this.Left = PublicStaticObject.MainLeft;
this.Top = PublicStaticObject.MainTop;
this.Width = PublicStaticObject.MainWidth;
this.Height = PublicStaticObject.MainHeight;
#endregion
#region 加载配载发车单dgv和配载发车明细单dgv
dtpJieShu.Value = dtpJieShu.Value.AddDays(1);
this.dgvPeiZaiFaCheDan = PublicStaticMothd.SetDgv(dgvPeiZaiFaCheDan);
this.dgvPeiZaiFaCheMingXi = PublicStaticMothd.SetDgv(dgvPeiZaiFaCheMingXi);
dtFaCheZhuangTai = myPeiZaiFaHuoPeiZaiClient.FRM_PeiZaiFaHuoPeiZai_Load_SelectFaCheZhuangTai().Tables[0];
#endregion
#region 查询配载发货单表
DataTable dtPeiZaiFaHuoDan = myPeiZaiFaHuoPeiZaiClient.FRM_PeiZaiFaHuoPeiZai_selectPeiZaiFaHuoDan().Tables[0];
dgvPeiZaiFaCheDan.DataSource = dtPeiZaiFaHuoDan;
//加载车辆状态
DataTable dtFACheZhuangTai = myPeiZaiFaHuoPeiZaiClient.FRM_PeiZaiFaHuoPeiZai_SelectCboFaCheZhaungTai().Tables[0];
cboZhuangTai.DataSource = dtFACheZhuangTai;
cboZhuangTai.DisplayMember = "发车状态";
cboZhuangTai.ValueMember = "发车状态ID";
#endregion
}
private void FRM_BaoBiaoDingDanLiuLan_Load(object sender, EventArgs e)
{
this.dgvDingDan = PublicStaticMothd.SetDgv(dgvDingDan);
this.dgvMingXi = PublicStaticMothd.SetDgv(dgvMingXi);
}
private void FRM_DingDanGuanLi_Load(object sender, EventArgs e)
{
try
{
#region 设置窗体位置和窗体大小
dgvDingDanXinXi.AutoGenerateColumns = false;
this.Left = PublicStaticObject.MainLeft;
this.Top = PublicStaticObject.MainTop;
this.Width = PublicStaticObject.MainWidth;
this.Height = PublicStaticObject.MainHeight;
#endregion
#region 绑定数据
dttmpkDaoDaShiJian.Value = dttmpkQiShiShiJian.Value.AddDays(1);
//绑定到达时间为起始时间加一天
this.dgvDingDanXinXi = PublicStaticMothd.SetDgv(dgvDingDanXinXi);
//绑定订单信息DGV
this.dgvDingDanXinXiMingXi = PublicStaticMothd.SetDgv(dgvDingDanXinXiMingXi);
//绑定订单明细信息DGV
#region 绑定货物名称、揽收状态、收件客户名称、寄件客户名称
//绑定货物名称下拉框
cboHuoMing.DataSource = myDingDanGuanLi.FRM_DingDanGuanLi_Load_SelectHuoMing().Tables[0];
cboHuoMing.DisplayMember = "货物名称";
cboHuoMing.ValueMember = "货物ID";
//绑定货物揽收状态下拉框
cboZhuangTai.DataSource = myDingDanGuanLi.FRM_DingDanGuanLi_Load_SelectZhuangTai().Tables[0];
cboZhuangTai.DisplayMember = "货物揽收状态";
cboZhuangTai.ValueMember = "货物揽收状态ID";
//绑定收货方客户名称
DataTable dtKeHu = myDingDanGuanLi.FRM_DingDanGuanLi_Load_SelectKeHu().Tables[0];
cboShouHuoFang.DataSource = dtKeHu;
cboShouHuoFang.DisplayMember = "客户全称";
cboShouHuoFang.ValueMember = "客户ID";
//绑定托运方客户名称
cboTuoYunFang.DataSource = dtKeHu.Copy();
//cboTuoYunFang.DataSource = myDingDanGuanLi.FRM_DingDanGuanLi_Load_SelectKeHu().Tables[0];
cboTuoYunFang.DisplayMember = "客户全称";
cboTuoYunFang.ValueMember = "客户ID";
#endregion
#endregion
#region 初始化查询全部订单信息，并根据页面大小进行分页
//查询全部订单
DataTable dt =
myDingDanGuanLi.FRM_DingDanGuanLi_Load_SelectHuoYunDanByFenYe(页面大小, 页码).Tables[0];
dgvDingDanXinXi.DataSource = dt;
货运单总数 = myDingDanGuanLi.FRM_DingDanGuanLi_Load_SelectHuoYunDanCount();
最大页码 = 货运单总数 / 页面大小;
if (货运单总数 % 页面大小 > 0)
{
最大页码++;
}
lblTotalPage.Text = 最大页码.ToString();
lblCurrentPage.Text = 页码.ToString();
lblDanJuShu.Text = 货运单总数.ToString();
SheZhiSuoDingAnNiu();
#endregion
}
catch
{
}
}
private void FRM_WuLiuXinXiChaXun_Load(object sender, EventArgs e)
{
dgvWuLiuGenZong = PublicStaticMothd.SetDgv(dgvWuLiuGenZong);
}
private void FRM_PeiZaiFaHuoPeiZai_Update_Load(object sender, EventArgs e)
{
#region 拉框的绑定
//加载起始网点下拉框
DataTable dtFaHuoWangDian =
myPeiZaiFaHuoPeiZai_UpdateClient.frmPeiZaiFaHuo_Insert_SelectcboWiangDian().Tables[0];
cboFaHuoWangDian.DataSource = dtFaHuoWangDian;
cboFaHuoWangDian.DisplayMember = "网点名称";
cboFaHuoWangDian.ValueMember = "网点ID";
//加载目的网点下拉框
DataTable dtMuDiWangDian =
myPeiZaiFaHuoPeiZai_UpdateClient.frmPeiZaiFaHuo_Insert_SelectcboWiangDian().Tables[0];
cboMuDiWangDian.DataSource = dtMuDiWangDian;
cboMuDiWangDian.DisplayMember = "网点名称";
cboMuDiWangDian.ValueMember = "网点ID";
//加载线路下拉框
DataTable dtXianLu =
myPeiZaiFaHuoPeiZai_UpdateClient.frmPeiZaiFaHuo_Insert_SelectcboXianLu().Tables[0];
cboXianLuXuanZhe.DataSource = dtXianLu;
cboXianLuXuanZhe.DisplayMember = "线路名称";
cboXianLuXuanZhe.ValueMember = "线路ID";
#endregion
//加载配载发货dgv
this.dgvPeiZaiFaHuoMingXi = PublicStaticMothd.SetDgv(dgvPeiZaiFaHuoMingXi);
dgvPeiZaiFaHuoMingXi.ReadOnly = false;
this.dgvSiJi = PublicStaticMothd.SetDgv(dgvSiJi);
dgvPeiZaiFaHuoMingXi.RowHeadersVisible = false;
DataTable dtFaCheDan =
myPeiZaiFaHuoPeiZai_UpdateClient.
FRM_PeiZaiFaHuoPeiZai_SelectPeiZaiFaHuoDanBYPeiZaiFaHuoDanID(PeiZaiFaCheDanID).Tables[0];
DataTable dtCheliang =
myPeiZaiFaHuoPeiZai_UpdateClient.
frmPeiZaiFaHuo_Update_SelectcboCheLiang(Convert.ToInt32(dtFaCheDan.Rows[0]["车辆ID"].ToString())).Tables[0];
//加载车辆信息下拉框
cboXuanZheCheLiang.DataSource = dtCheliang;
cboXuanZheCheLiang.DisplayMember = "车牌号";
cboXuanZheCheLiang.ValueMember = "车辆ID";
PeiZaiFaHuoDanID = Convert.ToInt32(dtFaCheDan.Rows[0]["配载发车单ID"].ToString());
btnPeiZaiFaHuoDanBianHao.Text = dtFaCheDan.Rows[0]["配载发车单号"].ToString();
cboFaHuoWangDian.SelectedValue = dtFaCheDan.Rows[0]["始发网点ID"].ToString();
cboMuDiWangDian.SelectedValue = dtFaCheDan.Rows[0]["目的网点ID"].ToString();
cboXianLuXuanZhe.SelectedValue = dtFaCheDan.Rows[0]["线路ID"].ToString();
if (Convert.ToInt32(dtFaCheDan.Rows[0]["发车状态ID"].ToString()) == 1)
{
cboXuanZheCheLiang.Enabled = false;
}
else
{
cboXuanZheCheLiang.Enabled = true;
}
cboXuanZheCheLiang.SelectedValue = dtFaCheDan.Rows[0]["车辆ID"].ToString();
SiJiID = Convert.ToInt32(dtFaCheDan.Rows[0]["司机ID"].ToString());
CheLiangID = Convert.ToInt32(dtFaCheDan.Rows[0]["车辆ID"].ToString());
txtSiJiXingMing.Text = dtFaCheDan.Rows[0]["司机名称"].ToString();
txtLianXieDanHua.Text = dtFaCheDan.Rows[0]["联系电话"].ToString();
DataTable dtMingXi =
myPeiZaiFaHuoPeiZai_UpdateClient.
FRM_PeiZaiFaHuoPeiZai_selectPeiZaiFaHuoDanMingXiByFaHuoDanID(PeiZaiFaCheDanID).Tables[0];
for (int i = 0; i < dtMingXi.Rows.Count; i++)
{
dgvPeiZaiFaHuoMingXi.Rows.Add();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["配载发车单明细ID"].Value = dtMingXi.Rows[i]["配载发车单明细ID"].ToString();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["分包ID"].Value = dtMingXi.Rows[i]["分包ID"].ToString();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["货物名称"].Value = dtMingXi.Rows[i]["货物名称"].ToString();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["货物类别"].Value = dtMingXi.Rows[i]["货物类别"].ToString();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["计量单位"].Value = dtMingXi.Rows[i]["计量单位"].ToString();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["分包数量"].Value = dtMingXi.Rows[i]["分包数量"].ToString();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["寄件网点"].Value = dtMingXi.Rows[i]["寄件网点"].ToString();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["目的网点"].Value = dtMingXi.Rows[i]["目的网点"].ToString();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["单据编号"].Value = dtMingXi.Rows[i]["单据编号"].ToString();
dgvPeiZaiFaHuoMingXi.Rows[i].Cells["运费单价"].Value = dtMingXi.Rows[i]["运费单价"].ToString();
Count++;
}
FenBaoID = new int[Count];
bolStartFinish = true;
}
