/// <summary>
/// 获取删除时插入日志表sql
/// </summary>
/// <param name="modelInfo"></param>
/// <param name="userId"></param>
/// <returns></returns>
protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId)
{
XUseDeptInfo info = modelInfo as XUseDeptInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,ParentID,DeptName,NameNum,Spell,SpellHeader,IsUsed,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,OperateUserId,Operate,OperateTime,NewID) SELECT RID,ParentID,DeptName,NameNum,Spell,SpellHeader,IsUsed,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)
{
XUseDeptInfo info = modelInfo as XUseDeptInfo;
string sql = "Insert Into " + this.TableName + "(RID,ParentID,DeptName,NameNum,Spell,SpellHeader,IsUsed,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime)Values('{0}','{1}','{2}',{3},'{4}','{5}','{6}','{7}','{8}',{9},'{10}',{11})";
sql = String.Format(sql, info.RID, info.ParentID, info.DeptName, info.NameNum, info.Spell, info.SpellHeader, info.IsUsed == true?"1":"0", info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion());
return(sql);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XUseDeptInfo info = modelInfo as XUseDeptInfo;
sql = "Update " + this.TableName + " Set ParentID='{0}',DeptName='{1}',NameNum={2},Spell='{3}',SpellHeader='{4}',IsUsed='{5}',Remark='{6}',UpdateUserId='{7}',UpdateTime={8} Where RID='{9}'";
sql = string.Format(sql, info.ParentID, info.DeptName, info.NameNum, info.Spell, info.SpellHeader, info.IsUsed == true?"1":"0", info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RID);
return(sql);
}
protected override void FillEditControl(XModelBase modelBase)
{
XUseDeptInfo deptInfo = modelBase as XUseDeptInfo;
this.txtDeptName.Text = deptInfo.DeptName;
this.txtSpell.Text = deptInfo.Spell;
this.txtSpellHeader.Text = deptInfo.SpellHeader;
this.txtRemark.Text = deptInfo.Remark;
this.chkIsUsed.Checked = deptInfo.IsUsed;
this.nebNameNum.Value = deptInfo.NameNum;
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XUseDeptInfo usedept = modelInfo as XUseDeptInfo;
if (usedept == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 设置修改时的默认值
/// </summary>
protected override void SetDefaultValue()
{
XUseDeptInfo info = this.m_CurrentModel as XUseDeptInfo;
this.txtParentID.Text = info.ParentID;
this.txtDeptName.Text = info.DeptName;
this.nebNameNum.Value = info.NameNum;
this.txtSpell.Text = info.Spell;
this.txtSpellHeader.Text = info.SpellHeader;
this.chkIsUsed.Checked = info.IsUsed;
this.txtRemark.Text = info.Remark;
}
protected override string GetValueMember(XModelBase selectedModel)
{
XUseDeptInfo useDeptInfo = selectedModel as XUseDeptInfo;
if (useDeptInfo != null)
{
return(useDeptInfo.RID);
}
else
{
return(string.Empty);
}
}
protected override string GetDisplayMember(Model.XModelBase selectedModel)
{
XUseDeptInfo deptInfo = selectedModel as XUseDeptInfo;
if (deptInfo != null)
{
return(deptInfo.DeptName);
}
else
{
return(string.Empty);
}
}
/// <summary>
/// 填充实体信息
/// </summary>
protected override void FillModelInfo()
{
XUseDeptInfo info = this.m_CurrentModel as XUseDeptInfo;
info.ParentID = this.txtParentID.Text;
info.DeptName = this.txtDeptName.Text;
info.NameNum = XHelper.GetInt(this.nebNameNum.Value);
info.Spell = this.txtSpell.Text;
info.SpellHeader = this.txtSpellHeader.Text;
info.IsUsed = this.chkIsUsed.Checked;
info.Remark = this.txtRemark.Text;
base.FillModelInfo();
}
/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XUseDeptInfo info = modelInfo as XUseDeptInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.ParentID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ParentID")); //父级主键
info.DeptName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "DeptName")); //部门名称
info.NameNum = XHelper.GetInt(XDataRowHelper.GetFieldValue(modelRow, "NameNum")); //数值代码
info.Spell = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Spell")); //拼音
info.SpellHeader = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SpellHeader")); //拼音头
info.IsUsed = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "IsUsed")) == "True"; //是否可用
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>
/// <returns></returns>
private IList <XUseDeptInfo> GetSelectedDepts()
{
IList <XUseDeptInfo> deptInfos = new List <XUseDeptInfo>();
foreach (XTreeNode treeNode in this.tvDepts.Nodes)
{
if (treeNode.Checked)
{
XUseDeptInfo deptInfo = treeNode.Model as XUseDeptInfo;
if (deptInfo != null)
{
deptInfos.Add(deptInfo);
}
}
}
return(deptInfos);
}
protected override void FillModelInfo()
{
XUseDeptInfo deptInfo = this.m_CurrentModel as XUseDeptInfo;
if (string.IsNullOrEmpty(deptInfo.RID))
{
deptInfo.RID = Guid.NewGuid().ToString();
deptInfo.ID = deptInfo.RID;
}
deptInfo.DeptName = this.txtDeptName.Text.Trim();
deptInfo.Spell = this.txtSpell.Text.Trim();
deptInfo.SpellHeader = this.txtSpellHeader.Text.Trim();
deptInfo.Remark = this.txtRemark.Text.Trim();
if (string.IsNullOrEmpty(deptInfo.ParentID))
{
deptInfo.ParentID = this.GetParentID();
}
deptInfo.IsUsed = this.chkIsUsed.Checked;
deptInfo.NameNum = XHelper.GetInt(this.nebNameNum.Value);
}
private void InitDeptTree()
{
this.tvDepts.Nodes.Clear();
IList <XModelBase> deptInfos = this.m_DeptBusiness.GetAll();
foreach (XModelBase modelInfo in deptInfos)
{
XUseDeptInfo deptInfo = modelInfo as XUseDeptInfo;
XTreeNode treeNode = new XTreeNode();
treeNode.Code = deptInfo.ID;
treeNode.Name = deptInfo.DeptName;
treeNode.Model = deptInfo;
//treeNode.Text = "(" + roleInfo.ID + ")" + roleInfo.RoleName;
treeNode.Text = deptInfo.DeptName;
this.tvDepts.Nodes.Add(treeNode);
}
}
protected override string GetModelText(XModelBase model)
{
XUseDeptInfo deptInfo = model as XUseDeptInfo;
return(deptInfo.DeptName);
}
