-
几点：
1、数据库设计
2、Helper
3、Control的代码
-
#region DetailLoadOperAfterSetData - 重载设置需要填充的值
/// <summary>
/// 重载设置需要填充的值
/// </summary>
/// <param name="bllMain">业务操作逻辑</param>
/// <param name="entityMain">数据表查询逻辑条件</param>
/// <param name="modelMain">实体结果集</param>
/// <param name="KVC"></param>
/// <param name="xdbHelper">数据库链接串</param>
public override void DetailLoadOperAfterSetData
(
BaseBusiness bllMain,
BaseEntity entityMain,
BaseModel modelMain,
CtrlKeyValueContainer KVC,
DBHelper xdbHelper
)
{
base.DetailLoadOperAfterSetData
(
bllMain,
entityMain,
modelMain,
KVC,
xdbHelper
);
// 逻辑方法 //
eKing.SzdfPage.Helpers.eKingSzdfPageHelper
wh
=
eKing.SzdfPage.Helpers.eKingSzdfPageHelper.ekInstance;
// 获得页面的属性 //
eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx.EkSzdfPage eKp
=
eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx.EkSzdfPage.instance;
// 录入表单 //
eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx.EkSzdfDetailForm
dF
=
eKp.DetailForm;
// 业务操作逻辑 //
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX
bll
=
bllMain
as
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX;
// 数据表查询逻辑条件 //
eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX
entity
=
entityMain
as
eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX;
// 获得对应的一条记录的实体值 //
eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX
model
=
modelMain
as
eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX;
// 获得控件的值 //
string strValue = null;
string strCtrlClientId = null;
// 获得值 //
strValue
=
wh.HrzzbNczjcx4job4JobCodeLinkByNczjcxId
(
model.ID,
xdbHelper
);
// 获得控件ID //
strCtrlClientId = dF._Job_Codes.GetValueCtrlClientId();
// 将值装入Json数组 //
KVC.SetItem(strCtrlClientId, strValue);
}
#endregion DetailLoadOperAfterSetData - 重载设置需要填充的值
-
#region DetailSaveOperBeforeDB - 保存前设置数据库的值
/// <summary>
/// 保存前设置数据库的值
/// </summary>
/// <param name="bllMain">业务操作逻辑</param>
/// <param name="entityMain">表实体</param>
/// <param name="dp"></param>
/// <param name="xdbHelper">数据库链接串</param>
public override void DetailSaveOperBeforeDB
(
BaseBusiness bllMain,
BaseEntity entityMain,
DetailSaveOperDBParams dp,
DBHelper xdbHelper
)
{
base.DetailSaveOperBeforeDB
(
bllMain,
entityMain,
dp,
xdbHelper
);
// 获得页面的属性 //
eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx.EkSzdfPage eKp
=
eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx.EkSzdfPage.instance;
//这里指定录入页面（同理可以指定其他页面）
eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx.EkSzdfDetailForm
df
=
eKp.DetailForm;
// 逻辑方法 //
eKing.SzdfPage.Helpers.eKingSzdfPageHelper
wh
=
eKing.SzdfPage.Helpers.eKingSzdfPageHelper.ekInstance;
// 表操作交互字段 //
eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX
entity
=
entityMain as eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX;
// 引入驱动 //
ISaveDriver isave = entity;
if (isave.IsAddISaveItem(entity._Job_Codes))
{
// 关联服务代号 //
string strFwIds = df._Job_Codes.GetHttpContextStrValue();
// 确保服务内容不能溢出 //
if (strFwIds != null && strFwIds.Length > 0)
{
if (strFwIds.Length > 4000)
{
strFwIds = "#" + strFwIds.Substring(0, 3999);
isave.AddISaveItem(entity._Job_Codes, strFwIds);
}
}
}
}
#endregion DetailSaveOperBeforeDB - 保存前设置数据库的值
-
#region DetailSaveOperAfterDB
/// <summary>
/// 保存后的更新操作
/// </summary>
/// <param name="bllMain"></param>
/// <param name="entityMain"></param>
/// <param name="dp"></param>
/// <param name="xdbHelper"></param>
public override void DetailSaveOperAfterDB
(
BaseBusiness bllMain,
BaseEntity entityMain,
DetailSaveOperDBParams dp,
DBHelper xdbHelper
)
{
base.DetailSaveOperAfterDB(bllMain, entityMain, dp, xdbHelper);
// 获得页面的属性 //
eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx.EkSzdfPage eKp
=
eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx.EkSzdfPage.instance;
//这里指定录入页面（同理可以指定其他页面）
eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx.EkSzdfDetailForm
df
=
eKp.DetailForm;
// 逻辑方法 //
eKing.SzdfPage.Helpers.eKingSzdfPageHelper
wh
=
eKing.SzdfPage.Helpers.eKingSzdfPageHelper.ekInstance;
long pkId = long.Parse(dp.PkId);
// 通过参数保存关联关系 //
int fwCount
=
wh.HrzzbNczjcx4jobSaveByNczjcx_Id
(
pkId,
df._Job_Codes.GetHttpContextStrValue(),
dp,
xdbHelper
);
}
#endregion DetailSaveOperAfterDB
-
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using SlowX.DAL.Helpers;
using SlowX.Core.ICoreClasses;
using System.Reflection;
using eKing.SzdfLib.Classes.Pages;
namespace eKing.SzdfLib.Helpers
{
public partial class eKingSzdfLibHelper
:
eKing.SzdfLib.IHelpers.BLLs.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB__P
{
// UTB_SZDF_HRZZB_NCZJCX4JOB ~ 内场准驾车辆类型和保障任务 ~ HrzzbNczjcx4job
/// <summary>
/// UTB_SZDF_HRZZB_NCZJCX4JOB - 通过nczjcx_Id(内场准驾车辆类型) 找到 BSAFEGUARDJOB_CODE 的对应个数
/// </summary>
/// <param name="nczjcx_Id"></param>
/// <param name="xdbHelper"></param>
/// <returns></returns>
public int HrzzbNczjcx4jobCountJobCode8NczjcxId
(
long nczjcx_Id,
DBHelper xdbHelper
)
{
int theResult = 0;
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper
=
SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
bll
=
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB.instance;
eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
entity
=
new eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB();
IQueryDriver iq = entity;
iq.WhereAddLong(entity._NCZJCX_Id, nczjcx_Id);
theResult = bll.Count(entity, xdbHelper);
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
return theResult;
}
/// <summary>
/// UTB_SZDF_HRZZB_NCZJCX4JOB 通过 nczjcx_Id(内场准驾车辆类型)和bSafeguardJobCode(保障任务)获得对应的id
/// </summary>
/// <param name="nczjcx_Id"></param>
/// <param name="bSafeguardJobCode"></param>
/// <param name="xdbHelper"></param>
/// <returns></returns>
public long HrzzbNczjcx4jobGetPkId
(
long nczjcx_Id,
string bSafeguardJobCode,
DBHelper xdbHelper
)
{
long theResult = 0;
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper
=
SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
bll
=
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB.instance;
eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
entity
=
new eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB();
IOrderByDriver iorder = entity;
IQueryDriver iq = entity;
iorder.AddIOrderByItemWithEntityFieldInfo
(
entity._ID,
SlowX.Core.Enums.OrderBy.EmOrderBy.ASC
);
iq.AddIQueryItemWithEntityFieldInfo(entity._NCZJCX_Id, nczjcx_Id);
iq.WhereAddStr(entity._BSafeguardJob_Code, bSafeguardJobCode);
eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
model
=
bll.GetBaseModel(entity, xdbHelper)
as
eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB;
if (model != null)
theResult = model.ID;
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
return theResult;
}
/// <summary>
/// 通过 nczjcx_Id ==> 获得UTB_SZDF_HRZZB_NCZJCX4JOB 对应的jobcode,jobcode,jobcode
/// </summary>
/// <param name="nczjcx_Id"></param>
/// <param name="xdbHelper"></param>
/// <returns></returns>
public string HrzzbNczjcx4job4JobCodeLinkByNczjcxId
(
long nczjcx_Id,
DBHelper xdbHelper
)
{
List<eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB> theResult
=
HrzzbNczjcx4jobModelListByNczjcxId(nczjcx_Id, xdbHelper);
if (theResult == null)
return "";
int iCount = theResult.Count;
if (iCount == 0)
return "";
if (iCount == 1)
return theResult[0].BSafeguardJob_Code;
StringBuilder sb = new StringBuilder();
sb.Append(theResult[0].BSafeguardJob_Code);
for (int i = 1; i < iCount; ++i)
sb.Append("," + theResult[i].BSafeguardJob_Code);
return sb.ToString();
}
/// <summary>
/// UTB_SZDF_HRZZB_NCZJCX4JOB：通过 nczjcx_Id ==> 获得UTB_SZDF_HRZZB_NCZJCX4JOB 对应的记录集合
/// </summary>
/// <param name="nczjcx_Id"></param>
/// <param name="xdbHelper"></param>
/// <returns></returns>
public List<eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB>
HrzzbNczjcx4jobModelListByNczjcxId
(
long nczjcx_Id,
DBHelper xdbHelper
)
{
List<eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB> theResult = null;
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper
=
SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
bll
=
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB.instance;
eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
entity
=
new eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB();
IOrderByDriver iorder = entity;
IQueryDriver iq = entity;
iorder.AddIOrderByItemWithEntityFieldInfo
(
entity._ID,
SlowX.Core.Enums.OrderBy.EmOrderBy.ASC
);
iq.AddIQueryItemWithEntityFieldInfo(entity._NCZJCX_Id, nczjcx_Id);
theResult = bll.ListCurModel(entity, xdbHelper);
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
return theResult;
}
/// <summary>
/// UTB_SZDF_HRZZB_NCZJCX4JOB：通过nczjcx_Id删除对应的UTB_SZDF_HRZZB_NCZJCX4JOB的表记录
/// </summary>
/// <param name="nczjcx_Id"></param>
/// <param name="xdbHelper"></param>
public void HrzzbNczjcx4jobDeleteByNczjcxId
(
long nczjcx_Id,
DBHelper xdbHelper
)
{
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper
=
SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
bll
=
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB.instance;
eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
entity
=
new eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB();
IQueryDriver iq = entity;
iq.AddIQueryItemWithEntityFieldInfo
(
entity._NCZJCX_Id,
nczjcx_Id
);
bll.Delete(entity, xdbHelper);
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
}
/// <summary>
/// UTB_SZDF_HRZZB_NCZJCX4JOB：通过nczjcx_Id和bSafeguardJobCode找到List -eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB 的索引位置
/// </summary>
/// <param name="theList"></param>
/// <param name="nczjcx_Id"></param>
/// <param name="bSafeguardJobCode"></param>
/// <returns></returns>
public int HrzzbNczjcx4jobFindByNczjcxId_JobCode
(
List<eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB> theList,
long nczjcx_Id,
string bSafeguardJobCode
)
{
if (theList == null)
return -1;
int iCount = theList.Count;
for (int i = 0; i < iCount; ++i)
{
if (theList[i].BSafeguardJob_Code != bSafeguardJobCode)
continue;
if (theList[i].NCZJCX_Id != nczjcx_Id)
continue;
return i;
}
return -1;
}
/// <summary>
/// UTB_SZDF_HRZZB_NCZJCX4JOB：通过nczjcx_Id和jobcode,jobcode,jobcode，保存记录
/// </summary>
/// <param name="nczjcx_Id"></param>
/// <param name="fwIds"></param>
/// <param name="dp"></param>
/// <param name="xdbHelper"></param>
/// <returns></returns>
public int HrzzbNczjcx4jobSaveByNczjcx_Id
(
long nczjcx_Id,
string fwIds,
DetailSaveOperDBParams dp,
DBHelper xdbHelper
)
{
int theResult = 0;
bool bIsCreate = true;
if (xdbHelper == null)
{
xdbHelper
=
SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
}
else
{
// 没有打开链接 //
bIsCreate = xdbHelper.IsNotOpen();
}
try
{
if (bIsCreate)
xdbHelper.OpenDBHelper();
if (fwIds == null || fwIds.Length == 0)
{
// 没有没有勾选 //
// 清空记录 //
HrzzbNczjcx4jobDeleteByNczjcxId(nczjcx_Id, xdbHelper);
if (bIsCreate)
xdbHelper.EndDBHelper();
return 0;
}
List<eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB>
theList
=
HrzzbNczjcx4jobModelListByNczjcxId(nczjcx_Id, xdbHelper);
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
bll
=
eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB.instance;
eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
entity
=
new eKing.SzdfLib.Entity.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB();
IQueryDriver iq = entity;
ISaveDriver isave = entity;
int idx = -1;
string[] sA = fwIds.Split(',');
string bSafeguardJobCode = null;
long newId = 0;
foreach (string s in sA)
{
bSafeguardJobCode = s;
if (bSafeguardJobCode == null)
continue;
bSafeguardJobCode = bSafeguardJobCode.Trim();
if (bSafeguardJobCode.Length == 0)
continue;
idx = HrzzbNczjcx4jobFindByNczjcxId_JobCode
(
theList,
nczjcx_Id,
bSafeguardJobCode
);
if (idx != -1)
{
// 找到符合条件的记录 //
theList.RemoveAt(idx);
++theResult;
continue;
}
newId = bll.GetNewLongID(xdbHelper);
isave.ClearAllISaveItem();
isave.AddISaveItem(entity._NCZJCX_Id, nczjcx_Id);
isave.AddISaveItem(entity._BSafeguardJob_Code, bSafeguardJobCode);
isave.AddISaveItem(entity._ID, newId);
isave.AddISaveItem(entity._InputUserId, dp.UserId);
isave.AddISaveItem(entity._LastUpdateUserId, dp.UserId);
isave.AddISaveItem(entity._CreateTime, dp.DateTimeNow);
isave.AddISaveItem(entity._UpdateTime, dp.DateTimeNow);
bll.Insert(entity, xdbHelper);
++theResult;
}
if (theList.Count > 0)
{
StringBuilder sbIds = new StringBuilder();
bool isFirst = true;
foreach (eKing.SzdfLib.Model.HRZZB.UTB_SZDF_HRZZB_NCZJCX4JOB
model in theList)
{
if (isFirst)
isFirst = false;
else
sbIds.Append(",");
sbIds.Append(model.ID.ToString());
}
if (!isFirst)
{
bll.DeleteByInIds(sbIds.ToString(), xdbHelper);
}
}
if (bIsCreate)
xdbHelper.EndDBHelper();
}
catch (Exception err)
{
if (bIsCreate)
xdbHelper.TranDBHelper();
throw err;
}
finally
{
if (bIsCreate)
xdbHelper.FinallyDBHelper();
}
return theResult;
}
}
}
-
drop table UTB_SZDF_HRZZB_NCZJCX4JOB;
-- 内场准驾车辆类型和保障任务 --
create table UTB_SZDF_HRZZB_NCZJCX4JOB
(
ID number primary key, -- 内场准驾车辆类型和保障任务 HR资质 基础字典--
NCZJCX_Id number not null, -- 内场准驾车辆类型 ID --
BSafeguardJob_Code varchar2(255) not null, -- 保障任务 B_SAFEGUARD_JOB ID --
InputUserId varchar2(255) not null, -- 创建用户 --
CreateTime date default sysdate not null, -- 创建时间 --
LastUpdateUserId varchar2(255) not null, -- 最后更新用户 --
UpdateTime date default sysdate not null -- 修改时间 --
);
--+ [表]UTB_SZDF_HRZZB_NCZJCX4JOB:内场准驾车辆类型和保障任务 HR资质 基础字典 |--
comment on table UTB_SZDF_HRZZB_NCZJCX4JOB is '内场准驾车辆类型和保障任务 HR资质 基础字典';
--+ ID:内场准驾车辆类型和保障任务 HR资质 基础字典 |--
comment on column UTB_SZDF_HRZZB_NCZJCX4JOB.ID is '内场准驾车辆类型和保障任务 HR资质 基础字典';
--+ NCZJCX_Id:内场准驾车辆类型 ID |--
comment on column UTB_SZDF_HRZZB_NCZJCX4JOB.NCZJCX_Id is '内场准驾车辆类型 ID';
--+ BSafeguardJob_Code:保障任务 B_SAFEGUARD_JOB ID |--
comment on column UTB_SZDF_HRZZB_NCZJCX4JOB.BSafeguardJob_Code is '保障任务 B_SAFEGUARD_JOB ID';
--+ InputUserId:创建用户 |--
comment on column UTB_SZDF_HRZZB_NCZJCX4JOB.InputUserId is '创建用户';
--+ CreateTime:创建时间 |--
comment on column UTB_SZDF_HRZZB_NCZJCX4JOB.CreateTime is '创建时间';
--+ LastUpdateUserId:最后更新用户 |--
comment on column UTB_SZDF_HRZZB_NCZJCX4JOB.LastUpdateUserId is '最后更新用户';
--+ UpdateTime:修改时间 |--
comment on column UTB_SZDF_HRZZB_NCZJCX4JOB.UpdateTime is '修改时间';
-- 创建[表格:UTB_SZDF_HRZZB_NCZJCX4JOB] seq_szdf_hrzzb_nczjcx4job --
CREATE SEQUENCE seq_szdf_hrzzb_nczjcx4job
START WITH 1
INCREMENT BY 1
MINVALUE 1
NOMAXVALUE
NOCACHE
NOCYCLE
NOORDER
/
-
drop table UTB_SZDF_HRZZB_NCZJCX;
-- 内场准驾车辆类型 --
create table UTB_SZDF_HRZZB_NCZJCX
(
ID number primary key, -- 内场准驾车辆类型 HR资质 基础字典--
TheName varchar2(255) not null, -- 名称 --
TheCode varchar2(255) not null unique, -- 代号 --
Job_Codes varchar2(4000), -- 保障任务 --
ShowSeq integer not null, -- 显示顺序 --
TheText varchar2(4000), -- 描述 --
Remark varchar2(4000), -- 备注 --
InputUserId varchar2(255) not null, -- 创建用户 --
CreateTime date default sysdate not null, -- 创建时间 --
LastUpdateUserId varchar2(255) not null, -- 最后更新用户 --
UpdateTime date default sysdate not null -- 修改时间 --
);
--+ [表]UTB_SZDF_HRZZB_NCZJCX:内场准驾车辆类型 HR资质 基础字典 |--
comment on table UTB_SZDF_HRZZB_NCZJCX is '内场准驾车辆类型 HR资质 基础字典';
--+ ID:内场准驾车辆类型 HR资质 基础字典 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.ID is '内场准驾车辆类型 HR资质 基础字典';
--+ TheName:名称 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.TheName is '名称';
--+ TheCode:代号 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.TheCode is '代号';
--+ Job_Codes:保障任务 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.Job_Codes is '保障任务';
--+ ShowSeq:显示顺序 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.ShowSeq is '显示顺序';
--+ TheText:描述 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.TheText is '描述';
--+ Remark:备注 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.Remark is '备注';
--+ InputUserId:创建用户 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.InputUserId is '创建用户';
--+ CreateTime:创建时间 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.CreateTime is '创建时间';
--+ LastUpdateUserId:最后更新用户 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.LastUpdateUserId is '最后更新用户';
--+ UpdateTime:修改时间 |--
comment on column UTB_SZDF_HRZZB_NCZJCX.UpdateTime is '修改时间';
-- 创建[表格:UTB_SZDF_HRZZB_NCZJCX] seq_szdf_hrzzb_nczjcx --
CREATE SEQUENCE seq_szdf_hrzzb_nczjcx
START WITH 1
INCREMENT BY 1
MINVALUE 1
NOMAXVALUE
NOCACHE
NOCYCLE
NOORDER
/
-
using eKing.EkPageCreate.IWebCtrls;
using System;
using System.Web.UI.WebControls;
using eKing.EkPageCreate.CtrlNames;
using eKing.SzdfPage.WebCtrls;
using eKing.SzdfPage.Helpers;
using SlowX.Core.Classes;
/// <summary>
/// <para>表名：UTB_SZDF_HRZZB_NCZJCX</para>
/// <para>注释：内场准驾车辆类型</para>
/// <para>逻辑类：eKing.SzdfLib.Business.HRZZB.UTB_SZDF_HRZZB_NCZJCX</para>
/// </summary>
namespace eKing.SzdfPage.Areas.ZnbmHrzz.HRZZB.HrzzbNczjcx
{
public partial class EkSzdfDetailForm
{
/// <summary>
/// 重写扩展逻辑
/// </summary>
public override void InitClassAfter()
{
base.InitClassAfter();
eKingSzdfPageHelper
wh
= eKingSzdfPageHelper.ekInstance;
EkxPageInputCtrl ekx = null;
// IValidCtrl ivc = null;
#region TheName - 名称
// // TheName - 名称
//ekx = _TheName;
#endregion TheName - 名称
#region TheCode - 代号
// // TheCode - 代号
//ekx = _TheCode;
#endregion TheCode - 代号
#region Job_Codes - 保障任务
// Job_Codes - 保障任务
ekx = _Job_Codes;
ekx.EmCtrlTypeV = EkPageCreate.Enums.CtrlType.EmCtrlType.下拉多选框;
ekx.CtrlWidth = Unit350px;
ekx.EmListControlAddItemV = EkPageCreate.Enums.ListControlAddItem.EmListControlAddItem.自定义;
ekx.EmLogicDataSourceV = Enums.LogicDataSource.EmLogicDataSource.B_SAFEGUARD_JOB;
ekx.EmDataColumnLinkV = EkPageCreate.Enums.DataColumnLink.EmDataColumnLink.不设置;
ekx.CtrlCssClassDefaultSelectSet();
ekx.CtrlHeight = Unit.Empty;
#endregion Job_Codes - 保障任务
#region ShowSeq - 显示顺序
// // ShowSeq - 显示顺序
//ekx = _ShowSeq;
#endregion ShowSeq - 显示顺序
#region TheText - 描述
// // TheText - 描述
//ekx = _TheText;
#endregion TheText - 描述
#region Remark - 备注
// // Remark - 备注
//ekx = _Remark;
#endregion Remark - 备注
}
}
}