/// <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();
}
