Web界面和Winform界面生成，代码生成工具

public partial class FrmItemDetail : BaseDock
{
public FrmItemDetail2()
{
InitializeComponent(); InitDictItem(); this.winGridViewPager1.OnPageChanged += new EventHandler(winGridViewPager1_OnPageChanged);
this.winGridViewPager1.OnStartExport += new EventHandler(winGridViewPager1_OnStartExport);
this.winGridViewPager1.OnEditSelected += new EventHandler(winGridViewPager1_OnEditSelected);
this.winGridViewPager1.OnAddNew += new EventHandler(winGridViewPager1_OnAddNew);
this.winGridViewPager1.OnDeleteSelected += new EventHandler(winGridViewPager1_OnDeleteSelected);
this.winGridViewPager1.OnRefresh += new EventHandler(winGridViewPager1_OnRefresh);
this.winGridViewPager1.AppendedMenu = this.contextMenuStrip1;
this.winGridViewPager1.ShowLineNumber = true; this.txtItemNo.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp);
this.txtItemName.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp);
this.txtManufacture.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp);
this.txtMapNo.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp);
this.txtSpecification.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp);
this.txtMaterial.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp);
this.txtItemBigType.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp);
this.txtItemType.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp);
this.txtUnit.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp);
this.txtSource.KeyUp += new System.Windows.Forms.KeyEventHandler(this.SearchControl_KeyUp); } /// <summary>
/// 编写初始化窗体的实现，可以用于刷新
/// </summary>
public override void FormOnLoad()
{
BindData();
} /// <summary>
/// 初始化字典列表内容
/// </summary>
private void InitDictItem()
{
//初始化代码
} /// <summary>
/// 分页控件刷新操作
/// </summary>
private void winGridViewPager1_OnRefresh(object sender, EventArgs e)
{
BindData();
} /// <summary>
/// 分页控件删除操作
/// </summary>
private void winGridViewPager1_OnDeleteSelected(object sender, EventArgs e)
{
if (MessageDxUtil.ShowYesNoAndTips("您确定删除选定的记录么？") == DialogResult.No)
{
return;
} int[] rowSelected = this.winGridViewPager1.GridView1.GetSelectedRows();
foreach (int iRow in rowSelected)
{
string ID = this.winGridViewPager1.GridView1.GetRowCellDisplayText(iRow, "ID");
BLLFactory<ItemDetail>.Instance.Delete(ID);
} BindData();
} /// <summary>
/// 分页控件编辑项操作
/// </summary>
private void winGridViewPager1_OnEditSelected(object sender, EventArgs e)
{
string ID = this.winGridViewPager1.gridView1.GetFocusedRowCellDisplayText("ID");
List<string> IDList = new List<string>();
for (int i = 0; i < this.winGridViewPager1.gridView1.RowCount; i++)
{
string strTemp = this.winGridViewPager1.GridView1.GetRowCellDisplayText(i, "ID");
IDList.Add(strTemp);
} if (!string.IsNullOrEmpty(ID))
{
FrmEditItemDetail dlg = new FrmEditItemDetail();
dlg.ID = ID;
dlg.IDList = IDList;
if (DialogResult.OK == dlg.ShowDialog())
{
BindData();
}
}
} /// <summary>
/// 分页控件新增操作
/// </summary>
private void winGridViewPager1_OnAddNew(object sender, EventArgs e)
{
btnAddNew_Click(null, null);
} /// <summary>
/// 分页控件全部导出操作前的操作
/// </summary>
private void winGridViewPager1_OnStartExport(object sender, EventArgs e)
{
string where = GetConditionSql();
this.winGridViewPager1.AllToExport = BLLFactory<ItemDetail>.Instance.FindToDataTable(where);
} /// <summary>
/// 分页控件翻页的操作
/// </summary>
private void winGridViewPager1_OnPageChanged(object sender, EventArgs e)
{
BindData();
} /// <summary>
/// 根据查询条件构造查询语句
/// </summary>
private string GetConditionSql()
{
SearchCondition condition = new SearchCondition();
condition.AddCondition("ItemNo", this.txtItemNo.Text, SqlOperator.Like);
condition.AddCondition("ItemName", this.txtItemName.Text, SqlOperator.Like);
condition.AddCondition("Manufacture", this.txtManufacture.Text, SqlOperator.Like);
condition.AddCondition("MapNo", this.txtMapNo.Text, SqlOperator.Like);
condition.AddCondition("Specification", this.txtSpecification.Text, SqlOperator.Like);
condition.AddCondition("Material", this.txtMaterial.Text, SqlOperator.Like);
condition.AddCondition("ItemBigType", this.txtItemBigType.Text, SqlOperator.Like);
condition.AddCondition("ItemType", this.txtItemType.Text, SqlOperator.Like);
condition.AddCondition("Unit", this.txtUnit.Text, SqlOperator.Like);
condition.AddCondition("Source", this.txtSource.Text, SqlOperator.Like); string where = condition.BuildConditionSql(DatabaseType.SqlServer).Replace("Where", ""); return where;
} /// <summary>
/// 绑定列表数据
/// </summary>
private void BindData()
{
this.winGridViewPager1.DisplayColumns = "ItemNo,ItemName,Manufacture,MapNo,Specification,Material,ItemBigType,ItemType,Unit,Price,Source,StoragePos,UsagePos,Note,WareHouse,Dept";
#region 添加别名解析 this.winGridViewPager1.AddColumnAlias("ItemNo", "备件编号");
this.winGridViewPager1.AddColumnAlias("ItemName", "备件名称");
this.winGridViewPager1.AddColumnAlias("Manufacture", "供货商");
this.winGridViewPager1.AddColumnAlias("MapNo", "图号");
this.winGridViewPager1.AddColumnAlias("Specification", "规格型号");
this.winGridViewPager1.AddColumnAlias("Material", "材质");
this.winGridViewPager1.AddColumnAlias("ItemBigType", "备件属类");
this.winGridViewPager1.AddColumnAlias("ItemType", "备件类别");
this.winGridViewPager1.AddColumnAlias("Unit", "单位");
this.winGridViewPager1.AddColumnAlias("Price", "单价");
this.winGridViewPager1.AddColumnAlias("Source", "来源");
this.winGridViewPager1.AddColumnAlias("StoragePos", "库位");
this.winGridViewPager1.AddColumnAlias("UsagePos", "使用位置");
this.winGridViewPager1.AddColumnAlias("Note", "备注");
this.winGridViewPager1.AddColumnAlias("WareHouse", "所属库房");
this.winGridViewPager1.AddColumnAlias("Dept", "所属部门"); #endregion string where = GetConditionSql();
List<ItemDetailInfo> list = BLLFactory<ItemDetail>.Instance.FindWithPager(where, this.winGridViewPager1.PagerInfo);
this.winGridViewPager1.DataSource = new WHC.Pager.WinControl.SortableBindingList<ItemDetailInfo>(list);
this.winGridViewPager1.PrintTitle = Portal.gc.gAppUnit + " -- " + "信息报表";
} /// <summary>
/// 查询数据操作
/// </summary>
private void btnSearch_Click(object sender, EventArgs e)
{
BindData();
} /// <summary>
/// 新增数据操作
/// </summary>
private void btnAddNew_Click(object sender, EventArgs e)
{
FrmEditItemDetail dlg = new FrmEditItemDetail();
if (DialogResult.OK == dlg.ShowDialog())
{
BindData();
}
} /// <summary>
/// 提供给控件回车执行查询的操作
/// </summary>
private void SearchControl_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
btnSearch_Click(null, null);
}
} 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)
{
bool success = false;
ItemDetailInfo info = new ItemDetailInfo();
info.ItemNo = dr["备件编号"].ToString();
info.ItemName = dr["备件名称"].ToString();
info.Manufacture = dr["供货商"].ToString();
info.MapNo = dr["图号"].ToString();
info.Specification = dr["规格型号"].ToString();
info.Material = dr["材质"].ToString();
info.ItemBigType = dr["备件属类"].ToString();
info.ItemType = dr["备件类别"].ToString();
info.Unit = dr["单位"].ToString();
info.Price = Convert.ToDecimal(dr["单价"].ToString());
info.Source = dr["来源"].ToString();
info.StoragePos = dr["库位"].ToString();
info.UsagePos = dr["使用位置"].ToString();
info.Note = dr["备注"].ToString();
info.WareHouse = dr["所属库房"].ToString();
info.Dept = dr["所属部门"].ToString(); success = BLLFactory<ItemDetail>.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))
{
List<ItemDetailInfo> list = BLLFactory<ItemDetail>.Instance.GetAll();
DataTable dtNew = DataTableHelper.CreateTable("序号|int");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["备件编号"] = list[i].ItemNo;
dr["备件名称"] = list[i].ItemName;
dr["供货商"] = list[i].Manufacture;
dr["图号"] = list[i].MapNo;
dr["规格型号"] = list[i].Specification;
dr["材质"] = list[i].Material;
dr["备件属类"] = list[i].ItemBigType;
dr["备件类别"] = list[i].ItemType;
dr["单位"] = list[i].Unit;
dr["单价"] = list[i].Price;
dr["来源"] = list[i].Source;
dr["库位"] = list[i].StoragePos;
dr["使用位置"] = list[i].UsagePos;
dr["备注"] = list[i].Note;
dr["所属库房"] = list[i].WareHouse;
dr["所属部门"] = list[i].Dept;
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)
{
LogHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
}