public bool SaveRemindConfig(XRemindConfigInfo remindConfigInfo,
IList <XUsersInfo> usersInfo, IList <XRoleInfo> roleInfos)
{
XRemindConfigProvider provider = this.m_Provider as XRemindConfigProvider;
return(provider.SaveRemindConfig(remindConfigInfo, usersInfo, roleInfos));
}
/// <summary>
/// 获取修改时插入历史表的sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetInsertUpdateHistorySql(XModelBase modelInfo)
{
XRemindConfigInfo info = modelInfo as XRemindConfigInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,ConfigType,RemindDays,RemindInfoTemplate,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,OperateUserId,Operate,OperateTime,NewID) SELECT RID,ConfigType,RemindDays,RemindInfoTemplate,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,'" + info.UpdateUserId + "','修改',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)
{
XRemindConfigInfo info = modelInfo as XRemindConfigInfo;
string sql = "Insert Into " + this.TableName + "(RID,ConfigType,RemindDays,RemindInfoTemplate,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime)Values('{0}','{1}',{2},'{3}','{4}','{5}',{6},'{7}',{8})";
sql = String.Format(sql, info.RID, info.ConfigType, info.RemindDays, info.RemindInfoTemplate, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion());
return(sql);
}
/// <summary>
/// 设置修改时的默认值
/// </summary>
protected override void SetDefaultValue()
{
XRemindConfigInfo info = this.m_CurrentModel as XRemindConfigInfo;
this.txtConfigType.Text = info.ConfigType;
this.nebRemindDays.Value = info.RemindDays;
this.txtRemindInfoTemplate.Text = info.RemindInfoTemplate;
this.txtRemark.Text = info.Remark;
}
private void grdData_Click(object sender, EventArgs e)
{
if (this.grdData.CurrentRow != null &&
this.grdData.CurrentRow.RowType == Janus.Windows.GridEX.RowType.Record)
{
XRemindConfigInfo remindConfigInfo = this.grdData.CurrentRow.DataRow as XRemindConfigInfo;
this.FillRemindRoles(remindConfigInfo);
this.FillRemindUsers(remindConfigInfo);
}
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XRemindConfigInfo info = modelInfo as XRemindConfigInfo;
sql = "Update " + this.TableName + " Set ConfigType='{0}',RemindDays={1},RemindInfoTemplate='{2}',Remark='{3}',UpdateUserId='{4}',UpdateTime={5} Where RID='{6}'";
sql = string.Format(sql, info.ConfigType, info.RemindDays, info.RemindInfoTemplate, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RID);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XRemindConfigInfo remindconfig = modelInfo as XRemindConfigInfo;
if (remindconfig == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
private void Edit()
{
if (this.grdData.CurrentRow != null || this.grdData.CurrentRow.RowType ==
Janus.Windows.GridEX.RowType.Record)
{
XRemindConfigInfo remindConfigInfo = this.grdData.CurrentRow.DataRow as XRemindConfigInfo;
frmRemindConfigEdit frm = new frmRemindConfigEdit(remindConfigInfo);
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.grdData.Refresh();
}
}
}
/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XRemindConfigInfo info = modelInfo as XRemindConfigInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.ConfigType = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ConfigType")); //提醒类型
info.RemindDays = XHelper.GetInt(XDataRowHelper.GetFieldValue(modelRow, "RemindDays")); //提醒天数
info.RemindInfoTemplate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RemindInfoTemplate")); //提醒信息模版
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")); //修改时间
}
private void btnSave_Click(object sender, EventArgs e)
{
XRemindConfigInfo remindConfigInfo = this.grdData.CurrentRow.DataRow as XRemindConfigInfo;
IList <XRoleInfo> selectedRoles = this.GetSelectedRoles();
IList <XUsersInfo> selectedUsers = this.GetSelectedUsers();
if (this.m_RemindConfigBusiness.SaveRemindConfig(remindConfigInfo, selectedUsers, selectedRoles))
{
XMessageBox.ShowRemindMessage("保存成功！");
}
else
{
XMessageBox.ShowError("保存失败！");
}
}
/// <summary>
/// 填充实体信息
/// </summary>
protected override void FillModelInfo()
{
XRemindConfigInfo info = this.m_CurrentModel as XRemindConfigInfo;
if (this.m_EditStatus == XEditStatus.AddNew || this.m_EditStatus == XEditStatus.AddContinue)
{
info.RID = this.GetNewId();
}
info.ConfigType = this.txtConfigType.Text;
info.RemindDays = XHelper.GetInt(this.nebRemindDays.Value);
info.RemindInfoTemplate = this.txtRemindInfoTemplate.Text;
info.Remark = this.txtRemark.Text;
base.FillModelInfo();
}
private void FillRemindRoles(XRemindConfigInfo remindInfo)
{
if (remindInfo != null)
{
IList <XModelBase> remindRoleInfos = this.m_RemindRoleBusiness.GetRemindRoles(remindInfo.RID);
foreach (XTreeNode treeNode in this.tvRole.Nodes)
{
string roleCode = treeNode.Code;
if (IsRoleInRemindRoles(roleCode, remindRoleInfos))
{
//如果有该角色，则勾选
treeNode.Checked = true;
}
else
{
treeNode.Checked = false;
}
}
}
}
private void FillRemindUsers(XRemindConfigInfo remindInfo)
{
if (remindInfo != null)
{
IList <XModelBase> remindUsersInfo = this.m_RemindUsersBusiness.GetRemindUsers(remindInfo.RID);
foreach (XTreeNode treeNode in this.tvUsers.Nodes)
{
string userId = treeNode.Code;
if (IsRoleInRemindUsers(userId, remindUsersInfo))
{
//如果有该角色，则勾选
treeNode.Checked = true;
}
else
{
treeNode.Checked = false;
}
}
}
}
public bool SaveRemindConfig(XRemindConfigInfo remindConfigInfo,
IList <XUsersInfo> usersInfo, IList <XRoleInfo> roleInfos)
{
string sql = string.Empty;
sql += "DELETE FROM RemindRoles WHERE ConfigId='" + remindConfigInfo.RID + "';";
sql += "DELETE FROM RemindUsers WHERE ConfigId='" + remindConfigInfo.RID + "';";
foreach (XUsersInfo userInfo in usersInfo)
{
sql += "INSERT INTO RemindUsers(RID,ConfigId,UserId)VALUES(NEWID(),'" +
remindConfigInfo.RID + "','" + userInfo.RID + "');";
}
foreach (XRoleInfo roleInfo in roleInfos)
{
sql += "INSERT INTO RemindRoles(RID,ConfigId,RoleId)VALUES(NEWID(),'" +
remindConfigInfo.RID + "','" + roleInfo.RID + "');";
}
return(this.m_DataAccess.ExecuteNonQueryByTrans(sql) > 0);
}
