/// <summary>
/// 获取修改时插入历史表的sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetInsertUpdateHistorySql(XModelBase modelInfo)
{
XPassWord4FileInfo info = modelInfo as XPassWord4FileInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,PassWordTmpId,PassWord,DownLoadUserId,FileID,DownTime,Remark,OperateUserId,Operate,OperateTime,NewID) SELECT RID,PassWordTmpId,PassWord,DownLoadUserId,FileID,DownTime,Remark,'" + info.UpdateUserId + "','修改',getdate(),newid() FROM " + this.TableName + " WHERE " + this.PrimaryKey + "='" + info.RID + "'";
return(sql);
}
/// <summary>
/// 获取插入sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected string GetInsertCustomSql(XModelBase modelInfo)
{
XPassWord4FileInfo info = modelInfo as XPassWord4FileInfo;
string sql = "Insert Into " + this.TableName + "(RID,PassWordTmpId,PassWord,DownLoadUserId,FileID,DownTime,Remark)Values('{0}','{1}','{2}','{3}','{4}',{5},'{6}')";
sql = String.Format(sql, info.RID, info.PassWordTmpId, info.PassWord, info.DownLoadUserId, info.FileID, "getdate()", info.Remark);
return(sql);
}
/// <summary>
/// 获取插入sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetInsertSql(XModelBase modelInfo)
{
XPassWord4FileInfo info = modelInfo as XPassWord4FileInfo;
string sql = "Insert Into " + this.TableName + "(RID,PassWordTmpId,PassWord,DownLoadUserId,FileID,DownTime,Remark)Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')";
sql = String.Format(sql, info.RID, info.PassWordTmpId, info.PassWord, info.DownLoadUserId, info.FileID, info.DownTime, info.Remark);
return(sql);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XPassWord4FileInfo info = modelInfo as XPassWord4FileInfo;
sql = "Update " + this.TableName + " Set PassWordTmpId='{0}',PassWord='******',DownLoadUserId='{2}',FileID='{3}',DownTime='{4}',Remark='{5}' Where RID='{6}'";
sql = string.Format(sql, info.PassWordTmpId, info.PassWord, info.DownLoadUserId, info.FileID, info.DownTime, info.Remark, info.RID);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XPassWord4FileInfo password4file = modelInfo as XPassWord4FileInfo;
if (password4file == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XPassWord4FileInfo info = modelInfo as XPassWord4FileInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.PassWordTmpId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "PassWordTmpId")); //临时密码ID
info.PassWord = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "PassWord")); //下载密码
info.DownLoadUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "DownLoadUserId")); //下载用户ID
info.FileID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "FileID")); //下载文件ID
info.DownTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "DownTime")); //下载时间
info.Remark = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Remark")); //备注
}
protected override void DownloadAfter(string fileName, XModelBase model)
{
if (!XCommon.LoginUsersInfo.IsDownPower)
{
//如果不是超权限下载，则说明是通过密码下载
XFileListInfo fileInfo = this.m_CurrentModel as XFileListInfo;
XPassWord4FileInfo passFileInfo = new XPassWord4FileInfo();
if (this.m_PasswordTempInfo != null)
{
passFileInfo.RID = Guid.NewGuid().ToString();
passFileInfo.ID = passFileInfo.RID;
passFileInfo.DownLoadUserId = XCommon.LoginUsersInfo.RID;
passFileInfo.FileID = fileInfo.RID;
passFileInfo.PassWord = this.m_PasswordTempInfo.Password;
passFileInfo.PassWordTmpId = this.m_PasswordTempInfo.RID;
this.m_PassWord4FileBusiness.Insert(passFileInfo);
}
}
}
