/// <summary>
/// 获取删除时插入日志表sql
/// </summary>
/// <param name="modelInfo"></param>
/// <param name="userId"></param>
/// <returns></returns>
protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId)
{
XStandEquipmentCheckRecordInfo info = modelInfo as XStandEquipmentCheckRecordInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,StandEqupimentId,CheckUserName,CheckDesc,CheckDate,NextCheckDate,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,OperateUserId,Operate,OperateTime,NewID) SELECT RID,StandEqupimentId,CheckUserName,CheckDesc,CheckDate,NextCheckDate,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)
{
XStandEquipmentCheckRecordInfo info = modelInfo as XStandEquipmentCheckRecordInfo;
string sql = "Insert Into " + this.TableName + "(RID,StandEqupimentId,CheckUserName,CheckDesc,CheckDate,NextCheckDate,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime)Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},'{9}',{10})";
sql = String.Format(sql, info.RID, info.StandEqupimentId, info.CheckUserName, info.CheckDesc, info.CheckDate, info.NextCheckDate, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion());
return(sql);
}
protected override string GetInsertAfterSql(XModelBase modelInfo)
{
XStandEquipmentCheckRecordInfo recordInfo = modelInfo as XStandEquipmentCheckRecordInfo;
string sql = "UPDATE StandEquipment SET NextCheckDate='" + recordInfo.NextCheckDate +
"',EquipmentStatusId='送检' WHERE RID='" + recordInfo.StandEqupimentId + "';";
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XStandEquipmentCheckRecordInfo standequipmentcheckrecord = modelInfo as XStandEquipmentCheckRecordInfo;
if (standequipmentcheckrecord == 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;
XStandEquipmentCheckRecordInfo info = modelInfo as XStandEquipmentCheckRecordInfo;
sql = "Update " + this.TableName + " Set StandEqupimentId='{0}',CheckUserName='******',CheckDesc='{2}',CheckDate='{3}',NextCheckDate='{4}',Remark='{5}',UpdateUserId='{6}',UpdateTime={7} Where RID='{8}'";
sql = string.Format(sql, info.StandEqupimentId, info.CheckUserName, info.CheckDesc, info.CheckDate, info.NextCheckDate, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RID);
return(sql);
}
/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XStandEquipmentCheckRecordInfo info = modelInfo as XStandEquipmentCheckRecordInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.StandEqupimentId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "StandEqupimentId")); //设备ID
info.CheckUserName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckUserName")); //检定人
info.CheckDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckDesc")); //检定描述
info.CheckDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckDate")); //检定日期
info.NextCheckDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "NextCheckDate")); //下次送检时间
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")); //修改时间
}
