protected override void FillDetailMainId(XModelBase detailInfo, XModelBase mainInfo)
{
XStaffCItemInfo cItemInfo = detailInfo as XStaffCItemInfo;
XStaffInfoInfo staffInfo = mainInfo as XStaffInfoInfo;
cItemInfo.UserId = staffInfo.ID;
}
/// <summary>
/// 获取修改时插入历史表的sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetInsertUpdateHistorySql(XModelBase modelInfo)
{
XStaffCItemInfo info = modelInfo as XStaffCItemInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,UserId,CItemId,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,OperateUserId,Operate,OperateTime,NewID) SELECT RID,UserId,CItemId,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,'" + info.UpdateUserId + "','修改',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)
{
XStaffCItemInfo info = modelInfo as XStaffCItemInfo;
string sql = "Insert Into " + this.TableName + "(RID,UserId,CItemId,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime)Values('{0}','{1}','{2}','{3}','{4}',{5},'{6}',{7})";
sql = String.Format(sql, info.RID, info.UserId, info.CItemId, 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;
XStaffCItemInfo info = modelInfo as XStaffCItemInfo;
sql = "Update " + this.TableName + " Set UserId='{0}',CItemId='{1}',Remark='{2}',UpdateUserId='{3}',UpdateTime={4} Where RID='{5}'";
sql = string.Format(sql, info.UserId, info.CItemId, 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;
XStaffCItemInfo staffcitem = modelInfo as XStaffCItemInfo;
if (staffcitem == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XStaffCItemInfo info = modelInfo as XStaffCItemInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //
info.UserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UserId")); //
info.CItemId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CItemId")); //
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>
/// <param name="itemInfo"></param>
/// <returns></returns>
private bool IsHaveItem(XCodeCItemInfo itemInfo)
{
if (this.m_DetailLists == null)
{
return(false);
}
foreach (XModelBase model in this.m_DetailLists)
{
XStaffCItemInfo staffItemInfo = model as XStaffCItemInfo;
if (staffItemInfo.CItemId == itemInfo.RID)
{
return(true);
}
}
return(false);
}
