/// <summary> /// 导出EXcel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void btnZToNewExcel_Click(object sender, EventArgs e) { try { this.BaseFocusLabel.Focus(); string CompactNo = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "CompactNo")); string ColorName = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ColorName")); string JarNum = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "JarNum")); string OtherSO = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "OtherSO")); string p_ExportFile = string.Empty; CheckOrderISNRule rule = new CheckOrderISNRule(); GetCondtion(); HTDataConditionStr += " AND CompactNo=" + SysString.ToDBString(CompactNo) + " AND ColorName=" + SysString.ToDBString(ColorName) + " AND JarNum=" + SysString.ToDBString(JarNum) + " AND Seq>0 " + " AND ISNULL(OtherSO,'')=" + SysString.ToDBString(OtherSO); HTDataConditionStr += " ORDER BY CompactNo,JarNum, JarNumCount ASC";// //DataTable dttem = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("CheckFlag", "0 CheckFlag").Replace("PF", "0.00 PF")); //TemplateExcel.JYToExcel(dttem, out p_ExportFile); //this.OpenFileNoConfirm(p_ExportFile); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { CheckOrderISNRule rule = new CheckOrderISNRule(); gridView1.Columns["CheckFlag"].OptionsColumn.ReadOnly = false; gridView1.Columns["CheckFlag"].OptionsColumn.AllowEdit = true; gridView1.Columns["CheckFlag"].OptionsColumn.AllowFocus = true; HTDataConditionStr += " ORDER BY JarNum, Seq ASC";//JarNumCount DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("CheckFlag", "0 CheckFlag")); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
private void btnDelete_Click_1(object sender, EventArgs e) { if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.除)) { this.ShowMessage("你没有此操作权限"); return; } if (MessageBox.Show("确定要删除这匹布吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes) { return; } int ID = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("DID")); CheckOrderISN entity = new CheckOrderISN(); entity.ID = ID; entity.SelectByID(); if (entity.StatusID > (int)EnumBoxStatus.未入库) { this.ShowMessage("布匹已经入库,请检查"); return; } //if (entity.KF25 == 1) //{ // this.ShowMessage("开匹的数据不能删除"); // return; //} //if (entity.KF22 == 1) //{ // this.ShowMessage("退货冲销修改的数据不能删除"); // return; //} CheckOrderISNRule rule = new CheckOrderISNRule(); rule.RDelete(entity); btnQuery_Click(null, null); }