//库存查询 private void btnQty_Click(object sender, EventArgs e) { if (txtStorage.Text.Trim() == "") { this.ShowAlertMessage("请选择仓库!"); return; } if (dtpBeginDate.Text.Trim() == "") { this.ShowAlertMessage("请选择截止日期!"); return; } string strMaterialGuid = ""; if (txtMaterialGuid.Tag != null) { strMaterialGuid = txtMaterialGuid.Tag.ToString(); } string strMaterialType = ""; if (txtMaterialType.Tag != null) { strMaterialType = txtMaterialType.Tag.ToString(); } string strSupplierGuid = ""; if (txtSupplier.Tag != null) { strSupplierGuid = txtSupplier.Tag.ToString(); } StatReportManage StatReportManage = new StatReportManage(); if (chkView.Checked == true) { DataTable dtl = new DataTable(); dtl = StatReportManage.sp_GetInOutStorageSum(dtpBeginDate.Text + " 00:00:00", dtpEndDate.Text + " 23:59:59", strMaterialGuid, txtStorage.Tag.ToString(), strMaterialType, strSupplierGuid); gridControl1.DataSource = dtl; } else { //进出为0显示没勾上,期初进出结存都为0不显示也没勾上 if (chkView2.Checked == false) { DataTable dtl = new DataTable(); DataTable dtl2 = new DataTable(); dtl = StatReportManage.sp_GetInOutStorageSum(dtpBeginDate.Text + " 00:00:00", dtpEndDate.Text + " 23:59:59", strMaterialGuid, txtStorage.Tag.ToString(), strMaterialType, strSupplierGuid); dtl2 = GetNewDataTable(dtl, " BQInOnlySum>0 or BQInOnlySum<0 or BQOutOnlySum>0 or BQOutOnlySum<0 "); gridControl1.DataSource = dtl2; } else { //进出为0显示没勾上,期初进出结存都为0不显示勾上了 if (chkView2.Checked == true) { DataTable dtl = new DataTable(); DataTable dtl2 = new DataTable(); dtl = StatReportManage.sp_GetInOutStorageSum(dtpBeginDate.Text + " 00:00:00", dtpEndDate.Text + " 23:59:59", strMaterialGuid, txtStorage.Tag.ToString(), strMaterialType, strSupplierGuid); dtl2 = GetNewDataTable(dtl, " QCOnlySum>0 or QCOnlySum<0 or BQInOnlySum>0 or BQInOnlySum<0 or BQOutOnlySum>0 or BQOutOnlySum<0 "); gridControl1.DataSource = dtl2; } } } //权限判断 if (rightgroupManage.IsOperateRightByUserID(SysParams.UserID, "IsDisplayPrice", "IsDisplayPrice") == false) { bandedGridView1.Columns["JCOnlyMoney"].Visible = false; bandedGridView1.Columns["QCOnlyMoney"].Visible = false; bandedGridView1.Columns["BQOutOnlyMoney"].Visible = false; bandedGridView1.Columns["BQInOnlyMoney"].Visible = false; } }