/// <summary>
/// 获取删除时插入日志表sql
/// </summary>
/// <param name="modelInfo"></param>
/// <param name="userId"></param>
/// <returns></returns>
protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId)
{
XEquipmentReceiveInfo info = modelInfo as XEquipmentReceiveInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,EquipmentCheckId,CheckUserId,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,ReceiveUserId,ReceiveDate,ReceiveDesc,CurrentStatus,FlowStatus,FlowUserId,CheckedUserId,CheckedDate,CheckedDesc,VerifyUserId,CheckedReport,VerifyedUserId,VerifyedDate,VerifyedDesc,SignUserId,SignedUserId,SignedDate,SignedDesc,DispatchUserId,IsBack,BackDate,BackReason,BackStatus,BackUserId,Quanlity,StandId,PdfReportFileName,OperateUserId,Operate,OperateTime,NewID) SELECT RID,EquipmentCheckId,CheckUserId,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,ReceiveUserId,ReceiveDate,ReceiveDesc,CurrentStatus,FlowStatus,FlowUserId,CheckedUserId,CheckedDate,CheckedDesc,VerifyUserId,CheckedReport,VerifyedUserId,VerifyedDate,VerifyedDesc,SignUserId,SignedUserId,SignedDate,SignedDesc,DispatchUserId,IsBack,BackDate,BackReason,BackStatus,BackUserId,Quanlity,StandId,PdfReportFileName,'" + userId + "','删除',getdate(),newid() FROM " + this.TableName + " WHERE " + this.PrimaryKey + "='" + info.RID + "'";
return(sql);
}
public string GetInsertSql4rev(XModelBase modelInfo)
{
XEquipmentReceiveInfo info = modelInfo as XEquipmentReceiveInfo;
string sql = "Insert Into EquipmentReceive(RID,EquipmentCheckId,CheckUserId,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,ReceiveUserId,ReceiveDate,ReceiveDesc,CurrentStatus,FlowStatus,FlowUserId,CheckedUserId,CheckedDate,CheckedDesc,VerifyUserId,CheckedReport,VerifyedUserId,VerifyedDate,VerifyedDesc,SignUserId,SignedUserId,SignedDate,SignedDesc,DispatchUserId,IsBack,BackDate,BackReason,BackStatus,BackUserId,Quanlity,StandId,PdfReportFileName)Values('{0}','{1}','{2}','{3}','{4}',{5},'{6}',{7},'{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}',{32},'{33}','{34}')";
sql = String.Format(sql, info.RID, info.EquipmentCheckId, info.CheckUserId, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion(), info.ReceiveUserId, info.ReceiveDate, info.ReceiveDesc, info.CurrentStatus, info.FlowStatus, info.FlowUserId, info.CheckedUserId, info.CheckedDate, info.CheckedDesc, info.VerifyUserId, info.CheckedReport, info.VerifyedUserId, info.VerifyedDate, info.VerifyedDesc, info.SignUserId, info.SignedUserId, info.SignedDate, info.SignedDesc, info.DispatchUserId, info.IsBack == true ? "1" : "0", info.BackDate, info.BackReason, info.BackStatus, info.BackUserId, info.Quanlity, info.StandId, info.PdfReportFileName);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XEquipmentReceiveInfo equipmentreceive = modelInfo as XEquipmentReceiveInfo;
if (equipmentreceive == 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;
XEquipmentReceiveInfo info = modelInfo as XEquipmentReceiveInfo;
sql = "Update " + this.TableName + " Set EquipmentCheckId='{0}',CheckUserId='{1}',Remark='{2}',UpdateUserId='{3}',UpdateTime={4},ReceiveUserId='{5}',ReceiveDate='{6}',ReceiveDesc='{7}',CurrentStatus='{8}',FlowStatus='{9}',FlowUserId='{10}',CheckedUserId='{11}',CheckedDate='{12}',CheckedDesc='{13}',VerifyUserId='{14}',CheckedReport='{15}',VerifyedUserId='{16}',VerifyedDate='{17}',VerifyedDesc='{18}',SignUserId='{19}',SignedUserId='{20}',SignedDate='{21}',SignedDesc='{22}',DispatchUserId='{23}',IsBack='{24}',BackDate='{25}',BackReason='{26}',BackStatus='{27}',BackUserId='{28}',Quanlity={29},StandId='{30}',PdfReportFileName='{31}' Where RID='{32}'";
sql = string.Format(sql, info.EquipmentCheckId, info.CheckUserId, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.ReceiveUserId, info.ReceiveDate, info.ReceiveDesc, info.CurrentStatus, info.FlowStatus, info.FlowUserId, info.CheckedUserId, info.CheckedDate, info.CheckedDesc, info.VerifyUserId, info.CheckedReport, info.VerifyedUserId, info.VerifyedDate, info.VerifyedDesc, info.SignUserId, info.SignedUserId, info.SignedDate, info.SignedDesc, info.DispatchUserId, info.IsBack == true?"1":"0", info.BackDate, info.BackReason, info.BackStatus, info.BackUserId, info.Quanlity, info.StandId, info.PdfReportFileName, info.RID);
return(sql);
}
/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XEquipmentReceiveInfo info = modelInfo as XEquipmentReceiveInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.EquipmentCheckId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "EquipmentCheckId")); //接收设备
info.CheckUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckUserId")); //检定员
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")); //修改时间
info.ReceiveUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ReceiveUserId")); //
info.ReceiveDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ReceiveDate")); //
info.ReceiveDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ReceiveDesc")); //
info.CurrentStatus = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CurrentStatus")); //
info.FlowStatus = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "FlowStatus")); //
info.FlowUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "FlowUserId")); //
info.CheckedUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckedUserId")); //
info.CheckedDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckedDate")); //
info.CheckedDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckedDesc")); //
info.VerifyUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "VerifyUserId")); //
info.CheckedReport = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckedReport")); //
info.VerifyedUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "VerifyedUserId")); //
info.VerifyedDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "VerifyedDate")); //
info.VerifyedDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "VerifyedDesc")); //
info.SignUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SignUserId")); //
info.SignedUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SignedUserId")); //
info.SignedDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SignedDate")); //
info.SignedDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SignedDesc")); //
info.DispatchUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "DispatchUserId")); //
info.IsBack = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "IsBack")) == "True"; //
info.BackDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "BackDate")); //
info.BackReason = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "BackReason")); //
info.BackStatus = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "BackStatus")); //
info.BackUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "BackUserId")); //
info.Quanlity = XHelper.GetInt(XDataRowHelper.GetFieldValue(modelRow, "Quanlity")); //
info.StandId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "StandId")); //
info.PdfReportFileName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "PdfReportFileName")); //
}