/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XCodeEquipmentCustTypeInfo info = modelInfo as XCodeEquipmentCustTypeInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.NameEN = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "NameEN")); //英文名称
info.NameCN = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "NameCN")); //中文名称
info.NameBig5 = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "NameBig5")); //繁体名称
info.Code = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Code")); //代码
info.CodeNum = XHelper.GetInt(XDataRowHelper.GetFieldValue(modelRow, "CodeNum")); //数字代码
info.CodeEN = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CodeEN")); //字母代码
info.Spell = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Spell")); //拼音
info.SpellHeader = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SpellHeader")); //拼音缩写
info.ProirNum = XHelper.GetInt(XDataRowHelper.GetFieldValue(modelRow, "ProirNum")); //顺序号
info.DeptId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "DeptId")); //部门名称
info.IsUsed = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "IsUsed")) == "True"; //是否可用
info.ParentID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ParentID")); //上级节点
info.UserID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UserID")); //用户ID
info.Remark = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Remark")); //备注
info.InputUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputUserId")); //录入人
info.InputTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputTime")); //录入时间
info.UpdateUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UpdateUserId")); //修改人
info.UpdateTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UpdateTime")); //修改时间
}
/// <summary>
/// 获取删除时插入日志表sql
/// </summary>
/// <param name="modelInfo"></param>
/// <param name="userId"></param>
/// <returns></returns>
protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId)
{
XCodeEquipmentCustTypeInfo info = modelInfo as XCodeEquipmentCustTypeInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,NameEN,NameCN,NameBig5,Code,CodeNum,CodeEN,Spell,SpellHeader,ProirNum,DeptId,IsUsed,ParentID,UserID,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,OperateUserId,Operate,OperateTime,NewID) SELECT RID,NameEN,NameCN,NameBig5,Code,CodeNum,CodeEN,Spell,SpellHeader,ProirNum,DeptId,IsUsed,ParentID,UserID,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,'" + userId + "','删除',getdate(),newid() FROM " + this.TableName + " WHERE " + this.PrimaryKey + "='" + info.RID + "'";
return(sql);
}
/// <summary>
/// 填充实体信息
/// </summary>
protected override void FillModelInfo()
{
XCodeEquipmentCustTypeInfo info = this.m_CurrentModel as XCodeEquipmentCustTypeInfo;
if (this.m_EditStatus == XEditStatus.AddNew)
{
info.RID = this.GetNewId();
}
info.NameEN = this.txtNameEN.Text;
info.NameCN = this.txtNameCN.Text;
info.NameBig5 = this.txtNameBig5.Text;
info.Code = this.txtCode.Text;
info.CodeNum = XHelper.GetInt(this.nebCodeNum.Value);
info.CodeEN = this.txtCodeEN.Text;
info.Spell = this.txtSpell.Text;
info.SpellHeader = this.txtSpellHeader.Text;
info.ProirNum = XHelper.GetInt(this.nebProirNum.Value);
info.DeptId = this.txtDeptId.Text;
info.IsUsed = this.chkIsUsed.Checked;
info.ParentID = this.txtParentID.Text;
info.UserID = this.txtUserID.Text;
info.Remark = this.txtRemark.Text;
base.FillModelInfo();
}
/// <summary>
/// 获取插入sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetInsertSql(XModelBase modelInfo)
{
XCodeEquipmentCustTypeInfo info = modelInfo as XCodeEquipmentCustTypeInfo;
string sql = "Insert Into " + this.TableName + "(RID,NameEN,NameCN,NameBig5,Code,CodeNum,CodeEN,Spell,SpellHeader,ProirNum,DeptId,IsUsed,ParentID,UserID,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime)Values('{0}','{1}','{2}','{3}','{4}',{5},'{6}','{7}','{8}',{9},'{10}','{11}','{12}','{13}','{14}','{15}',{16},'{17}',{18})";
sql = String.Format(sql, info.RID, info.NameEN, info.NameCN, info.NameBig5, info.Code, info.CodeNum, info.CodeEN, info.Spell, info.SpellHeader, info.ProirNum, info.DeptId, info.IsUsed == true?"1":"0", info.ParentID, info.UserID, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion());
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XCodeEquipmentCustTypeInfo codeequipmentcusttype = modelInfo as XCodeEquipmentCustTypeInfo;
if (codeequipmentcusttype == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XCodeEquipmentCustTypeInfo info = modelInfo as XCodeEquipmentCustTypeInfo;
sql = "Update " + this.TableName + " Set NameEN='{0}',NameCN='{1}',NameBig5='{2}',Code='{3}',CodeNum={4},CodeEN='{5}',Spell='{6}',SpellHeader='{7}',ProirNum={8},DeptId='{9}',IsUsed='{10}',ParentID='{11}',UserID='{12}',Remark='{13}',UpdateUserId='{14}',UpdateTime={15} Where RID='{16}'";
sql = string.Format(sql, info.NameEN, info.NameCN, info.NameBig5, info.Code, info.CodeNum, info.CodeEN, info.Spell, info.SpellHeader, info.ProirNum, info.DeptId, info.IsUsed == true?"1":"0", info.ParentID, info.UserID, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RID);
return(sql);
}
protected override string GetValueMember(XModelBase selectedModel)
{
XCodeEquipmentCustTypeInfo info = selectedModel as XCodeEquipmentCustTypeInfo;
if (info != null)
{
return(info.RID);
}
else
{
return(string.Empty);
}
}
protected override string GetDisplayMember(Model.XModelBase selectedModel)
{
XCodeEquipmentCustTypeInfo info = selectedModel as XCodeEquipmentCustTypeInfo;
if (info != null)
{
return(info.NameCN);
}
else
{
return(string.Empty);
}
}
/// <summary>
/// 设置修改时的默认值
/// </summary>
protected override void SetDefaultValue()
{
XCodeEquipmentCustTypeInfo info = this.m_CurrentModel as XCodeEquipmentCustTypeInfo;
this.txtNameEN.Text = info.NameEN;
this.txtNameCN.Text = info.NameCN;
this.txtNameBig5.Text = info.NameBig5;
this.txtCode.Text = info.Code;
this.nebCodeNum.Value = info.CodeNum;
this.txtCodeEN.Text = info.CodeEN;
this.txtSpell.Text = info.Spell;
this.txtSpellHeader.Text = info.SpellHeader;
this.nebProirNum.Value = info.ProirNum;
this.txtDeptId.Text = info.DeptId;
this.chkIsUsed.Checked = info.IsUsed;
this.txtParentID.Text = info.ParentID;
this.txtUserID.Text = info.UserID;
this.txtRemark.Text = info.Remark;
}
