/// <summary> /// 导出数据 /// </summary> protected override void DoExport(object sender) { DataTable dt = new DataTable(); int[] rows = _SummaryView.GetSelectedRows(); if (rows.Length < 1) { Msg.Warning("请选择至少1条数据!"); return; } else { WaiteServer.ShowWaite(this); int sucess = 0; Dictionary <string, object> dic = new Dictionary <string, object>(); if (!String.IsNullOrEmpty(txts_RETURN_STATUS.Text)) { dic.Add("RETURN_STATUS", txts_RETURN_STATUS.EditValue); } if (!String.IsNullOrEmpty(txts_STAR_TIME.Text)) { dic.Add("STAR_TIME", txts_STAR_TIME.EditValue); } if (!String.IsNullOrEmpty(txts_END_TIME.Text)) { dic.Add("END_TIME", txts_END_TIME.EditValue); } foreach (int k in rows) { string Key = ConvertEx.ToString(_SummaryView.GetDataRow(k)[_bll.SummaryModel.PrimaryKey]); if (!String.IsNullOrEmpty(Key)) { dic.Add("G_NAME" + sucess.ToString(), ",'" + Key + "'"); } sucess++; } dt = bll.GetListData(dic);//获得需要绑定的数据 } if (DataToExcel.ExportToExcel(dt, "商品汇总", Lists)) { WaiteServer.CloseWaite(); Msg.ShowInformation("导出成功!"); } WaiteServer.CloseWaite(); }
private void DeleteByExcel(object sender, ItemClickEventArgs e) { try { EditData = frmBaseExcel.ShowForm(vw_Cu_Status._TableName); int count = EditData.Tables[vw_Cu_Status._TableName].Rows.Count; if (EditData.Tables[vw_Cu_Status._TableName] != null && count > 0) { if (chs_Check_Order.Checked || chs_Check_Waybill.Checked || chs_Check_Declare.Checked || chs_Check_EciqOrder.Checked) { string list = "(''"; foreach (DataRow row in EditData.Tables[vw_Cu_Status._TableName].Rows) { string Key = row[vw_Cu_Status.ORDER_NO].ToString(); list += ",'" + Key + "'"; } list += ")"; //返回不允许删除的订单列表 DataTable dt = bll.IsDelete(list); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { list = list.Replace(row[0].ToString(), ""); } } bll.DeleteByOrderNo(list, chs_Check_Order.Checked, chs_Check_Waybill.Checked, chs_Check_Declare.Checked, chs_Check_EciqOrder.Checked); WaiteServer.CloseWaite(); RefreshDataCache();//刷新缓存数据 Msg.ShowInformation("删除完成!\r\n 共" + count + "条,删除" + (count - dt.Rows.Count) + "条。"); } else { Msg.Warning("请选择至少1项单据项!"); return; //base.DoDelete(sender); } } else { Msg.Warning("表格中未读取到内容!"); return; } } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除 /// </summary> protected override void DoDelete(object sender) { try { string list = "(''"; int[] rows = _SummaryView.GetSelectedRows(); if (rows.Length < 1) { Msg.Warning("请选择至少1条数据!"); return; } else if (chs_Check_Order.Checked || chs_Check_Waybill.Checked || chs_Check_Declare.Checked || chs_Check_EciqOrder.Checked) { if (Msg.AskQuestion("确定要删除选中记录吗?") == false) { return; } WaiteServer.ShowWaite(this); EditData = GetEditData(""); int sucess = 0; foreach (int k in rows) { string Key = ConvertEx.ToString(_SummaryView.GetDataRow(k)[_bll.SummaryModel.PrimaryKey]); DataRow dt = _SummaryView.GetDataRow(k); //是否允许删除 if (IsDeclare(dt["DECLARE_STATUS"].ToString())) { sucess++; list += ",'" + Key + "'"; } } list += ")"; bll.DeleteByOrderNo(list, chs_Check_Order.Checked, chs_Check_Waybill.Checked, chs_Check_Declare.Checked, chs_Check_EciqOrder.Checked); WaiteServer.CloseWaite(); RefreshDataCache();//刷新缓存数据 Msg.ShowInformation("删除完成!\r\n 共" + rows.Length + "条,删除" + sucess + "条。"); } else { Msg.Warning("请选择至少1项单据项!"); return; //base.DoDelete(sender); } } catch (Exception ex) { throw ex; } }
protected bool Save(Func <DataSet, bool> Update) { //pan_Summary.Focus(); this.DoValidate(); if (ValidateBeforSave() == false) { return(false); } WaiteServer.ShowWaite(this); DataRow dataRow = EditData.Tables[_bll.SummaryModel.TableName].Rows[0]; dataRow.EndEdit(); if (Update.Invoke(EditData)) { if (_SummaryView.GridControl.DataSource == null) { _SummaryView.GridControl.DataSource = _bll.GetTableStruct(_bll.SummaryModel.TableName); } if (CurrentDataState == FormDataState.Add) { _SummaryView.AddNewRow(); CurrentSummaryRow = _SummaryView.GetFocusedDataRow(); } if (CurrentSummaryRow != null) { CommonTools.CopyDatarowValue(EditData.Tables[_bll.SummaryModel.TableName].Rows[0], CurrentSummaryRow); _SummaryView.UpdateCurrentRow(); } CurrentDataState = FormDataState.View; WaiteServer.CloseWaite(); RefreshDataCache();//刷新缓存数据 return(true); } else { WaiteServer.CloseWaite(); return(false); } }
public Form ShowChildForm(string functionID) { var fun = LoadModuleHelper.Intance.FindFunctionByFunctionID(functionID); if (fun != null) { WaiteServer.ShowWaite(this); Form frm = fun.LoadForm(this); frm.Text = fun.FunctionName; //frm.Icon = LoadUIImage.LoadFormIcon(fun.FunctionPngSmall); frm.Show(); frm.Activate(); // 设置当前 tab页的 图标,我这里也默认取navBar中的Item中的图标 xtraTabbedMdiManager1.Pages[frm].Image = Image.FromHbitmap(frm.Icon.ToBitmap().GetHbitmap()); WaiteServer.CloseWaite(); return(frm); } else { return(null); } }
void frm_VerifySuccess(object sender, EventArgs e) { IsLock = false; WaiteServer.CloseWaite(); }