/// <summary> /// 获取删除时插入日志表sql /// </summary> /// <param name="modelInfo"></param> /// <param name="userId"></param> /// <returns></returns> protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId) { XStandardInfo info = modelInfo as XStandardInfo; string sql = "Insert Into " + this.HistoryTableName + "(RID,StandNo,StandName,CreateTime,NextCheckTime,CheckTimes,ChargeUserId,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,StandStatus,StandDesc,OperateUserId,Operate,OperateTime,NewID) SELECT RID,StandNo,StandName,CreateTime,NextCheckTime,CheckTimes,ChargeUserId,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,StandStatus,StandDesc,'" + 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) { XStandardInfo info = modelInfo as XStandardInfo; string sql = "Insert Into " + this.TableName + "(RID,StandNo,StandName,CreateTime,NextCheckTime,CheckTimes,ChargeUserId,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,StandStatus,StandDesc)Values('{0}','{1}','{2}','{3}','{4}',{5},'{6}','{7}','{8}',{9},'{10}',{11},'{12}','{13}')"; sql = String.Format(sql, info.RID, info.StandNo, info.StandName, info.CreateTime, info.NextCheckTime, info.CheckTimes, info.ChargeUserId, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion(), info.StandStatus, info.StandDesc); return(sql); }
/// <summary> /// 获取更新Sql /// </summary> /// <param name="modelInfo"></param> /// <returns></returns> public override string GetUpdateSql(XModelBase modelInfo) { string sql = String.Empty; XStandardInfo info = modelInfo as XStandardInfo; sql = "Update " + this.TableName + " Set StandNo='{0}',StandName='{1}',CreateTime='{2}',NextCheckTime='{3}',CheckTimes={4},ChargeUserId='{5}',Remark='{6}',UpdateUserId='{7}',UpdateTime={8},StandStatus='{9}',StandDesc='{10}' Where RID='{11}'"; sql = string.Format(sql, info.StandNo, info.StandName, info.CreateTime, info.NextCheckTime, info.CheckTimes, info.ChargeUserId, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.StandStatus, info.StandDesc, info.RID); return(sql); }
/// <summary> /// 自定义修改校验 /// </summary> /// <param name="modelInfo"></param> /// <returns></returns> protected override string GetValidateUpdateCustom(XModelBase modelInfo) { string validateInfo = string.Empty; XStandardInfo standard = modelInfo as XStandardInfo; if (standard == null) { return(this.GetNotRightType()); } return(string.Empty); }
protected override string GetValueMember(XModelBase selectedModel) { XStandardInfo info = selectedModel as XStandardInfo; if (info != null) { return(info.RID); } else { return(string.Empty); } }
protected override string GetDisplayMember(Model.XModelBase selectedModel) { XStandardInfo info = selectedModel as XStandardInfo; if (info != null) { return(info.StandName); } else { return(string.Empty); } }
/// <summary> /// 将数据行转换为实体 /// </summary> /// <param name="modelRow">数据行记录</param> /// <returns>实体信息</returns> protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow) { XStandardInfo info = modelInfo as XStandardInfo; info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键 info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键 info.StandNo = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "StandNo")); //标准编号 info.StandName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "StandName")); //标准名称 info.CreateTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CreateTime")); //创建时间 info.NextCheckTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "NextCheckTime")); //下次考核时间 info.CheckTimes = XHelper.GetInt(XDataRowHelper.GetFieldValue(modelRow, "CheckTimes")); //已考核次数 info.ChargeUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ChargeUserId")); //负责人 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.StandStatus = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "StandStatus")); // info.StandDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "StandDesc")); // }