项目源码下载地址：https://github.com/GarsonZhang/GZFramework.Demo
前言
1.在开始本节前请先重置代码为 chapter-03-start
懒人地址：https://github.com/GarsonZhang/GZFramework.ShareDemo/tree/chapter-03-start
2.创建表(商品入库主表/明细)
创建脚本目录：数据库脚本/Chapter-03新建商品入库表(主从表).sql
3.新建生成单据流水号所需的表和存储过程
创建脚本目录：数据库脚本/Chapter-03新建商品入库表(主从表).sql
生成器生成界面
1.修改相关底层生成规则
修改文件：_GZFramework.Demo.Business.Base.dalBase.cs
修改流水单号生成函数：GetDataSN，调用创建的存储过程创建流水单号
//获取流水单号
public override string GetDataSN(IDatabase db, string sDocCode, int sLength)
{
return sDocCode + db.ExecuteScalarSP<string>("sys_GetDataSN",
new { DataCode = sDocCode, Length = sLength });
}修改下服务器时间获取函数:GetServerTime(不同数据库类型获取方式不一样)
//获取系统时间，建议从服务器获取
public override DateTime GetServerTime(IDatabase db)
{
string sql = "SELECT GETDATE()";
return db.ExecuteScalar<DateTime>(sql);
}
2.使用生成器生成界面
1.先生成入库主表和明细表的Model
添加新项，选择 Model层生成
配置相关生成信息，并生成静态结构
生成的Model类如下,其中包含两个静态结构类，一个是主表tb_GoodsIn,一个是明细表tb_GoodsInDetail：
/**************************************************************************
====================GZFramwork【Winfrom快速开发框架】====================
-- 作者：Garson_Zhang QQ：382237285 QQ交流群：288706356
-- 博客地址:http://www.cnblogs.com/GarsonZhang/ -- CLR版本： 4.0.30319.42000
-- 创建时间：2015-09-17 10:52:26
-- 创建年月：2015
**************************************************************************/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using GZFramework.DB.ModelAttribute; namespace _GZFramework.Demo.Models
{ /// <summary>
/// ORM模型, 数据表:tb_GoodsInDetail
/// GZFrameworkCodeGenerate代码生成器自动生成
/// 时间：2015-09-17 10:52
/// </summary>
[ModelStruct(tb_GoodsInDetail._TableName)]
public sealed class tb_GoodsInDetail
{
public const string _TableName = "tb_GoodsInDetail"; /// <summary>
/// 自增字段
/// </summary>
[ModelPrimaryKey]
public const string isid = "isid"; /// <summary>
/// 单据号码
/// </summary>
[ModelForeignKey]
public const string DocNo = "DocNo"; /// <summary>
/// 时间戳
/// </summary>
[ModelRowversion]
public const string rowversion = "rowversion"; /// <summary>
/// 商品编号
/// </summary>
[ModelEditField]
public const string GoodsID = "GoodsID"; /// <summary>
/// 商品名称
/// </summary>
[ModelEditField]
public const string GoodsName = "GoodsName"; /// <summary>
/// 存放仓库
/// </summary>
[ModelEditField]
public const string SID = "SID"; /// <summary>
/// 存放仓位
/// </summary>
[ModelEditField]
public const string AID = "AID"; /// <summary>
/// 数量
/// </summary>
[ModelEditField]
public const string Qty = "Qty"; /// <summary>
/// 备注
/// </summary>
[ModelEditField]
public const string Remark = "Remark"; /// <summary>
/// 创建人
/// </summary>
[ModelEditField]
public const string CreateUser = "CreateUser"; /// <summary>
/// 创建日期
/// </summary>
[ModelEditField]
public const string CreateDate = "CreateDate"; /// <summary>
/// 修改人
/// </summary>
[ModelEditField]
public const string LastUpdateUser = "LastUpdateUser"; /// <summary>
/// 修改日期
/// </summary>
[ModelEditField]
public const string LastUpdateDate = "LastUpdateDate"; } /// <summary>
/// ORM模型, 数据表:tb_GoodsIn
/// GZFrameworkCodeGenerate代码生成器自动生成
/// 时间：2015-09-17 10:52
/// </summary>
[ModelStruct(tb_GoodsIn._TableName)]
public sealed class tb_GoodsIn
{
public const string _TableName = "tb_GoodsIn"; /// <summary>
/// 自增字段
/// </summary>
public const string isid = "isid"; /// <summary>
/// 时间戳
/// </summary>
[ModelRowversion]
public const string rowversion = "rowversion"; /// <summary>
/// 单据号码
/// </summary>
[ModelPrimaryKey]
public const string DocNo = "DocNo"; /// <summary>
/// 入库日期
/// </summary>
[ModelEditField]
public const string DocDate = "DocDate"; /// <summary>
/// 入库人
/// </summary>
[ModelEditField]
public const string OperationUser = "OperationUser"; /// <summary>
/// 供应商
/// </summary>
[ModelEditField]
public const string Supplier = "Supplier"; /// <summary>
/// 种类
/// </summary>
[ModelEditField]
public const string GoodsType = "GoodsType"; /// <summary>
/// 备注
/// </summary>
[ModelEditField]
public const string Remark = "Remark"; /// <summary>
/// 创建人
/// </summary>
[ModelEditField]
public const string CreateUser = "CreateUser"; /// <summary>
/// 创建日期
/// </summary>
[ModelEditField]
public const string CreateDate = "CreateDate"; /// <summary>
/// 修改人
/// </summary>
[ModelEditField]
public const string LastUpdateUser = "LastUpdateUser"; /// <summary>
/// 修改日期
/// </summary>
[ModelEditField]
public const string LastUpdateDate = "LastUpdateDate"; } }2.生成界面：
添加新项选择功能窗体生成
配置主表生成信息：
配置明细表生成信息：注意先添加明细表
生成以后的窗体如下：
在frmGoodsIn.cs类中添加补充缺失的引用
生成的frmGoodsIn.cs代码
public partial class frmGoodsIn : frmBaseDataBusiness
{
public frmGoodsIn()
{
InitializeComponent();
this.Load += frm_Load;
//实例化必须，bllBusinessBase必须替换为bll层自己继承的子类(指定正确的dal.DBCode)，建议封装重写到项目bll层
//_bll = new bllBusinessBase(typeof(tb_GoodsIn),"GI",6,typeof(tb_GoodsInDetail));
_bll = new bllBaseSystem(typeof(tb_GoodsIn), "GI", 6, typeof(tb_GoodsInDetail));
}
private void frm_Load(object sender, EventArgs e)
{
_SummaryView = gvMainData;//必须赋值
base.AddControlsOnAddKey(txtDocDate, txtOperationUser); base.AddControlsOnlyRead(txtDocNo, txtCreateUser, txtCreateDate, txtLastUpdateUser, txtLastUpdateDate);
}
//查询
private void btn_Search_Click(object sender, EventArgs e)
{
var p = ParametersProvide.New(); if (!String.IsNullOrEmpty(txts_DocNo.Text)) p.AddParameter("@DocNo", 0, txts_DocNo.Text);
if (!String.IsNullOrEmpty(txts_DocDate.Text)) p.AddParameter("@DocDate", 0, txts_DocDate.Text);
if (!String.IsNullOrEmpty(txts_OperationUser.Text)) p.AddParameter("@OperationUser", 0, txts_OperationUser.Text);
if (!String.IsNullOrEmpty(txts_Supplier.Text)) p.AddParameter("@Supplier", 0, txts_Supplier.Text);
if (!String.IsNullOrEmpty(txts_GoodsType.Text)) p.AddParameter("@GoodsType", 0, txts_GoodsType.Text); DataTable dt = _bll.Search(p); gcMainData.DataSource = dt;
if (gvMainData.RowCount < 100)//行数过多会很耗时
gvMainData.BestFitColumns();
}
//清空条件
private void btn_Clear_Click(object sender, EventArgs e)
{
LibraryTools.DoClearPanel(LC_Search);
} //保存前检查
protected override bool ValidateBeforSave()
{
bool Validate = true
& LibraryTools.IsNotEmpBaseEdit(txtDocDate, "入库日期不能为空！")
& LibraryTools.IsNotEmpBaseEdit(txtOperationUser, "入库人不能为空！"); Validate = Validate & !gv_Detail_tb_GoodsInDetail.HasColumnErrors & gv_Detail_tb_GoodsInDetail.ValidateEditor(); return Validate;
} private void gv_Detail_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)
{
string TableName = (sender as DevExpress.XtraGrid.Views.Grid.GridView).GridControl.DataSource.ToString();
(sender as DevExpress.XtraGrid.Views.Grid.GridView).SetRowCellValue(e.RowHandle, _bll.DetailModel[TableName].ForeignKey, EditData.Tables[_bll.SummaryModel.TableName].Rows[0][_bll.SummaryModel.PrimaryKey]);
}
private void gc_Detail_EmbeddedNavigator_ButtonClick(object sender, DevExpress.XtraEditors.NavigatorButtonClickEventArgs e)
{
if (e.Button.ButtonType == DevExpress.XtraEditors.NavigatorButtonType.Remove)
{
e.Handled = Msg.AskQuestion("是否确定要删除选中行？") == false;
}
} private void gv_Detail_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
var view = sender as DevExpress.XtraGrid.Views.Grid.GridView;
if (Object.Equals(view.FocusedColumn.Tag, "NotNull"))
{
if (Object.Equals(string.Empty, e.Value) || Object.Equals(null, e.Value) || Object.Equals(DBNull.Value, e.Value))
{
e.Valid = false;
e.ErrorText = view.FocusedColumn.Caption + "不能为空！";
}
}
} private void gv_Detail_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
var view = sender as DevExpress.XtraGrid.Views.Grid.GridView; bool V = true; foreach (DevExpress.XtraGrid.Columns.GridColumn column in view.Columns)
{
if (Object.Equals(column.Tag, "NotNull"))
{
if (String.IsNullOrEmpty(view.GetFocusedRowCellDisplayText(column)))
{
view.SetColumnError(column, column.Caption + "不能为空!");
V = V & false;
}
}
}
e.Valid = V;
} private void gv_Detail_InvalidRowException(object sender, DevExpress.XtraGrid.Views.Base.InvalidRowExceptionEventArgs e)
{
//去掉验证行失败时弹出的确认框
e.ExceptionMode = DevExpress.XtraEditors.Controls.ExceptionMode.NoAction;
} #region 其他常用
//绑定明细页数据
public override void DoBoundEditData()
{
base.DoBoundEditData(); gc_Detail_tb_GoodsInDetail.DataSource = EditData.Tables[tb_GoodsInDetail._TableName]; //其他绑定
//LibraryTools.DoBindingEditorPanel(pan_Summary, EditData.Tables[_bll.SummaryTableName], "txt");
//txxtPassword.EditValue = EditData.Tables[_bll.SummaryTableName].Rows[0][dt_MyUser.Password];
//gc_Detail.DataSource = EditData.Tables[dt_MyUserRole._TableName];
} //获得详细数据，明细也
public override DataSet GetEditData(string KeyValue)
{
return base.GetEditData(KeyValue);
} /// <summary>
/// 设置窗体的基础权限从FunctionAuthorityCommon类中取，例如(默认)：
/// return FunctionAuthorityCommon.VIEW//查看
/// + FunctionAuthorityCommon.ADD//新增
/// + FunctionAuthorityCommon.EDIT//修改
/// + FunctionAuthorityCommon.DELETE//删除
/// + FunctionAuthorityCommon.Save//保存
/// + FunctionAuthorityCommon.Cancel;//取消
/// </summary>
protected override int CurrentAuthority
{
get
{
return base.CurrentAuthority;
}
} //自定义窗体权限按钮
public override void IniButton()
{
base.IniButton();
} //窗体状态改变后
protected override void DataStateChanged(FormDataState NewState)
{
base.DataStateChanged(NewState);
}
//窗体状态改时
protected override void DataStateChanging(FormDataState OldState, FormDataState NewState)
{
base.DataStateChanging(OldState, NewState);
} /// <summary>
/// 设置按钮可用状态，如果已经在ControlOnlyReads或SetControlAccessable中添加，这里不需要重新设置
/// </summary>
/// <param name="Edit"></param>
protected override void SetControlAccessable(bool Edit)
{
//LibraryTools.SetControlAccessable(tp_Edit, Edit);
base.SetControlAccessable(Edit); }
#endregion #region 操作事件，不需要的可以删除
/// <summary>
/// 查询
/// </summary>
public override void DoView(object sender)
{
base.DoView(sender);
} /// <summary>
/// 刷新
/// </summary>
public override void DoRefresh(object sender)
{
base.DoRefresh(sender);
} /// <summary>
/// 新增
/// </summary>
public override void DoAdd(object sender)
{
base.DoAdd(sender);
} /// <summary>
/// 删除
/// </summary>
public override void DoDelete(object sender)
{
base.DoDelete(sender);
} /// <summary>
/// 修改
/// </summary>
public override void DoEdit(object sender)
{
base.DoEdit(sender);
} /// <summary>
/// 保存
/// </summary>
public override void DoSave(object sender)
{
base.DoSave(sender);
} /// <summary>
/// 保存并关闭
/// </summary>
public override void DoSaveAndClose(object sender)
{
base.DoSaveAndClose(sender);
} /// <summary>
/// 审核
/// </summary>
public override void DoApproval(object sender)
{
base.DoApproval(sender);
} /// <summary>
/// 返回取消
/// </summary>
public override void DoCancel(object sender)
{
base.DoCancel(sender);
} /// <summary>
/// 打印预览
/// </summary>
public override void DoPreview(object sender)
{
base.DoPreview(sender);
} /// <summary>
/// 导出数据
/// </summary>
public override void DoExport(object sender)
{
base.DoExport(sender);
} #endregion }3.修改Management如下（红色背景为新增的行）
public Management()
{
FunctionCollection.AddFunction(typeof(frmMyUser), "用户管理", "Function_Account");FunctionCollection.AddFunction(typeof(frmGoodsIn), "商品入库", "");
}
运行软件，如下图所示：
商品入库出现，图片可以在Management.cs中第三个参数设置，注意图片尺寸是64x64,放在images目录下，后缀应该是 _64x64,比如用户管理第三个参数为Function_Accouint,其在images下的图片全名应该为：Function_Accouint_64x64.png
获取图片的相应方法在_GZFramework.Demo.Library.MyClass.LoadUIImage类中
功能使用如下图，(保存验证不通过状态,即必填项为空)
当一个单据新建成功后会自动生成一个流水单号：
其中前缀和位数，都是我们在生成界面中指定的