private string moduleName = "客户合同信息";/// <summary>/// 导入Excel的操作/// </summary>          private void btnImport_Click(object sender, EventArgs e){string templateFile = string.Format("{0}-模板.xls", moduleName);FrmImportExcelData dlg = new FrmImportExcelData();dlg.SetTemplate(templateFile, System.IO.Path.Combine(Application.StartupPath, templateFile));dlg.OnDataSave += new FrmImportExcelData.SaveDataHandler(ExcelData_OnDataSave);dlg.OnRefreshData += new EventHandler(ExcelData_OnRefreshData);dlg.ShowDialog();}void ExcelData_OnRefreshData(object sender, EventArgs e){BindData();}bool ExcelData_OnDataSave(DataRow dr){string customerName = dr["客户名称"].ToString();if (string.IsNullOrEmpty(customerName))return false;CustomerInfo customerInfo = BLLFactory<Customer>.Instance.FindByName(customerName);if (customerInfo == null){throw new ArgumentException(string.Format("客户名称【{0}】不存在，记录已跳过", customerName));}bool success = false;bool converted = false;DateTime dtDefault = Convert.ToDateTime("1900-01-01");DateTime dt;ContractInfo info = new ContractInfo();info.Customer_ID = customerInfo.ID;//客户IDinfo.HandNo = dr["合同编号"].ToString();info.ExpenditureType = dr["收支类型"].ToString();info.ContractType = dr["合同类型"].ToString();info.ContractName = dr["合同名称"].ToString();info.ContractMoney = dr["合同金额"].ToString().ToDecimal();converted = DateTime.TryParse(dr["签约日期"].ToString(), out dt);if (converted && dt > dtDefault){info.SignDate = dt;}
........................................success = BLLFactory<Contract>.Instance.Insert(info);return success;}/// <summary>/// 导出Excel的操作/// </summary>private void btnExport_Click(object sender, EventArgs e){string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));if (!string.IsNullOrEmpty(file)){string where = GetConditionSql();List<ContractInfo> list = BLLFactory<Contract>.Instance.Find(where);DataTable dtNew = DataTableHelper.CreateTable("序号|int,客户名称,合同编号,收支类型,合同类型,合同名称,合同金额,公司签约人,客户签约人,签约日期,签约地点,乙方名称,合同开始日期,合同结束日期,结算情况,合同状态,关联项目,联系人,联系人电话,联系人手机,合同内容,备注说明,经办人");DataRow dr;int j = 1;for (int i = 0; i < list.Count; i++){dr = dtNew.NewRow();dr["序号"] = j++;dr["客户名称"] = BLLFactory<Customer>.Instance.GetCustomerName(list[i].Customer_ID);//转义为客户名称dr["合同编号"] = list[i].HandNo;dr["收支类型"] = list[i].ExpenditureType;dr["合同类型"] = list[i].ContractType;
......................................dr["经办人"] = list[i].Operator;dtNew.Rows.Add(dr);}try{string error = "";AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);if (!string.IsNullOrEmpty(error)){MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));}else{if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes){System.Diagnostics.Process.Start(file);}}}catch (Exception ex){LogTextHelper.Error(ex);MessageDxUtil.ShowError(ex.Message);}}}

        private FrmAdvanceSearch dlg;private void btnAdvanceSearch_Click(object sender, EventArgs e){if (dlg == null){dlg = new FrmAdvanceSearch();dlg.FieldTypeTable = BLLFactory<Contract>.Instance.GetFieldTypeList();dlg.ColumnNameAlias = BLLFactory<Contract>.Instance.GetColumnNameAlias();dlg.DisplayColumns = "Customer_ID,HandNo,ExpenditureType,ContractType,ContractName,ContractMoney,CompanySigner,CustomerSigner,SignDate,SignLocation,PartyBName,StartDate,EndDate,Settlement,Status,RelatedItems,Contact,ContactPhone,ContactMobile,Content,Note,Operator";#region 下拉列表数据//dlg.AddColumnListItem("UserType", Portal.gc.GetDictData("人员类型"));//字典列表//dlg.AddColumnListItem("Sex", "男,女");//固定列表//dlg.AddColumnListItem("Credit", BLLFactory<Contract>.Instance.GetFieldList("Credit"));//动态列表#endregiondlg.ConditionChanged += new FrmAdvanceSearch.ConditionChangedEventHandler(dlg_ConditionChanged);}dlg.ShowDialog();}void dlg_ConditionChanged(SearchCondition condition){advanceCondition = condition;BindData();}

namespace WHC.Framework.BaseUI
{public partial class BaseForm : DevExpress.XtraEditors.XtraForm, IFunction{

namespace WHC.Framework.BaseUI
{/// <summary>/// 父窗体实现的权限控制接口/// </summary>public interface IFunction{/// <summary>/// 初始化权限控制信息/// </summary>void InitFunction(LoginUserInfo userInfo, Dictionary<string, string> functionDict);/// <summary>/// 是否具有访问指定控制ID的权限/// </summary>/// <param name="controlId">功能控制ID</param>/// <returns></returns>bool HasFunction(string controlId);/// <summary>/// 登陆用户基础信息/// </summary>LoginUserInfo LoginUserInfo { get; set; }/// <summary>/// 登录用户具有的功能字典集合/// </summary>Dictionary<string, string> FunctionDict { get; set; }/// <summary>/// 应用程序基础信息/// </summary>AppInfo AppInfo { get; set; }}
}

        private void barCRMContact_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e){ChildWinManagement.LoadMdiForm(this, typeof(FrmCustomerContact));}private void barCRMCustomer_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e){ChildWinManagement.LoadMdiForm(this, typeof(FrmCustomerManage));}

                tableForm = (Form) Activator.CreateInstance(formType);tableForm.MdiParent = mainDialog;//如果窗体集成了IFunction接口(第一次创建需要设置)IFunction function = tableForm as IFunction;if (function != null){//初始化权限控制信息
                    function.InitFunction(Portal.gc.LoginUserInfo, Portal.gc.FunctionDict);//记录程序的相关信息function.AppInfo = new AppInfo(Portal.gc.AppUnit, Portal.gc.AppName, Portal.gc.AppWholeName, Portal.gc.SystemType);}