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); }