/// <summary> /// 保存 /// </summary> /// <param name="frmbase"></param> protected override void SetSaveDataProc(frmBaseToolEntryXC frmbase) { try { base.SetSaveDataProc(frmbase); } catch (Exception ex) { log.Error(ex); XtraMsgBox.Show("新增数据失败!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error, ex, this.GetType()); } }
protected override void SetSaveDataProc(frmBaseToolEntryXC frmbase) { gridView1.CloseEditor(); gridView1.UpdateCurrentRow(); base.SetSaveDataProc(frmbase); }
/// <summary> /// 数据查询功能处理 /// </summary> protected virtual void SetSearchProc(frmBaseToolEntryXC frmBaseToolXC) { try { //获取表格一览信息 GetDspDataList(); } catch (Exception ex) { throw ex; } }
/// <summary> /// 保存数据功能处理 /// </summary> protected virtual void SetSaveDataProc(frmBaseToolEntryXC frmbase) { bool isSucces = false; int RtnValue = -1; //画面数据验证处理 if (!this.validData.Validate()) { return; } //获取需要编辑数据信息 this.GetGrpDataItem(); //数据检查功能处理 this.GetInputCheck(ref isSucces); if (!isSucces) { return; } switch (frmbase.ScanMode) { case Common.DataModifyMode.add: //if (XtraMsgBox.Show("确定要新增吗(Y/N)?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) return; SetInsertProc(ref RtnValue); break; case Common.DataModifyMode.copyadd: SetCopyInsertProc(ref RtnValue); break; case Common.DataModifyMode.upd: //if (XtraMsgBox.Show("确定要修改吗(Y/N)?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) return; SetModifyProc(ref RtnValue); break; case Common.DataModifyMode.del: if (XtraMsgBox.Show("确定要删除吗(Y/N)?", this.Text , MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) return; SetDeleteProc(ref RtnValue); break; default : this.ScanMode = Common.DataModifyMode.dsp; break; } //数据刷新功能处理 if (RtnValue > 0) { this.ScanMode = Common.DataModifyMode.dsp; SetRefreshProc(this); SetCancelInit(true); } }
/// <summary> /// 设定工具栏的有效性 /// </summary> /// <param name="mode">编辑的状态</param> public static void SetCmdControl(frmBaseToolEntryXC frmbase) { switch (frmbase.ScanMode) { case Common.DataModifyMode.dsp: //初始化状态 frmbase.NewButtonEnabled = true; frmbase.SaveButtonEnabled = false; frmbase.CancelButtonEnabled = false; frmbase.SearchButtonEnabled = true; frmbase.RefreshButtonEnabled = true; frmbase.PrintButtonEnabled = true; frmbase.ExcelButtonEnabled = true; frmbase.DeleteButtonEnabled = true; frmbase.EditButtonEnabled = true; //if (RecordCount > 0) //{ // frmbase.PrintButtonEnabled = true; // frmbase.ExcelButtonEnabled = true; // frmbase.DeleteButtonEnabled = true; // frmbase.EditButtonEnabled = true; //} //else //{ // frmbase.PrintButtonEnabled = false; // frmbase.ExcelButtonEnabled = false; // frmbase.DeleteButtonEnabled = false; // frmbase.EditButtonEnabled = false; //} break; case Common.DataModifyMode.add: //添加状态 frmbase.NewButtonEnabled = false; frmbase.PrintButtonEnabled = false; frmbase.ImportButtonEnabled = false; frmbase.SaveButtonEnabled = true; frmbase.CancelButtonEnabled = true; frmbase.ExcelButtonEnabled = false; frmbase.SearchButtonEnabled = false; frmbase.EditButtonEnabled = false; frmbase.DeleteButtonEnabled = false; frmbase.RefreshButtonEnabled = false; break; case Common.DataModifyMode.upd: //修改状态 frmbase.NewButtonEnabled = false; frmbase.PrintButtonEnabled = false; frmbase.ImportButtonEnabled = false; frmbase.SaveButtonEnabled = true; frmbase.CancelButtonEnabled = true; frmbase.ExcelButtonEnabled = false; frmbase.SearchButtonEnabled = false; frmbase.EditButtonEnabled = false; frmbase.DeleteButtonEnabled = false; frmbase.RefreshButtonEnabled = false; break; case Common.DataModifyMode.del: //删除状态 frmbase.NewButtonEnabled = false; frmbase.PrintButtonEnabled = false; frmbase.ImportButtonEnabled = false; frmbase.SaveButtonEnabled = true; frmbase.CancelButtonEnabled = true; frmbase.ExcelButtonEnabled = false; frmbase.SearchButtonEnabled = false; frmbase.EditButtonEnabled = false; frmbase.DeleteButtonEnabled = false; frmbase.RefreshButtonEnabled = false; break; } if (Common._isHistory) { frmbase.cmdNew.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; frmbase.cmdEdit.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; frmbase.cmdDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; frmbase.cmdCancel.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; frmbase.cmdSave.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; } }
/// <summary> /// 保存 /// </summary> /// <param name="frmbase"></param> protected override void SetSaveDataProc(frmBaseToolEntryXC frmbase) { DataRow _dr; try { gridView1.CloseEditor(); gridView1.UpdateCurrentRow(); gridView2.CloseEditor(); gridView2.UpdateCurrentRow(); bool isScuess = false; GetInputCheck(ref isScuess); if (!isScuess) return; int result = 0; DataTable dt_temp = ((DataView)gridView1.DataSource).ToTable(); DataTable dt_temp2 = ((DataView)gridView2.DataSource).ToTable(); string str_sql = string.Empty; Common.AdoConnect.Connect.CreateSqlTransaction(); m_dicPrimarName.Clear(); m_dicItemData.Clear(); for (int i = 0; i < dt_temp.Rows.Count; i++) { //如果Oper_Info表中没有数据 新增数据 str_sql = string.Format(@"select * from Oper_Info where OperID='{0}'", dt_temp.Rows[i]["UserID"].ToString()); DataTable dt = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); if (dt.Rows.Count > 0) { //回写账号状态和密码到Oper_Info表中 str_sql = string.Format(@"update Oper_Info set StatusID='{0}', Pwd='{1}' where OperID='{2}'", dt_temp.Rows[i]["statusID"].ToString(), dt_temp.Rows[i]["passWord"].ToString(), dt_temp.Rows[i]["UserID"].ToString()); result = SysParam.m_daoCommon.SetModifyDataItemBySql(str_sql, m_dicItemData, m_dicPrimarName, m_dicUserColum); //日志 SysParam.m_daoCommon.WriteLog("人员信息表", "修改", dt_temp.Rows[i]["UserID"].ToString()); } else { //新增用户到Oper_Info表中 m_dicItemData.Clear(); m_dicItemData["OperID"] = dt_temp.Rows[i]["UserID"].ToString(); m_dicItemData["TypeID"] = dt_temp.Rows[i]["OperType"].ToString(); m_dicItemData["StatusID"] = dt_temp.Rows[i]["StatusID"].ToString(); m_dicItemData["Pwd"] = dt_temp.Rows[i]["passWord"].ToString(); m_dicItemData["WebRole"] = ""; m_dicItemData["Memo"] = ""; result = SysParam.m_daoCommon.SetInsertDataItem(TableNames.Oper_Info, m_dicItemData); //日志 SysParam.m_daoCommon.WriteLog("人员信息", "新增", dt_temp.Rows[i]["UserID"].ToString()); } //SetSaveRoleOper(dt_temp2, dt_temp); //保存到人员和角色绑定表 str_sql = string.Format(@"select * from Oper_User_Role where UserID='{0}'", dt_temp.Rows[i]["UserID"].ToString()); dt = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); if (dt.Rows.Count > 0)//表中已存在该用户则是修改 { m_dicPrimarName.Clear(); m_dicPrimarName["UserID"] = dt_temp.Rows[i]["UserID"].ToString(); //先删除已存在的用户权限 m_dicItemData["UserID"] = dt_temp.Rows[i]["UserID"].ToString(); result = SysParam.m_daoCommon.SetDeleteDataItem("Oper_User_Role", m_dicItemData, m_dicPrimarName); //保存当前用户的角色信息 m_dicItemData.Clear(); for (int k = 0; k < dt_temp2.Rows.Count; k++) { _dr = dt_temp2.Rows[k]; if (!_dr["SlctValue"].ToString().ToLower().Equals("true")) { continue; } m_dicItemData["UserID"] = dt_temp.Rows[i]["UserID"].ToString(); m_dicItemData["OperID"] = Common._personid; m_dicItemData["RoleID"] = dt_temp2.Rows[k]["RoleID"].ToString(); m_dicItemData["ReMark"] = dt_temp2.Rows[k]["RoleName"].ToString(); m_dicItemData["operDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); result = SysParam.m_daoCommon.SetInsertDataItem("Oper_User_Role", m_dicItemData); //日志 SysParam.m_daoCommon.WriteLog("人员资料登记", "修改权限", dt_temp.Rows[i]["UserID"].ToString()); } } else //表中不存在该用户则是新增 { m_dicPrimarName.Clear(); m_dicPrimarName["UserID"] = dt_temp.Rows[i]["UserID"].ToString(); m_dicPrimarName["RoleID"] = dt_temp2.Rows[i]["RoleID"].ToString(); //保存当前用户的角色信息 m_dicItemData.Clear(); for (int k = 0; k < dt_temp2.Rows.Count; k++) { _dr = dt_temp2.Rows[k]; if (!_dr["SlctValue"].ToString().ToLower().Equals("true")) { continue; } m_dicItemData["UserID"] = dt_temp.Rows[i]["UserID"].ToString(); m_dicItemData["OperID"] = Common._personid; m_dicItemData["RoleID"] = dt_temp2.Rows[k]["RoleID"].ToString(); m_dicItemData["ReMark"] = dt_temp2.Rows[k]["RoleName"].ToString(); m_dicItemData["operDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); result = SysParam.m_daoCommon.SetInsertDataItem("Oper_User_Role", m_dicItemData, m_dicPrimarName); //日志 SysParam.m_daoCommon.WriteLog("人员信息登记", "新增权限", dt_temp.Rows[i]["UserID"].ToString()); } } } Common.AdoConnect.Connect.TransactionCommit(); XtraMsgBox.Show("保存数据成功!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); DialogResult = DialogResult.OK; } catch (Exception ex) { Common.AdoConnect.Connect.TransactionRollback(); XtraMsgBox.Show("保存数据失败!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error, ex, this.GetType()); } }