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