/// <summary>
/// 填充实体信息
/// </summary>
protected override void FillModelInfo()
{
XPassWordTmpInfo info = this.m_CurrentModel as XPassWordTmpInfo;
if (this.m_EditStatus == XEditStatus.AddNew)
{
info.RID = this.GetNewId();
info.ID = info.RID;
info.UserId = XCommon.LoginUsersInfo.RID;
info.UserName = XCommon.LoginUsersInfo.UserName;
}
info.PassDesc = this.txtPassDesc.Text;
info.PassStateId = this.txtPassStateId.Text;
info.UseIP = this.txtUseIP.Text;
info.UseStartTime = XHelper.GetFormatedTime(this.dtUseStartTime.Value);
info.UseEndTime = XHelper.GetFormatedTime(this.dtUseEndTime.Value);
info.UseLimit = XHelper.GetInt(this.nebUseLimit.Value);
info.IsTelAudit = this.chkIsTelAudit.Checked;
info.Remark = this.txtRemark.Text;
info.Password = this.txtPassword.Text.Trim();
base.FillModelInfo();
}
protected override bool ValidateDownLoadCustom()
{
bool isAllowDownLoad = false;
if (XCommon.LoginUsersInfo.IsDownPower)
{
isAllowDownLoad = true;
}
else
{
frmFileDownloadEdit frm = new frmFileDownloadEdit();
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.m_PasswordTempInfo = frm.PasswordTempInfo;
isAllowDownLoad = true;
}
}
if (!isAllowDownLoad)
{
//XMessageBox.ShowError("您没有下载文件的权限！");
return(false);
}
return(true);
}
/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XPassWordTmpInfo info = modelInfo as XPassWordTmpInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.PassDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "PassDesc")); //密码描述
info.UserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UserId")); //用户ID
info.UserName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UserName")); //用户名称
info.PassStateId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "PassStateId")); //密码状态
info.UseIP = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UseIP")); //使用IP
info.UseStartTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UseStartTime")); //使用开始时间
info.UseEndTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UseEndTime")); //使用结束时间
info.UseLimit = XHelper.GetInt(XDataRowHelper.GetFieldValue(modelRow, "UseLimit")); //使用期限
info.IsTelAudit = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "IsTelAudit")) == "True"; //是否手机审批
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.IsCheck = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "IsCheck")) == "True"; //
info.Auditor = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Auditor")); //
info.AuditTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "AuditTime")); //
info.Password = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Password")); //
}
/// <summary>
/// 获取删除时插入日志表sql
/// </summary>
/// <param name="modelInfo"></param>
/// <param name="userId"></param>
/// <returns></returns>
protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId)
{
XPassWordTmpInfo info = modelInfo as XPassWordTmpInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,PassDesc,UserId,UserName,PassStateId,UseIP,UseStartTime,UseEndTime,UseLimit,IsTelAudit,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,IsCheck,Auditor,AuditTime,Password,OperateUserId,Operate,OperateTime,NewID) SELECT RID,PassDesc,UserId,UserName,PassStateId,UseIP,UseStartTime,UseEndTime,UseLimit,IsTelAudit,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,IsCheck,Auditor,AuditTime,Password,'" + 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)
{
XPassWordTmpInfo info = modelInfo as XPassWordTmpInfo;
string sql = "Insert Into " + this.TableName + "(RID,PassDesc,UserId,UserName,PassStateId,UseIP,UseStartTime,UseEndTime,UseLimit,IsTelAudit,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,IsCheck,Auditor,AuditTime,Password)Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},'{9}','{10}','{11}',{12},'{13}',{14},'{15}','{16}','{17}','{18}')";
sql = String.Format(sql, info.RID, info.PassDesc, info.UserId, info.UserName, info.PassStateId, info.UseIP, info.UseStartTime, info.UseEndTime, info.UseLimit, info.IsTelAudit == true?"1":"0", info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion(), info.IsCheck == true?"1":"0", info.Auditor, info.AuditTime, info.Password);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XPassWordTmpInfo passwordtmp = modelInfo as XPassWordTmpInfo;
if (passwordtmp == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
private void InitPassword()
{
XPassWordTmpBusiness business = this.m_Business as XPassWordTmpBusiness;
this.m_PasswordTempInfo = business.GetValidTempPasswordInfo(XCommon.LoginUsersInfo.RID) as XPassWordTmpInfo;
if (this.m_PasswordTempInfo != null)
{
this.txtPassword.Text = this.m_PasswordTempInfo.Password;
}
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XPassWordTmpInfo info = modelInfo as XPassWordTmpInfo;
sql = "Update " + this.TableName + " Set PassDesc='{0}',UserId='{1}',UserName='******',PassStateId='{3}',UseIP='{4}',UseStartTime='{5}',UseEndTime='{6}',UseLimit={7},IsTelAudit='{8}',Remark='{9}',UpdateUserId='{10}',UpdateTime={11},IsCheck='{12}',Auditor='{13}',AuditTime='{14}',Password='******' Where RID='{16}'";
sql = string.Format(sql, info.PassDesc, info.UserId, info.UserName, info.PassStateId, info.UseIP, info.UseStartTime, info.UseEndTime, info.UseLimit, info.IsTelAudit == true?"1":"0", info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.IsCheck == true?"1":"0", info.Auditor, info.AuditTime, info.Password, info.RID);
return(sql);
}
protected override void SaveFunction()
{
XPassWordTmpBusiness business = this.m_Business as XPassWordTmpBusiness;
this.m_PasswordTempInfo = business.GetTempPasswordInfo(XCommon.LoginUsersInfo.RID,
this.txtPassword.Text.Trim()) as XPassWordTmpInfo;
if (this.m_PasswordTempInfo == null)
{
XMessageBox.ShowError("您输入的密码已失效或尚未审批通过！");
this.DialogResult = System.Windows.Forms.DialogResult.No;
return;
}
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
/// <summary>
/// 设置修改时的默认值
/// </summary>
protected override void SetDefaultValue()
{
XPassWordTmpInfo info = this.m_CurrentModel as XPassWordTmpInfo;
this.txtPassDesc.Text = info.PassDesc;
this.txtUserId.Text = info.UserId;
this.txtUserName.Text = info.UserName;
this.txtPassStateId.Text = info.PassStateId;
this.txtUseIP.Text = info.UseIP;
this.dtUseStartTime.Value = XHelper.GetDateTime(info.UseStartTime);
this.dtUseEndTime.Value = XHelper.GetDateTime(info.UseEndTime);
this.nebUseLimit.Value = info.UseLimit;
this.chkIsTelAudit.Checked = info.IsTelAudit;
this.txtPassword.Text = info.Password;
this.txtRepassword.Text = info.Password;
this.txtRemark.Text = info.Remark;
}
private void btnApplyPassword_Click(object sender, EventArgs e)
{
if (this.txtPassword.Text.Trim() == string.Empty)
{
XMessageBox.ShowError("请输入要申请的密码！");
return;
}
XPassWordTmpBusiness business = this.m_Business as XPassWordTmpBusiness;
XPassWordTmpInfo passwordTmpInfo = business.GetTempPasswordInfo(XCommon.LoginUsersInfo.RID)
as XPassWordTmpInfo;
if (passwordTmpInfo != null)
{
XMessageBox.ShowError("已存在有效期内的密码，请不要重复申请！");
return;
}
int validDays = XHelper.GetInt(ConfigurationManager.AppSettings["PassworkValidDays"]);
XPassWordTmpInfo newInfo = new XPassWordTmpInfo();
newInfo.RID = Guid.NewGuid().ToString();
newInfo.Password = this.txtPassword.Text.Trim();
newInfo.UseStartTime = XHelper.GetFormatedTime(DateTime.Now);
newInfo.UseEndTime = XHelper.GetFormatedTime(DateTime.Now.AddDays(validDays));
newInfo.UserId = XCommon.LoginUsersInfo.RID;
newInfo.UserName = XCommon.LoginUsersInfo.UserName;
newInfo.UseIP = XNetHelper.GetLocalIP4Address();
if (business.Insert(newInfo))
{
XMessageBox.ShowRemindMessage("密码申请成功，请等待审核！");
}
else
{
XMessageBox.ShowError("密码申请失败！");
}
}
protected override string GetModelKey(XModelBase model)
{
XPassWordTmpInfo info = model as XPassWordTmpInfo;
return(info.UserName + "-" + info.PassDesc);
}
