private void btnQuery_Click(object sender, System.EventArgs e) { //查询 try { //this.btnInlose.Enabled = true; string strSql = "select " + " cnvcMemberCardNo,cnvcMemberPwd,cnvcMemberName,cnvcPaperNo,cnvcCorporation, " + " cnvcCompanyAddress,cnvcLinkman,cnvcLinkPhone,cnvcEmail,cnvcFax,cnvcComments,cnvcMemberRight,cnvcEnterpriseType,cnvcDiscount,cnvcFree,cnvcFree as cnvcOldFree,cnvcProduct,cnvcState,cnnMemberFee, " + " cnnPrepay,cndEndDate,cnvcOperName,cndOperDate,cnvcMobileTelePhone,cnvcPostalCode,cnvcSales,cnvcHandleman,cnvcHandlemanPaperNo, " + " cnvcTrade,cnvcCustomerService,cnvcCustomerService as cnvcOldCustomerService " + " ,case cniSynch " + " when 0 then '会员系统' " + " when 1 then '网站操作' " + " when 2 then '触摸屏操作' " + " when 3 then '客服预定' " + " end cnvcSynch,cndInNetDate from tbMember where Len(cnvcMemberCardNo)=8 and cnvcState='" + ConstApp.Card_State_InUse + "' "; if (txtMemberCardNo.Text.Trim().Length > 0) { strSql += " and cnvcMemberCardNo like '%" + txtMemberCardNo.Text + "%'"; } if (txtMemberName.Text.Trim().Length > 0) { strSql += " and cnvcMemberName like '%" + txtMemberName.Text + "%'"; } if (txtPaperNo.Text.Trim().Length > 0) { strSql += " and cnvcPaperNo like '%" + txtPaperNo.Text + "%'"; } // if (cmbState.Text.Trim().Length > 0) // { // strSql += " and cnvcState = '"+cmbState.Text+"'"; // } if (cmbEnterpriseType.Text.Trim().Length > 0) { strSql += " and cnvcEnterpriseType like '%" + cmbEnterpriseType.Text + "%'"; } if (cmbTrade.Text.Trim().Length > 0) { strSql += " and cnvcTrade like '%" + cmbTrade.Text + "%'"; } if (txtSales.Text.Trim().Length > 0) { strSql += " and cnvcSales like '%" + txtSales.Text + "%'"; } if (txtCustomerService.Text.Trim().Length > 0) { strSql += " and cnvcCustomerService like '%" + txtCustomerService.Text + "%'"; } if (chkEndDate.Checked) { string strEndDate = ""; string aa = cmbEndDate.Text.Trim(); if (DateTime.Parse(aa).Month < 10) { strEndDate = DateTime.Parse(aa).Year.ToString() + "-" + "0" + DateTime.Parse(aa).Month.ToString(); } else { strEndDate = DateTime.Parse(aa).Year.ToString() + "-" + DateTime.Parse(aa).Month.ToString(); } if (DateTime.Parse(aa).Day < 10) { strEndDate += "-" + "0" + DateTime.Parse(aa).Day.ToString(); } else { strEndDate += "-" + DateTime.Parse(aa).Day.ToString(); } strSql += " and cndEndDate < = '" + strEndDate + "' "; } if (chkBeginDate.Checked) { strSql += " and cndInNetDate >='" + cmdBeginDate.Text + "'"; } if (chkEndDate2.Checked) { strSql += " and cndInNetDate <='" + cmbEndDate2.Text + "'"; } if (cmbMemberRight.Text.Trim().Length > 0) { strSql += " and cnvcMemberRight = '" + cmbMemberRight.Text + "'"; } Query query = new Query(); DataTable dtMember = query.Report(strSql); this.ultraGrid1.DataSource = null; this.ultraGrid1.DataSource = dtMember; this.ultraGrid1.DataBind(); ClientHelper.AddGridColumn(this.ultraGrid1, this.oper.cnvcOperName); Helper.AddGridSummary(this.ultraGrid1, SummaryType.Count, "{0}", 0); } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnExcel_Click(object sender, System.EventArgs e) { ClientHelper.ExportExcel(saveFileDialog1, ultraGridExcelExporter1, this.ultraGrid1, "云南人才市场会员档案报表", this.oper.cnvcOperName); }
private void MemberFileQuery_Load(object sender, System.EventArgs e) { // //绑定会员状态 // DataTable dtState = new DataTable(); // //dtState.Columns.Add("cnvcState"); // dtState.Columns.Add("会员状态"); // // DataRow drState0 = dtState.NewRow(); // drState0["会员状态"] = ConstApp.Card_State_InUse; // dtState.Rows.Add(drState0); // // DataRow drState1 = dtState.NewRow(); // drState1["会员状态"] = ConstApp.Card_State_InLose; // dtState.Rows.Add(drState1); // // DataRow drState2 = dtState.NewRow(); // drState2["会员状态"] = ConstApp.Card_State_InAdd; // dtState.Rows.Add(drState2); // // DataRow drState3 = dtState.NewRow(); // drState3["会员状态"] = ConstApp.Card_State_InCallBack; // dtState.Rows.Add(drState3); // DataRow drState4 = dtState.NewRow(); // drState4["会员状态"] = ConstApp.Card_State_NoCard; // dtState.Rows.Add(drState4); // // // // cmbState.DataSource = dtState; // cmbState.DataBind(); //cmbState.SelectedIndex = 0; ClientHelper.BindEnterpriseType(cmbEnterpriseType); ClientHelper.BindTrade(cmbTrade); cmdBeginDate.MaskInput = "yyyy-mm-dd hh:mm"; cmbEndDate2.MaskInput = "yyyy-mm-dd hh:mm"; cmdBeginDate.Value = DateTime.Now.ToString("yyyy-MM-dd") + " 00:00"; cmbEndDate2.Value = DateTime.Now.ToString("yyyy-MM-dd") + " 23:59"; //cmbEndDate.MaskInput = "yyyy-mm-dd"; this.ultraGrid1.Dock = DockStyle.Fill; this.ultraGrid1.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.SortMulti; this.ultraGroupBox2.BorderStyle = Infragistics.Win.Misc.GroupBoxBorderStyle.None; this.ultraGroupBox2.BringToFront(); ClientHelper.BindMemberRight(cmbMemberRight); PopulateValueList(); // if (ClientHelper.idept.cnnDeptID != 0) // { // if(!Login.constApp.alOperFunc.Contains("会员档案报表查询")) // { // this.btnQuery.Enabled = false; // } // if(!Login.constApp.alOperFunc.Contains("会员档案报表打印")) // { // this.btnPrint.Enabled = false; // this.btnExcel.Enabled = false; // } // if(!Login.constApp.alOperFunc.Contains("会员档案报表修改")) // { // //this.btnPrint.Enabled = false; // this.btnModify.Enabled = false; // } // } }