public Sys_FunctionMaster_fum_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { Sys_FunctionMaster_fum_Info fum = new Sys_FunctionMaster_fum_Info(); Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info(); fum = KeyObject as Sys_FunctionMaster_fum_Info; try { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { IQueryable<Sys_FunctionMaster_fum> taQuery = (from ta in db.Sys_FunctionMaster_fum where ta.fum_iRecordID == fum.fum_iRecordID //orderby dpms.dpm_iRecordID ascending select ta).Take(1); if (taQuery != null) { //foreach (var t in taQuery) foreach (Sys_FunctionMaster_fum t in taQuery) { info = Common.General.CopyObjectValue<Sys_FunctionMaster_fum, Sys_FunctionMaster_fum_Info>(t); FindFormPurview(info); } } return info; } } catch (Exception Ex) { throw Ex; } }
private void btnFind_Click(object sender, EventArgs e) { try { Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info(); info.fum_cFunctionNumber = txtcNum.Text; DataBind(_sysFunctionMasterBL.SearchRecords(info)); } catch (Exception Ex) { ShowErrorMessage(Ex); } }
/// <summary> /// 新增權限功能 /// </summary> /// <param name="funcInfo">功能信息</param> /// <param name="sqlTrans">數據庫事務對象</param> /// <returns></returns> public bool AddFunction(Sys_FunctionMaster_fum_Info funcInfo, SqlTransaction sqlTrans) { bool res = false; if (funcInfo != null && !string.IsNullOrEmpty(funcInfo.fum_cFunctionNumber) && sqlTrans != null) { StringBuilder strSql = new StringBuilder(); strSql.AppendLine("INSERT INTO Sys_FunctionMaster_fum(fum_cFunctionNumber,fum_cFunctionDesc,fum_cRemark,fum_cAdd,fum_dAddDate,fum_cLast,fum_dLastDate) VALUES (@cFunctionNumber,@cFunctionDesc,@cRemark,@cAdd,GETDATE(),@cLast,GETDATE())"); try { List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(DbHelperSQL.MakeInParam("@cFunctionNumber", SqlDbType.VarChar, 30, funcInfo.fum_cFunctionNumber.Trim())); string strFuncName = string.Empty; if (!string.IsNullOrEmpty(funcInfo.fum_cFunctionDesc)) { strFuncName = funcInfo.fum_cFunctionDesc; } parameters.Add(DbHelperSQL.MakeInParam("@cFunctionDesc", SqlDbType.NVarChar, 100, strFuncName.Trim())); string strRemark = string.Empty; if (!string.IsNullOrEmpty(funcInfo.fum_cRemark)) { strRemark = funcInfo.fum_cRemark; } parameters.Add(DbHelperSQL.MakeInParam("@cRemark", SqlDbType.NVarChar, 200, strRemark.Trim())); string strAdd = string.Empty; if (!string.IsNullOrEmpty(funcInfo.fum_cAdd)) { strAdd = funcInfo.fum_cAdd; } parameters.Add(DbHelperSQL.MakeInParam("@cAdd", SqlDbType.NVarChar, 40, strAdd.Trim())); parameters.Add(DbHelperSQL.MakeInParam("@cLast", SqlDbType.NVarChar, 40, strAdd.Trim())); int iRes = DbHelperSQL.ExecuteNonQuery(sqlTrans, CommandType.Text, strSql.ToString(), parameters.ToArray()); if (iRes == 1) { return true; } } catch (Exception ex) { throw ex; } } return res; }
private void btnSelect_Click(object sender, EventArgs e) { Sys_FunctionMaster_fum_Info smcitem = null; _RtvInfo = new List<Sys_FunctionMaster_fum_Info>(); try { if (lvwMstr.SelectedItems.Count > 0) { for (int i = 0; i < lvwMstr.SelectedItems.Count; i++) { smcitem = new Sys_FunctionMaster_fum_Info(); smcitem.fum_iRecordID = Convert.ToInt32(lvwMstr.SelectedItems[i].SubItems[(int)enmLvwMaster.fum_iRecordID].Text); smcitem.fum_cFunctionNumber = lvwMstr.SelectedItems[i].SubItems[(int)enmLvwMaster.fum_cFunctionNumber].Text; smcitem.fum_cFunctionDesc = lvwMstr.SelectedItems[i].SubItems[(int)enmLvwMaster.fum_cFunctionDesc].Text; _RtvInfo.Add(smcitem); } } } catch (Exception Ex) { ShowErrorMessage(Ex); } this.DialogResult = DialogResult.OK; }
/// <summary> /// 新增權限功能 /// </summary> /// <param name="strFuncCode">功能編碼</param> /// <param name="strFuncName">功能名稱</param> /// <param name="strAdd">新增人</param> /// <returns></returns> public ReturnValueInfo AddFunction(string strFuncCode, string strFuncName, string strAdd) { ReturnValueInfo rvInfo = new ReturnValueInfo(); if (string.IsNullOrEmpty(strFuncCode)) { rvInfo.messageText = "新增失敗,功能編碼不能為空。"; return rvInfo; } if (string.IsNullOrEmpty(strFuncName)) { rvInfo.messageText = "新增失敗,功能名稱不能為空。"; return rvInfo; } try { using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { SqlTransaction transaction = null; conn.Open(); transaction = conn.BeginTransaction(); bool resOpt = false; try { Sys_FunctionMaster_fum_Info funcInfo = new Sys_FunctionMaster_fum_Info(); funcInfo.fum_cFunctionNumber = strFuncCode.Trim(); funcInfo.fum_cFunctionDesc = strFuncName.Trim(); funcInfo.fum_cRemark = string.Empty; funcInfo.fum_cAdd = strAdd; funcInfo.fum_cLast = strAdd; resOpt = this._RolesFuctionSettingDAL.AddFunction(funcInfo, transaction); rvInfo.boolValue = resOpt; } catch (Exception exSql) { throw exSql; } finally { rvInfo.boolValue = resOpt; if (resOpt) { transaction.Commit(); } else { transaction.Rollback(); } } } } catch (Exception ex) { rvInfo.isError = true; rvInfo.messageText = "新增失敗," + ex.Message; } return rvInfo; }
public Sys_FunctionMaster_fum_Info GetRecord_First() { try { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { IQueryable<Sys_FunctionMaster_fum> taQuery = (from ta in db.Sys_FunctionMaster_fum orderby ta.fum_iRecordID ascending select ta).Take(1); Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info(); if (taQuery.Count() > 0) { foreach (var t in taQuery) { info = Common.General.CopyObjectValue<Sys_FunctionMaster_fum, Sys_FunctionMaster_fum_Info>(t); FindFormPurview(info); } } return info; } } catch (Exception Ex) { throw Ex; } }
private Sys_FunctionMaster_fum_Info FindFormPurview(Sys_FunctionMaster_fum_Info info) { string sqlString = string.Empty; sqlString += "SELECT fom_cFormNumber,fom_cFormDesc " + Environment.NewLine; sqlString += "FROM Sys_FormMaster_fom " + Environment.NewLine; sqlString += "LEFT JOIN Sys_FormPurview_frp" + Environment.NewLine; sqlString += "ON fom_cFormNumber=frp_cFormNumber" + Environment.NewLine; sqlString += "LEFT JOIN Sys_FunctionMaster_fum" + Environment.NewLine; sqlString += "ON frp_cFunctionNumber=fum_cFunctionNumber WHERE fum_iRecordID='" + info.fum_iRecordID + "'"; IEnumerable<Sys_FormMaster_fom_Info> infos = null; List<Sys_FormMaster_fom_Info> infoList = null; try { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { infos = db.ExecuteQuery<Sys_FormMaster_fom_Info>(sqlString, new object[] { }); if (infos != null) { infoList = infos.ToList<Sys_FormMaster_fom_Info>(); } foreach (Sys_FormMaster_fom_Info t in infoList) { info.formMaster.Add(t); } return info; } } catch (Exception Ex) { throw Ex; } }
public bool UpdateRecord(Sys_FunctionMaster_fum_Info infoObject) { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { Sys_FunctionMaster_fum fum = new Sys_FunctionMaster_fum(); try { //fum = db.Sys_FunctionMaster_fum.SingleOrDefault(t => t.fum_iRecordID == infoObject.fum_iRecordID); //for (int i = 0; i < fum.Sys_FormPurview_frps.Count; i++) //{ // Sys_FormPurview_frp sta = fum.Sys_FormPurview_frps[i]; // db.Sys_FormPurview_frps.DeleteOnSubmit(sta); //} string sqlString = string.Empty; Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info(); //info = Common.General.CopyObjectValue<Sys_FunctionMaster_fum, Sys_FunctionMaster_fum_Info>(fum); IEnumerable<Sys_FunctionMaster_fum_Info> IEfum = null; IEnumerable<Sys_FormPurview_frp_Info> IEfrp = null; sqlString += "UPDATE Sys_FunctionMaster_fum" + Environment.NewLine; sqlString += " SET fum_cFunctionNumber='" + infoObject.fum_cFunctionNumber + "'," + Environment.NewLine; sqlString += " fum_cFunctionDesc='" + infoObject.fum_cFunctionDesc + "'," + Environment.NewLine; sqlString += " fum_cRemark='" + infoObject.fum_cRemark + "'," + Environment.NewLine; sqlString += " fum_cLast='" + infoObject.fum_cLast + "'," + Environment.NewLine; sqlString += " fum_dLastDate='" + infoObject.fum_dLastDate.Value.ToString(DefineConstantValue.gc_DateTimeFormat) + "'" + Environment.NewLine; sqlString += " WHERE fum_iRecordID='" + infoObject.fum_iRecordID + "'"; IEfum = db.ExecuteQuery<Sys_FunctionMaster_fum_Info>(sqlString, new object[] { }); sqlString = string.Empty; sqlString += "DELETE FROM Sys_FormPurview_frp WHERE frp_cFunctionNumber='" + infoObject.fum_cFunctionNumber + "'"; IEfrp = db.ExecuteQuery<Sys_FormPurview_frp_Info>(sqlString, new object[] { }); if (infoObject.formMaster != null && infoObject.formMaster.Count > 0) { for (int i = 0; i < infoObject.formMaster.Count; i++) { sqlString = string.Empty; Sys_FormMaster_fom_Info fomInfo = infoObject.formMaster[i]; string frp_code = infoObject.fum_cFunctionNumber + fomInfo.fom_cFormNumber; sqlString += "INSERT INTO Sys_FormPurview_frp" + Environment.NewLine; sqlString += "(frp_cPurviewCode, frp_cFunctionNumber, frp_cFormNumber)" + Environment.NewLine; sqlString += " VALUES " + Environment.NewLine; sqlString += "('" + frp_code + "','" + infoObject.fum_cFunctionNumber + "','" + fomInfo.fom_cFormNumber + "')"; IEfrp = db.ExecuteQuery<Sys_FormPurview_frp_Info>(sqlString, new object[] { }); } } //if (fum != null) //{ // ////usm = Common.General.SetDataToLingQEntity(usm, infoObject);//时间溢出 // //rlm.rlm_cRoleDesc = infoObject.rlm_cRoleDesc; // //rlm.rlm_cLast = infoObject.rlm_cLast; // //rlm.rlm_dLastDate = infoObject.rlm_dLastDate; // fum.fum_cFunctionNumber = infoObject.fum_cFunctionNumber; // fum.fum_cFunctionDesc = infoObject.fum_cFunctionDesc; // fum.fum_cRemark = infoObject.fum_cRemark; // fum.fum_cLast = infoObject.fum_cLast; // fum.fum_dLastDate = infoObject.fum_dLastDate.Value; // if (infoObject.formMaster != null && infoObject.formMaster.Count > 0) // { // for (int i = 0; i < infoObject.formMaster.Count; i++) // { // Sys_FormMaster_fom_Info usmInfo = infoObject.formMaster[i]; // Sys_FormPurview_frp item = new Sys_FormPurview_frp(); // item.frp_cFunctionNumber = infoObject.fum_cFunctionNumber; // item.frp_cFormNumber = usmInfo.fom_cFormNumber; // item.frp_cPurviewCode = item.frp_cFunctionNumber + item.frp_cFormNumber; // //courseitem.cum_cNumber; // fum.Sys_FormPurview_frps.Add(item); // //db.Sys_UserRoles_usrs.InsertOnSubmit(item); // } // } // db.SubmitChanges(); //} return true; } catch (Exception Ex) { throw Ex; } } }
private void ToolBar_BtnSearchClick(object sender, EventArgs e) { SysFunctionMasterSearch win = new SysFunctionMasterSearch(); win.ShowDialog(); if (win.DialogResult == DialogResult.OK) { //iRecordID = win.displayRecordID; iRecordID = win._RtvInfo[0].fum_iRecordID.ToString(); Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info(); try { info.fum_iRecordID = Convert.ToInt32(iRecordID); Model.IModel.IModelObject result = _sysFunctionMasterBL.DisplayRecord(info); info = result as Sys_FunctionMaster_fum_Info; } catch (Exception Ex) { ShowErrorMessage(Ex); } this.EditState = DefineConstantValue.EditStateEnum.OE_ReaOnly; SetTxtBox(DefineConstantValue.EditStateEnum.OE_ReaOnly); SetOpenToolBar(); ShowInfo(info); } win.Dispose(); win = null; }
private void ToolBar_BtnSaveClick(object sender, EventArgs e) { Model.General.ReturnValueInfo msg = new Model.General.ReturnValueInfo(); Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info(); Sys_FormMaster_fom_Info fomInfo = null; if (ChecktxtcName()) { if (txtcCode.Text == string.Empty) { msg.messageText = "功能编号" + Common.DefineConstantValue.SystemMessageText.strMessageText_W_CannotEmpty; ShowWarningMessage(msg.messageText); txtcCode.Focus(); } else { try { if (this.EditState == DefineConstantValue.EditStateEnum.OE_Update) { info.fum_iRecordID = Convert.ToInt32(iRecordID); } info.fum_cFunctionNumber = txtcCode.Text; info.fum_cFunctionDesc = txtcDesc.Text; for (int i = 0; i < lvwFrom.Items.Count; i++) { fomInfo = new Sys_FormMaster_fom_Info(); fomInfo.fom_cFormNumber = lvwFrom.Items[i].SubItems[0].Text; //userInfo.cum_cName = lvwMaster.Items[i].SubItems[1].Text; info.formMaster.Add(fomInfo); } if (this.EditState == DefineConstantValue.EditStateEnum.OE_Insert) { info.fum_cAdd = UserInformation.usm_cUserLoginID; info.fum_dAddDate = DateTime.Now; } info.fum_cLast = UserInformation.usm_cUserLoginID; info.fum_dLastDate = DateTime.Now; if (this.EditState == DefineConstantValue.EditStateEnum.OE_Update) { msg = _sysFunctionMasterBL.Save(info, DefineConstantValue.EditStateEnum.OE_Update); } else { msg = _sysFunctionMasterBL.Save(info, DefineConstantValue.EditStateEnum.OE_Insert); if (msg.boolValue) { Handel(DefineConstantValue.GetReocrdEnum.GR_Last); } } if (msg.messageText != null) ShowInformationMessage(msg.messageText); else { SetOpenToolBar(); SetTxtBox(DefineConstantValue.EditStateEnum.OE_ReaOnly); } } catch (Exception Ex) { ShowErrorMessage(Ex); } } } }
private void ToolBar_BtnDeleteClick(object sender, EventArgs e) { this.EditState = DefineConstantValue.EditStateEnum.OE_Delete; Model.General.ReturnValueInfo msg = new Model.General.ReturnValueInfo(); Model.Base.DataBaseCommandInfo com = new Model.Base.DataBaseCommandInfo(); Model.Base.DataBaseCommandKeyInfo comkey = new Model.Base.DataBaseCommandKeyInfo(); Sys_FunctionMaster_fum_Info Info = new Sys_FunctionMaster_fum_Info(); try { comkey.KeyValue = iRecordID; if (comkey.KeyValue != string.Empty && comkey.KeyValue != "0") { Info.fum_iRecordID = Convert.ToInt32(comkey.KeyValue); _sysFunctionMasterBL.Save(Info, Common.DefineConstantValue.EditStateEnum.OE_Delete); // SetOpenToolBar(); Handel(Common.DefineConstantValue.GetReocrdEnum.GR_Next); if (Info.fum_iRecordID == int.Parse(iRecordID)) { Handel(DefineConstantValue.GetReocrdEnum.GR_Previous); } SetOpenToolBar(); if (Info.fum_iRecordID == int.Parse(iRecordID)) { SetOpenToolBar(); ToolBar.BtnPreviousEnabled = false; ToolBar.BtnLastEnabled = false; ToolBar.BtnFirstEnabled = false; ToolBar.BtnNextEnabled = false; ToolBar.BtnModifyEnabled = false; ToolBar.BtnDeleteEnabled = false; ToolBar.BtnSearchEnabled = false; } } } catch (Exception Ex) { ShowErrorMessage(Ex); } }
private void ToolBar_BtnCancelClick(object sender, EventArgs e) { this.EditState = DefineConstantValue.EditStateEnum.OE_ReaOnly; Model.Base.DataBaseCommandKeyInfo comkey = new Model.Base.DataBaseCommandKeyInfo(); Sys_FunctionMaster_fum_Info Info = new Sys_FunctionMaster_fum_Info(); try { comkey.KeyValue = iRecordID; if (comkey.KeyValue != string.Empty && comkey.KeyValue != "0") { Info.fum_iRecordID = Convert.ToInt32(comkey.KeyValue); Model.IModel.IModelObject result = _sysFunctionMasterBL.DisplayRecord(Info); Info = result as Sys_FunctionMaster_fum_Info; ShowInfo(Info); SetOpenToolBar(); SetTxtBox(DefineConstantValue.EditStateEnum.OE_ReaOnly); } else { Handel(DefineConstantValue.GetReocrdEnum.GR_Last); } } catch (Exception Ex) { ShowErrorMessage(Ex); } }
/// <summary> /// 顯示數據 /// </summary> /// <param name="info"></param> private void ShowInfo(Sys_FunctionMaster_fum_Info info) { try { if (info != null) { iRecordID = info.fum_iRecordID.ToString(); txtcAdd.Text = info.fum_cAdd.ToString(); txtcLast.Text = info.fum_cLast.ToString(); txtcCode.Text = info.fum_cFunctionNumber.ToString(); txtcDesc.Text = info.fum_cFunctionDesc.ToString(); lvwFrom.Items.Clear(); lvwFrom.SetDataSource<Sys_FormMaster_fom_Info>(info.formMaster); txtdAddDate.Text = info.fum_dAddDate != null ? info.fum_dAddDate.Value.ToString(Common.DefineConstantValue.gc_DateFormat) : string.Empty; txtdLastDate.Text = info.fum_dLastDate != null ? info.fum_dLastDate.Value.ToString(Common.DefineConstantValue.gc_DateFormat) : string.Empty; } } catch (Exception Ex) { ShowErrorMessage(Ex); } }
/// <summary> /// 獲取用戶所擁有的權限列表 /// </summary> /// <param name="userID">用戶ID</param> /// <returns></returns> List<Sys_FunctionMaster_fum_Info> GetUserFunctionList(string userID) { List<Sys_FunctionMaster_fum_Info> functionList = null; string strSql = string.Empty; strSql = " SELECT rfs_cFunctionNumber FROM Sys_UserRoles_usr with(Nolock) " + Environment.NewLine; strSql += " INNER JOIN Sys_RolesFuctionSetting_rfs ON usr_cRoleID=rfs_cRoleID " + Environment.NewLine; strSql += " WHERE usr_cUserLoginID= '" + Common.General.HandleSqlSingle(userID.Trim()) + "' "; try { using (IDataReader dataReader = DbHelperSQL.ExecuteReader(strSql)) { functionList = new List<Sys_FunctionMaster_fum_Info>(); while (dataReader.Read()) { Sys_FunctionMaster_fum_Info function = new Sys_FunctionMaster_fum_Info(); function.fum_cFunctionNumber = dataReader["rfs_cFunctionNumber"].ToString().Trim(); functionList.Add(function); } dataReader.Close(); } } catch (Exception ex) { throw ex; } return functionList; }
void Change() { Sys_FunctionMaster_fum_Info fumInfo = new Sys_FunctionMaster_fum_Info(); usmTemp = new Sys_UserMaster_usm_Info(); rlmTemp = new Sys_RoleMaster_rlm_Info(); try { if (_lvwUserType == UserType.User.ToString()) { usmTemp.usm_cUserLoginID = _num; usmTemp.functionMasterList.Clear(); for (int i = 0; i < lvwPur.Items.Count; i++) { if (lvwPur.Items[i].Checked == true) { fumInfo = new Sys_FunctionMaster_fum_Info(); fumInfo.fum_cFunctionNumber = lvwPur.Items[i].SubItems[0].Text; usmTemp.functionMasterList.Add(fumInfo); } } for (int i = 0; i < uspInfoTemp.userMasterList.Count; i++) { if (uspInfoTemp.userMasterList[i].usm_cUserLoginID == _num) { uspInfoTemp.userMasterList[i] = usmTemp; } } } else { rlmTemp.rlm_cRoleID = _num; rlmTemp.functionMasterList.Clear(); for (int i = 0; i < lvwPur.Items.Count; i++) { if (lvwPur.Items[i].Checked == true) { fumInfo = new Sys_FunctionMaster_fum_Info(); fumInfo.fum_cFunctionNumber = lvwPur.Items[i].SubItems[0].Text; rlmTemp.functionMasterList.Add(fumInfo); } } for (int i = 0; i < uspInfoTemp.roleMasterList.Count; i++) { if (uspInfoTemp.roleMasterList[i].rlm_cRoleID == _num) { uspInfoTemp.roleMasterList[i] = rlmTemp; } } } } catch (Exception Ex) { ShowErrorMessage(Ex); } }
private void SysToolBar_BtnSaveClick(object sender, EventArgs e) { Sys_FormMaster_fom_Info info = new Sys_FormMaster_fom_Info(); Sys_FunctionMaster_fum_Info frmInfo = null; if (ChecktxtcName()) { if (txtcCode.Text == string.Empty) { _msg.messageText = "表单编号" + Common.DefineConstantValue.SystemMessageText.strMessageText_W_CannotEmpty; ShowWarningMessage(_msg.messageText); txtcCode.Focus(); } else if (txtcDesc.Text == string.Empty) { _msg.messageText = "表单描述" + Common.DefineConstantValue.SystemMessageText.strMessageText_W_CannotEmpty; ShowWarningMessage(_msg.messageText); txtcDesc.Focus(); } else { try { if (this.EditState == DefineConstantValue.EditStateEnum.OE_Update) { info.fom_iRecordID = Convert.ToInt32(_iRecordID); } info.fom_cFormNumber = txtcCode.Text; info.fom_cFormDesc = txtcDesc.Text; info.fom_cExePath = txtcPath.Text; if (this.EditState == DefineConstantValue.EditStateEnum.OE_Update) { info.fom_iParentID = Convert.ToInt32(_pCode); } if (this.EditState == DefineConstantValue.EditStateEnum.OE_Insert) { if (txtcParentCode.Text != string.Empty) { //info.fom_iParentID = Convert.ToInt32(_pCode); info.fom_iParentID = Convert.ToInt32(txtcParentCode.Text); } else { info.fom_iParentID = 0; } } info.fom_iIndex = Convert.ToInt32(txtcID.Text); for (int i = 0; i < lvwPur.Items.Count; i++) { frmInfo = new Sys_FunctionMaster_fum_Info(); frmInfo.fum_cFunctionNumber = lvwPur.Items[i].SubItems[0].Text; //userInfo.cum_cName = lvwMaster.Items[i].SubItems[1].Text; info.functionMaster.Add(frmInfo); } if (this.EditState == DefineConstantValue.EditStateEnum.OE_Insert) { info.fom_cAdd = UserInformation.usm_cUserLoginID; info.fom_dAddDate = DateTime.Now; } info.fom_cLast = UserInformation.usm_cUserLoginID; info.fom_dLastDate = DateTime.Now; if (this.EditState == DefineConstantValue.EditStateEnum.OE_Update) { _msg = _ISysFormMasterBL.Save(info, DefineConstantValue.EditStateEnum.OE_Update); } else { _msg = _ISysFormMasterBL.Save(info, DefineConstantValue.EditStateEnum.OE_Insert); } if (_msg.messageText != null) ShowInformationMessage(_msg.messageText); else { SetOpenToolBar(); SetTxtBox(DefineConstantValue.EditStateEnum.OE_ReaOnly); } BindTreeView(); } catch (Exception Ex) { ShowErrorMessage(Ex); } } } BindTreeView(); }
public bool InsertRecord(Sys_FunctionMaster_fum_Info infoObject) { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { Sys_FunctionMaster_fum fum = new Sys_FunctionMaster_fum(); try { fum = Common.General.CopyObjectValue<Sys_FunctionMaster_fum_Info, Sys_FunctionMaster_fum>(infoObject); if (infoObject.formMaster != null && infoObject.formMaster.Count > 0) { for (int i = 0; i < infoObject.formMaster.Count; i++) { Sys_FormMaster_fom_Info usmInfo = infoObject.formMaster[i]; Sys_FormPurview_frp item = new Sys_FormPurview_frp(); item.frp_cFunctionNumber = infoObject.fum_cFunctionNumber; item.frp_cFormNumber = usmInfo.fom_cFormNumber; item.frp_cPurviewCode = item.frp_cFunctionNumber + item.frp_cFormNumber; //courseitem.cum_cNumber; //fum.Sys_FormPurview_frps.Add(item); //db.Sys_UserRoles_usrs.InsertOnSubmit(item); } } db.Sys_FunctionMaster_fum.InsertOnSubmit(fum); db.SubmitChanges(); return true; } catch (Exception Ex) { throw Ex; } } }
private void DataBind(List<Model.IModel.IModelObject> list) { Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info(); lvwMstr.Items.Clear(); List<Sys_FunctionMaster_fum_Info> infoList = new List<Sys_FunctionMaster_fum_Info>(); try { foreach (var t in list) { info = t as Sys_FunctionMaster_fum_Info; infoList.Add(info); } lvwMstr.SetDataSource<Sys_FunctionMaster_fum_Info>(infoList); } catch (Exception Ex) { ShowErrorMessage(Ex); } lbliCount.Text = list.Count().ToString(); }
/// <summary> /// 獲取指定角色ID的功能權限列表 /// </summary> /// <param name="strRoleID">角色ID</param> /// <returns></returns> public List<Sys_FunctionMaster_fum_Info> GetFunctionListByRoleID(string strRoleID) { List<Sys_FunctionMaster_fum_Info> listFunctions = new List<Sys_FunctionMaster_fum_Info>(); if (!string.IsNullOrEmpty(strRoleID)) { StringBuilder strSql = new StringBuilder(); strSql.AppendLine("select distinct fum_iRecordID,fum_cFunctionNumber,fum_cFunctionDesc,fum_cRemark"); strSql.AppendLine(",fum_cAdd,fum_dAddDate,fum_cLast,fum_dLastDate"); strSql.AppendLine("from Sys_FunctionMaster_fum with(nolock)"); strSql.AppendLine("join Sys_RolesFuctionSetting_rfs with(nolock) on rfs_cFunctionNumber=fum_cFunctionNumber"); strSql.AppendLine("join Sys_RoleMaster_rlm with(nolock) on rlm_cRoleID=rfs_cRoleID"); strSql.AppendLine("where rfs_cRoleID='" + strRoleID.Trim() + "'"); try { using (SqlDataReader reader = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (reader.Read()) { Sys_FunctionMaster_fum_Info funcInfo = new Sys_FunctionMaster_fum_Info(); if (reader["fum_iRecordID"] != null && reader["fum_iRecordID"].ToString() != string.Empty) { funcInfo.fum_iRecordID = int.Parse(reader["fum_iRecordID"].ToString()); } if (reader["fum_cFunctionNumber"] != null && reader["fum_cFunctionNumber"].ToString() != string.Empty) { funcInfo.fum_cFunctionNumber = reader["fum_cFunctionNumber"].ToString().Trim(); } if (reader["fum_cFunctionDesc"] != null && reader["fum_cFunctionDesc"].ToString() != string.Empty) { funcInfo.fum_cFunctionDesc = reader["fum_cFunctionDesc"].ToString().Trim(); } if (reader["fum_cRemark"] != null && reader["fum_cRemark"].ToString() != string.Empty) { funcInfo.fum_cRemark = reader["fum_cRemark"].ToString().Trim(); } if (reader["fum_cAdd"] != null && reader["fum_cAdd"].ToString() != string.Empty) { funcInfo.fum_cAdd = reader["fum_cAdd"].ToString().Trim(); } if (reader["fum_dAddDate"] != null && reader["fum_dAddDate"].ToString() != string.Empty) { funcInfo.fum_dAddDate = DateTime.Parse(reader["fum_dAddDate"].ToString().Trim()); } if (reader["fum_cLast"] != null && reader["fum_cLast"].ToString() != string.Empty) { funcInfo.fum_cLast = reader["fum_cLast"].ToString().Trim(); } if (reader["fum_dLastDate"] != null && reader["fum_dLastDate"].ToString() != string.Empty) { funcInfo.fum_dLastDate = DateTime.Parse(reader["fum_dLastDate"].ToString().Trim()); } listFunctions.Add(funcInfo); } } } catch (Exception ex) { throw ex; } } return listFunctions; }