/// <summary> /// 新增按钮跳转 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddJSY_Click(object sender, EventArgs e) { if (UserTbale == "StaffInfo") { StaffInfoForm sff = new StaffInfoForm(); sff.Show(); } else if (UserTbale == "CustomerInfo") { CustomerInfoForm form = new CustomerInfoForm(); form.Show(); } else { } }
/// <summary> /// 点击确定按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { try { //查询驾驶员姓名 if (UserTbale == "StaffInfo") { if (listboxStaff_Names.Visible) { //调用事件 listboxStaff_Name_DoubleClick(sender, e); this.Visible = false; listboxStaff_Names.DataSource = null; chkListBoxs.Visible = false; return; } chkListBoxs.SendToBack(); if (chkListBoxs.SelectedItems.Count > 0) { string stafnames = "";//驾驶员名称 ListstaffInfo = new List <string>(); foreach (var item in chkListBoxs.CheckedItems) { ListstaffInfo.Add(item.ToString()); //驾驶员名称集合 staffInfo_Name += item.ToString() + ","; //驾驶员名称 stafnames += "'" + item.ToString() + "',"; } if (staffInfo_Name != null) { //当用户选择驾驶员名称后显示同名的ID listboxStaff_Names.Visible = true; } if (ListstaffInfo.Count() > 0) { //staffInfo_Id = ""; foreach (var item in ListstaffInfo) { string sql = "Select * from " + UserTbale + " where " + UserWhere + " and " + Field + "='" + item + "'"; DataSet ds = LinQBaseDao.Query(sql); if (UserTbale == "StaffInfo") { if (ds.Tables[0].Rows.Count <= 0) { DialogResult digresult = MessageBox.Show("不存在该驾驶员,是否进行登记?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (DialogResult.OK == digresult) { StaffInfoForm sff = new StaffInfoForm(); sff.Show(); } else { staffInfo_Name = ""; return; } } } else { } if (!string.IsNullOrEmpty(StaffInfo_identitys)) { if (ds.Tables[0].Rows.Count > 1)//如存在相同名称的驾驶员,则显示驾驶员身份证,根据身份证确定驾驶员信息 { groupBox1.Visible = true; listboxStaff_Names.Visible = true; listboxStaff_Names.DataSource = ds.Tables[0]; listboxStaff_Names.ValueMember = Fields; listboxStaff_Names.DisplayMember = StaffInfo_identitys; listboxStaff_Names.BringToFront(); } else { staffInfo_Id += ds.Tables[0].Rows[0][0] + ","; this.Visible = false; } } } } } } else if (UserTbale == "CustomerInfo") { /////////////////查询公司名/////////////////////////////// CustomerInfo_GName = ""; if (listboxStaff_Names.Visible) { //调用事件 listboxStaff_Name_DoubleClick(sender, e); this.Visible = false; listboxStaff_Names.DataSource = null; return; } chkListBoxs.SendToBack(); if (chkListBoxs.SelectedItems.Count > 0) { string stafnames = "";//变量名称 ListstaffInfo = new List <string>(); foreach (var item in chkListBoxs.CheckedItems) { ListstaffInfo.Add(item.ToString()); //公司名称集合 staffInfo_Name += item.ToString() + ","; //公司名称 stafnames += "'" + item.ToString() + "',"; } if (staffInfo_Name != null) { //当用户选择驾驶员名称后显示同名的ID listboxStaff_Names.Visible = true; } if (ListstaffInfo.Count() > 0) { //staffInfo_Id = ""; foreach (var item in ListstaffInfo) { string sql = "Select * from " + UserTbale + " where " + UserWhere + " and " + Field + "='" + item + "'"; DataSet ds = LinQBaseDao.Query(sql); if (ds.Tables[0].Rows.Count <= 0) { DialogResult digresult = MessageBox.Show("不存在该驾驶员,是否进行登记?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (DialogResult.OK == digresult) { StaffInfoForm sff = new StaffInfoForm(); sff.Show(); } else { staffInfo_Name = ""; return; } } else { } } } } } } catch { } }
/// <summary> /// 单击新增按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddJSY_Click(object sender, EventArgs e) { StaffInfoForm form = new StaffInfoForm(); form.Show(); }