1 using drp.Common; 2 using drp.DB; 3 using System; 4 using System.Collections; 5 using System.Collections.Generic; 6 using System.ComponentModel; 7 using System.Data; 8 using System.Drawing; 9 using System.Linq; 10 using System.Reflection; 11 using System.Text; 12 using System.Threading.Tasks; 13 using System.Windows.Forms; 14 15 namespace drp 16 { 17 public partial class FrmClient : Form 18 { 19 DataTable dtList; 20 DataTable dtLevel1, dtLevel2, dtType1, dtType2; 21 BindingSource bs = new BindingSource(); 22 string strColumns; 23 //是否添加状态 24 int addFlag = 0; 25 //判断类型下拉框的值是否改变 26 string oriCategory2, oriLevel1, oriLevel2; 27 int i = 0; 28 29 public FrmClient() 30 { 31 //1、设置窗体的双缓冲,为解决表卡顿问题 32 this.SetStyle(ControlStyles.OptimizedDoubleBuffer | ControlStyles.ResizeRedraw | ControlStyles.AllPaintingInWmPaint, true); 33 this.UpdateStyles(); 34 35 InitializeComponent(); 36 //2、利用反射设置DataGridView的双缓冲，为解决表卡顿问题 37 Type dgvType = this.dataGridView1.GetType(); 38 PropertyInfo pi = dgvType.GetProperty("DoubleBuffered", 39 BindingFlags.Instance | BindingFlags.NonPublic); 40 pi.SetValue(this.dataGridView1, true, null); 41 #region 初始化客户类型下拉列表 42 ArrayList mylist = new ArrayList(); 43 mylist.Add(new DictionaryEntry("0", "全部")); 44 mylist.Add(new DictionaryEntry("1", "商业")); 45 mylist.Add(new DictionaryEntry("3", "门店")); 46 mylist.Add(new DictionaryEntry("2", "医院")); 47 mylist.Add(new DictionaryEntry("6", "连锁总部")); 48 cbxCategory.DataSource = mylist; 49 cbxCategory.DisplayMember = "Value"; 50 cbxCategory.ValueMember = "Key"; 51 cbxCategory.SelectedIndex = 0; 52 #endregion 53 strColumns = " id, name, category, level1, regioncode, address, key1, key2, key3, key0, isflow, ischain, registerednumber"; 54 55 strColumns = @" id,name,category,regioncode,regionname,isflow,key1,level1,level2, 56 type1,type2,type3,depart1,depart2,depart3,depart4,depart5,key2,key3,key0,registerednumber, 57 alias1,alias2,sapid,address,pinyin,telphone,postcode,isagreement,ischain, 58 parentid,createby,createtime,modifyby,modifytime,note "; 59 60 } 61 62 private void button4_Click(object sender, EventArgs e) 63 { 64 this.Close(); 65 } 66 //详情页关闭按钮 67 private void button10_Click(object sender, EventArgs e) 68 { 69 this.Close(); 70 } 71 72 private void btnSearch_Click(object sender, EventArgs e) 73 { 74 string clientChar; 75 string sql; 76 string strWhere; 77 sql = "select " + strColumns; 78 sql += " from client where 1=1 "; 79 //名字关键字 80 strWhere = GetWhere(); 81 if (strWhere == "-1") 82 { 83 strWhere = ""; 84 txtName.Focus(); 85 return; 86 } 87 QueryData(sql + strWhere); 88 } 89 90 private void checkBox5_CheckedChanged(object sender, EventArgs e) 91 { 92 if (this.cbxDate.Checked == true) 93 { 94 dateBegin.Enabled = true; 95 dateEnd.Enabled = true; 96 } 97 else 98 { 99 dateBegin.Enabled = false; 100 dateEnd.Enabled = false; 101 } 102 } 103 104 //绑定数据至bindingnavigator1 105 private void BindData() 106 { 107 this.dataGridView1.Columns[0].DataPropertyName = dtList.Columns["id"].ToString(); 108 this.dataGridView1.Columns[1].DataPropertyName = dtList.Columns["name"].ToString(); 109 this.dataGridView1.Columns[2].DataPropertyName = dtList.Columns["category"].ToString(); 110 this.dataGridView1.Columns[3].DataPropertyName = dtList.Columns["regioncode"].ToString(); 111 this.dataGridView1.Columns[4].DataPropertyName = dtList.Columns["regionname"].ToString(); 112 this.dataGridView1.Columns[5].DataPropertyName = dtList.Columns["isflow"].ToString(); 113 this.dataGridView1.Columns[6].DataPropertyName = dtList.Columns["key1"].ToString(); 114 115 //客户ID 116 this.txtId2.DataBindings.Add("Text", bs, "id"); 117 //客户名称 118 this.txtName2.DataBindings.Add("Text", bs, "name"); 119 //机构代码证号 120 this.txtRegisteredNumber.DataBindings.Add("Text", bs, "registerednumber"); 121 //地址 122 this.txtAddress.DataBindings.Add("Text", bs, "address"); 123 //地区号 124 this.txtRegionCode.DataBindings.Add("Text", bs, "regioncode"); 125 this.txtRegionName.DataBindings.Add("Text", bs, "regionname"); 126 ; //创建时间 127 this.txtCreateTime.DataBindings.Add("Text", bs, "createtime"); 128 this.txtCreateBy.DataBindings.Add("Text", bs, "createby"); 129 this.txtModifyTime.DataBindings.Add("Text", bs, "modifytime"); 130 this.txtModifyBy.DataBindings.Add("Text", bs, "modifyby"); 131 this.txtAlia1.DataBindings.Add("Text", bs, "alias1"); 132 this.txtAlia2.DataBindings.Add("Text", bs, "alias2"); 133 this.txtKey1.DataBindings.Add("Text", bs, "key1"); 134 this.txtKey2.DataBindings.Add("Text", bs, "key2"); 135 this.txtKey3.DataBindings.Add("Text", bs, "key3"); 136 this.txtKey0.DataBindings.Add("Text", bs, "key0"); 137 this.cbxCategory2.DataBindings.Add("SelectedValue", bs, "category"); 138 this.cbxLevel1.DataBindings.Add("SelectedValue", bs, "level1"); 139 this.cbxLevel2.DataBindings.Add("SelectedValue", bs, "level2"); 140 this.cbxType1.DataBindings.Add("SelectedValue", bs, "type1"); 141 //是否发流向 142 this.lbIsflow.DataBindings.Add("Text", bs, "isflow"); 143 //是否连锁 144 this.lbIsChain.DataBindings.Add("Text", bs, "ischain"); 145 //是否协议客户 146 this.lbIsAgreement.DataBindings.Add("Text", bs, "isagreement"); 147 //(string)((DictionaryEntry)cbxCategory.SelectedItem).Key 148 } 149 //查询数据 150 private void QueryData(string sql) 151 { 152 dtList = DBHelperPg.ExecuteDataTable(sql); 153 bs.DataSource = dtList; 154 bindingNavigator1.BindingSource = bs; 155 dataGridView1.DataSource = bs; //把数据源绑定在dataGridView1上 156 //绑定每列的值显示在DatagridView 157 } 158 159 private void btnAdd_Click(object sender, EventArgs e) 160 { 161 162 } 163 164 private void btnSave_Click(object sender, EventArgs e) 165 { 166 if (addFlag == 1) 167 { 168 txtCreateBy.Text = GlobalParam.UserName; 169 txtCreateTime.Text = DateTime.Now.ToString(); 170 } 171 else 172 { 173 //接受修改 174 txtModifyBy.Text = GlobalParam.UserName; 175 txtModifyTime.Text = DateTime.Now.ToString(); 176 } 177 bs.EndEdit(); 178 DBHelperPg.UpdateDataTable(dtList, "client", strColumns); 179 MessageBox.Show("保存成功！"); 180 EditBoxState(false); 181 addFlag = 0; 182 //将保存按钮改为 不可用 183 this.btnSave.Enabled = false; 184 this.btnEdit.Enabled = true; 185 } 186 //取查询条件 187 private string GetWhere() 188 { 189 string clientChar; 190 string strWhere = ""; 191 //名字关键字 192 clientChar = txtName.Text.Trim(); 193 if (!(string.IsNullOrEmpty(clientChar)) && clientChar.Length > 0) 194 { 195 strWhere = " and name like '%" + clientChar + "%'"; 196 } 197 198 //判断客户编号 199 if (string.IsNullOrEmpty(txtId.Text.Trim())) 200 { 201 txtId.Text = "0"; 202 } 203 int clientId = Convert.ToInt32(txtId.Text.Trim()); 204 if (clientId != 0) 205 { 206 strWhere += " and id=" + txtId.Text.Trim(); 207 } 208 //判断客户大类,读取 key 和 value 209 string clientCategory = (string)((DictionaryEntry)cbxCategory.SelectedItem).Key; 210 if (clientCategory != "0") 211 { 212 strWhere += " and category ='" + clientCategory + "' "; 213 } 214 215 //判断地区编号 216 if (!string.IsNullOrEmpty(txtRegion.Text.Trim())) 217 { 218 string strRegionCode = txtRegion.Text.Trim(); 219 if (strRegionCode.Substring(4, 2) == "00") 220 221 { 222 //如果选的是上级，则用like 模糊查询 223 strRegionCode = strRegionCode.Replace("00", "%"); 224 strWhere += " and regioncode like '" + strRegionCode + "' "; 225 } 226 else 227 { 228 strWhere += " and regioncode='" + txtRegion.Text.Trim() + "' "; 229 } 230 231 } 232 //判断部门 233 if (!string.IsNullOrEmpty(txtDepart.Text.Trim())) 234 { 235 strWhere += " and (depart1='" + txtDepart.Text.Trim() + "' "; 236 strWhere += " or depart2 ='" + txtDepart.Text.Trim() + "') "; 237 238 } 239 if (cbxDate.Checked == true) 240 { 241 strWhere += " and createtime>='" + dateBegin.Text + "' "; 242 strWhere += " and createtime<='" + dateEnd.Text + "' "; 243 } 244 MessageBox.Show(strWhere); 245 return strWhere + " limit 200"; 246 } 247 //表单 load 事件 248 private void FrmClient_Load(object sender, EventArgs e) 249 { 250 //默认取前20条记录 251 // BindData("select id,name, category,level1,regioncode,address,key1,key2,key3,key0,isflow,ischain,registerednumber from client limit 10 "); 252 QueryData("select " + strColumns + " from client limit 20 "); 253 BindData(); 254 255 BindCategory2(); 256 //将详情页的文本框下拉框等设置为不能修改 257 EditBoxState(false); 258 BindLevel1(); 259 this.btnSave.Enabled = false; 260 261 } 262 263 //编辑按钮 264 private void btnEdit_Click(object sender, EventArgs e) 265 { 266 if (addFlag == 1) 267 { 268 MessageBox.Show("正在添加数据，请保存再使用；"); 269 } 270 271 EditBoxState(true); 272 this.btnEdit.Enabled = false; 273 this.btnSave.Enabled = true; 274 //清空文本框 275 //ClearBox(); 276 } 277 278 //绑定客户类型 2 Category2 279 private void BindCategory2() 280 { 281 DataTable dt = new DataTable(); 282 DataColumn dc1 = new DataColumn("id"); 283 DataColumn dc2 = new DataColumn("name"); 284 dt.Columns.Add(dc1); 285 dt.Columns.Add(dc2); 286 287 DataRow dr1 = dt.NewRow(); 288 dr1["id"] = 1; 289 dr1["name"] = "商业"; 290 291 DataRow dr2 = dt.NewRow(); 292 dr2["id"] = 2; 293 dr2["name"] = "医院"; 294 295 DataRow dr3 = dt.NewRow(); 296 dr3["id"] = 3; 297 dr3["name"] = "门店"; 298 DataRow dr4 = dt.NewRow(); 299 dr4["id"] = 6; 300 dr4["name"] = "连锁总部"; 301 dt.Rows.Add(dr1); 302 dt.Rows.Add(dr2); 303 dt.Rows.Add(dr3); 304 dt.Rows.Add(dr4); 305 306 cbxCategory2.DataSource = dt; 307 cbxCategory2.ValueMember = "id"; 308 cbxCategory2.DisplayMember = "name"; 309 } 310 //页签切换事件，用来更改商业 ，医院，门店等 不同的分类LABELA名字 311 private void tcClient_SelectedIndexChanged(object sender, EventArgs e) 312 { 313 switch (this.tcClient.SelectedIndex) 314 { 315 case 0: 316 break; 317 case 1: 318 switch (cbxCategory2.Text) 319 { 320 case "商业": 321 break; 322 case "医院": 323 break; 324 } 325 break; 326 327 } 328 //因为数据库设计的是0/1，而checkbox要求是true/false,暂未好的办法 329 if (lbIsflow.Text == "1") //是否发流向 330 { 331 chkIsflow.Checked = true; 332 } 333 else 334 { 335 chkIsflow.Checked = false; 336 } 337 if (lbIsChain.Text == "1") //是否连锁 338 { 339 chkIsChain.Checked = true; 340 } 341 else 342 { 343 chkIsChain.Checked = false; 344 } 345 if (lbIsAgreement.Text == "1") //是否协议 346 { 347 chkIsAgreement.Checked = true; 348 } 349 else 350 { 351 chkIsAgreement.Checked = false; 352 } 353 354 } 355 356 private void chkIsflow_CheckedChanged(object sender, EventArgs e) 357 { 358 if (chkIsflow.Checked == true) //是否发流向 359 { 360 lbIsflow.Text = "1"; 361 } 362 else 363 { 364 lbIsflow.Text = "0"; 365 } 366 } 367 368 private void chkIsChain_CheckedChanged(object sender, EventArgs e) 369 { 370 if (chkIsChain.Checked == true) //是否连锁 371 { 372 lbIsChain.Text = "1"; 373 } 374 else 375 { 376 lbIsChain.Text = "0"; 377 } 378 } 379 380 private void chkIsAgreement_CheckedChanged(object sender, EventArgs e) 381 { 382 if (chkIsAgreement.Checked == true) //是否协议客户 383 { 384 lbIsAgreement.Text = "1"; 385 } 386 else 387 { 388 lbIsAgreement.Text = "0"; 389 } 390 } 391 392 //获取指定容器控件，控制字段编辑或修改 393 private void ClearBox() 394 { 395 396 foreach (Control c in this.groupBox1.Controls) 397 { 398 if (c.GetType().ToString().Contains("TextBox")) 399 { 400 ((TextBox)c).Text = ""; 401 MessageBox.Show(c.GetType().ToString()); 402 } 403 if (c.GetType().ToString().Contains("ComboBox")) 404 { 405 ((ComboBox)c).Text = ""; 406 } 407 if (c.GetType().ToString().Contains("CheckBox")) 408 { 409 ((CheckBox)c).Checked = false; 410 } 411 } 412 } 413 //导航栏的删除事件，重写；首先要在bindingNavigator属性中，删除DeleteItem方法 414 private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) 415 { 416 if (MessageBox.Show("确认删除吗？", "删除前确认", MessageBoxButtons.OKCancel) == DialogResult.OK) 417 { 418 dtList.Rows[bindingNavigator1.BindingSource.Position].Delete(); 419 } 420 } 421 422 private void btnDelete_Click(object sender, EventArgs e) 423 { 424 425 } 426 //添加按钮 427 private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) 428 { 429 addFlag = 1; 430 //将所有文本框置为可以修改 431 EditBoxState(true); 432 this.btnSave.Enabled = true; 433 this.cbxLevel1.Enabled = false; 434 this.cbxLevel2.Enabled = false; 435 this.cbxType1.Enabled = true; 436 this.cbxType2.Enabled = true; 437 438 } 439 //更改文本框，下拉框，复选框的Enableed状态； 440 private void EditBoxState(bool bl) 441 { 442 foreach (Control c in this.groupBox1.Controls) 443 { 444 if (c.GetType().ToString().Contains("TextBox")) 445 { 446 ((TextBox)c).Enabled = bl; 447 } 448 if (c.GetType().ToString().Contains("ComboBox")) 449 { 450 ((ComboBox)c).Enabled = bl; 451 } 452 if (c.GetType().ToString().Contains("CheckBox")) 453 { 454 ((CheckBox)c).Enabled = bl; 455 } 456 } 457 } 458 459 460 //地区选择 461 private void txtRegionCode_DoubleClick(object sender, EventArgs e) 462 { 463 FrmSelectRegion frmSelectRegion = new FrmSelectRegion(); 464 if (frmSelectRegion.ShowDialog() == DialogResult.OK) 465 { 466 txtRegionCode.Text = frmSelectRegion.regionId; 467 txtRegionName.Text = frmSelectRegion.regionName; 468 frmSelectRegion.Close(); 469 } 470 } 471 472 473 474 475 476 private void textBox4_DoubleClick(object sender, EventArgs e) 477 { 478 FrmSelectDepart frmSelectDepart = new FrmSelectDepart(); 479 if (frmSelectDepart.ShowDialog() == DialogResult.OK) 480 { 481 txtDepart1.Text = frmSelectDepart.departId; 482 lbDepart1Name.Text = frmSelectDepart.departName; 483 frmSelectDepart.Close(); 484 } 485 } 486 //临床部选择 487 private void txtDepart2_DoubleClick(object sender, EventArgs e) 488 { 489 FrmSelectDepart frmSelectDepart = new FrmSelectDepart(); 490 if (frmSelectDepart.ShowDialog() == DialogResult.OK) 491 { 492 txtDepart2.Text = frmSelectDepart.departId; 493 lbDepart2Name.Text = frmSelectDepart.departName; 494 frmSelectDepart.Close(); 495 } 496 497 } 498 499 private void txtRegion_DoubleClick(object sender, EventArgs e) 500 { 501 FrmSelectRegion frmSelectRegion = new FrmSelectRegion(); 502 if (frmSelectRegion.ShowDialog() == DialogResult.OK) 503 { 504 txtRegion.Text = frmSelectRegion.regionId; 505 frmSelectRegion.Close(); 506 } 507 } 508 509 private void txtDepart_TextChanged(object sender, EventArgs e) 510 { 511 512 } 513 514 private void txtDepart_DoubleClick(object sender, EventArgs e) 515 { 516 FrmSelectDepart frmSelectDepart = new FrmSelectDepart(); 517 if (frmSelectDepart.ShowDialog() == DialogResult.OK) 518 { 519 txtDepart.Text = frmSelectDepart.departId; 520 frmSelectDepart.Close(); 521 } 522 } 523 private void BindLevel1() 524 { 525 //根据客户大类的不同，而联动改变 526 527 string sql = " select code,name,parentid from client_category "; 528 dtLevel1 = DBHelperPg.ExecuteDataTable(sql); 529 dtLevel2 = dtLevel1; 530 531 cbxLevel1.DataSource = dtLevel1; 532 cbxLevel1.DisplayMember = "name"; 533 cbxLevel1.ValueMember = "code"; 534 535 536 cbxLevel2.DataSource = dtLevel1; 537 cbxLevel2.DisplayMember = "name"; 538 cbxLevel2.ValueMember = "code"; 539 } 540 541 private void cbxCategory2_Click(object sender, EventArgs e) 542 { 543 //保存原始值，用来判断后面的下拉框 用不用更新 544 oriCategory2 = cbxCategory2.Text; 545 } 546 547 private void btnStop_Click(object sender, EventArgs e) 548 { 549 550 } 551 552 private void cbxCategory2_SelectedIndexChanged(object sender, EventArgs e) 553 { 554 } 555 556 private void cbxLevel1_SelectedIndexChanged(object sender, EventArgs e) 557 { 558 } 559 560 private void cbxLevel1_Click(object sender, EventArgs e) 561 { 562 oriLevel1 = cbxLevel1.Text; 563 } 564 565 private void cbxLevel1_Leave(object sender, EventArgs e) 566 { 567 568 } 569 570 private void cbxLevel1_SelectionChangeCommitted(object sender, EventArgs e) 571 { 572 string parentId; 573 try 574 { 575 DataRowView drv = (DataRowView)cbxLevel1.SelectedItem; 576 parentId = drv.Row["code"].ToString(); 577 //数据库结构错误，只能多用SQL来弥补 :) :( ,此处因为ID与CODE不分，徘徊良久，是为记； 578 //parentId 其实取的是CODE值； 579 if (parentId == "System.Data.DataRowView") 580 { 581 return; 582 } 583 584 string sql = "select id from client_category where code='" + parentId + "'"; 585 parentId = DBHelperPg.ExecuteScalar(sql).ToString(); 586 string strFilter = "parentid = " + parentId + " "; 587 DataView dv2 = new DataView(dtLevel1); 588 dv2.RowFilter = strFilter; 589 cbxLevel2.DataSource = dv2; 590 cbxLevel2.DisplayMember = "name"; 591 cbxLevel2.ValueMember = "code"; 592 cbxLevel2.Enabled = true; 593 cbxLevel2.Text = ""; 594 } 595 catch 596 { 597 598 } 599 } 600 601 private void cbxCategory2_SelectionChangeCommitted(object sender, EventArgs e) 602 { 603 //根据客户大类的不同，而联动改变 604 string parentId; 605 try 606 { 607 //parentId = cbxCategory2.SelectedValue.ToString(); 608 DataRowView drv = (DataRowView)cbxCategory2.SelectedItem; 609 parentId = drv.Row["id"].ToString(); 610 } 611 catch 612 { 613 //新建时出错，无法处理 614 parentId = "0"; 615 } 616 string strFilter = "parentid = " + parentId; 617 DataView dv = new DataView(dtLevel1); 618 dv.RowFilter = strFilter; 619 cbxLevel1.DataSource = dv; 620 621 cbxLevel1.Enabled = true; 622 cbxLevel1.Text = ""; 623 cbxLevel2.Text = ""; 624 cbxLevel1.Focus(); 625 cbxLevel1.Refresh(); 626 } 627 628 //主类型下拉框，鼠标离开事件 629 private void cbxCategory2_Leave(object sender, EventArgs e) 630 { 631 632 } 633 634 private void cbxCategory2_Enter(object sender, EventArgs e) 635 { 636 oriCategory2 = this.cbxCategory2.Text; 637 } 638 639 //分类1变动事件 640 private void cbxLevel1_SelectedValueChanged(object sender, EventArgs e) 641 { 642 643 644 } 645 646 647 648 //表格自动编号 649 private void dataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e) 650 { 651 //自动编号，与数据无关 652 Rectangle rectangle = new Rectangle(e.RowBounds.Location.X, 653 e.RowBounds.Location.Y, 654 dataGridView1.RowHeadersWidth - 4, 655 e.RowBounds.Height); 656 TextRenderer.DrawText(e.Graphics, 657 (e.RowIndex + 1).ToString(), 658 dataGridView1.RowHeadersDefaultCellStyle.Font, 659 rectangle, 660 dataGridView1.RowHeadersDefaultCellStyle.ForeColor, 661 TextFormatFlags.VerticalCenter | TextFormatFlags.Right); 662 } 663 664 private void cbxCategory2_SelectedValueChanged(object sender, EventArgs e) 665 { 666 } 667 668 669 670 671 672 } 673 }