/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XCodeEquipmentTypeInfo info = modelInfo as XCodeEquipmentTypeInfo;
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.RuleCode = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RuleCode")); //编号规则
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>
/// 填充实体信息
/// </summary>
protected override void FillModelInfo()
{
XCodeEquipmentTypeInfo info = this.m_CurrentModel as XCodeEquipmentTypeInfo;
if (this.m_EditStatus == XEditStatus.AddNew || this.m_EditStatus == XEditStatus.AddContinue)
{
info.RID = this.GetNewId();
}
info.NameEN = this.txtNameEN.Text;
info.NameCN = this.txtNameCN.Text;
info.RuleCode = this.txtRuleCode.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.Spell = this.txtStandId.ValueMember;
info.SpellHeader = this.txtStandId.DisplayMember;
info.ProirNum = XHelper.GetInt(this.nebProirNum.Value);
base.FillModelInfo();
}
/// <summary>
/// 获取删除时插入日志表sql
/// </summary>
/// <param name="modelInfo"></param>
/// <param name="userId"></param>
/// <returns></returns>
protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId)
{
XCodeEquipmentTypeInfo info = modelInfo as XCodeEquipmentTypeInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,NameEN,NameCN,RuleCode,NameBig5,Code,CodeNum,CodeEN,Spell,SpellHeader,ProirNum,DeptId,IsUsed,ParentID,UserID,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,OperateUserId,Operate,OperateTime,NewID) SELECT RID,NameEN,NameCN,RuleCode,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>
/// 获取插入sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetInsertSql(XModelBase modelInfo)
{
XCodeEquipmentTypeInfo info = modelInfo as XCodeEquipmentTypeInfo;
string sql = "Insert Into " + this.TableName + "(RID,NameEN,NameCN,RuleCode,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}',{19})";
sql = String.Format(sql, info.RID, info.NameEN, info.NameCN, info.RuleCode, 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>
protected override void SetDefaultValue()
{
XCodeEquipmentTypeInfo info = this.m_CurrentModel as XCodeEquipmentTypeInfo;
this.txtNameCN.Text = info.NameCN;
//this.txtNameEN.Text = info.NameEN;
this.txtrid.Text = info.RID;
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XCodeEquipmentTypeInfo info = modelInfo as XCodeEquipmentTypeInfo;
sql = "Update " + this.TableName + " Set NameEN='{0}',NameCN='{1}',RuleCode='{2}',NameBig5='{3}',Code='{4}',CodeNum={5},CodeEN='{6}',Spell='{7}',SpellHeader='{8}',ProirNum={9},DeptId='{10}',IsUsed='{11}',ParentID='{12}',UserID='{13}',Remark='{14}',UpdateUserId='{15}',UpdateTime={16} Where RID='{17}'";
sql = string.Format(sql, info.NameEN, info.NameCN, info.RuleCode, 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);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XCodeEquipmentTypeInfo codeequipmenttype = modelInfo as XCodeEquipmentTypeInfo;
if (codeequipmenttype == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
protected override string GetValueMember(XModelBase selectedModel)
{
XCodeEquipmentTypeInfo info = selectedModel as XCodeEquipmentTypeInfo;
if (info != null)
{
return(info.RID);
}
else
{
return(string.Empty);
}
}
protected override string GetDisplayMember(Model.XModelBase selectedModel)
{
XCodeEquipmentTypeInfo info = selectedModel as XCodeEquipmentTypeInfo;
if (info != null)
{
return(info.NameCN);
}
else
{
return(string.Empty);
}
}
private void txtEquipmentType_TextChanged(object sender, EventArgs e)
{
XCodeEquipmentTypeInfo checkTypeInfo = this.txtEquipmentType.SelectedModel as XCodeEquipmentTypeInfo;
XEquipmentCheckBusiness business = this.m_Business as XEquipmentCheckBusiness;
if (checkTypeInfo != null)
{
if (this.txtEquipmentNo.Text.Trim() == string.Empty)
{
//生成设备编号
string equipmentNo = business.GetEquipmentNo(checkTypeInfo.RuleCode);
this.txtEquipmentNo.Text = equipmentNo;
}
string sqlget = "select * from codedef where NameEN='EquipmentType' and ParentID='" + checkTypeInfo.RID + "'";
DataTable dt = new DataTable();
dt = SQLHelper.GetDataSet(sqlget);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
if (cbodevselect.Items != null)
{
for (int i = 0; i < cbodevselect.Items.Count; i++)
{
cbodevselect.Items.RemoveAt(0);
i--;
}
}
cbodevselect.DataSource = dt;
cbodevselect.DisplayMember = "NameCN";
cbodevselect.ValueMember = "RID";
}
}
}
}
/// <summary>
/// 设置修改时的默认值
/// </summary>
protected override void SetDefaultValue()
{
XCodeEquipmentTypeInfo info = this.m_CurrentModel as XCodeEquipmentTypeInfo;
this.txtNameEN.Text = info.NameEN;
this.txtNameCN.Text = info.NameCN;
this.txtRuleCode.Text = info.RuleCode;
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;
if (info.Spell != string.Empty)
{
this.txtStandId.Text = info.SpellHeader;
this.txtStandId.ValueMember = info.Spell;
this.txtStandId.DisplayMember = info.SpellHeader;
}
this.nebProirNum.Value = info.ProirNum;
this.txtRemark.Text = info.Remark;
}