public Result Login(int userno, string pwd, string pcname, string ip, string mac, bool relogin) { try { Result res = new Result(); moConnection.CheckInterval = Static.ToInt(Static.RegisterGet(mstrRegPath, "Login", "CheckInterval", "10")); moConnection.WaitTimeout = Static.ToInt(Static.RegisterGet(mstrRegPath, "Login", "WaitTimeout", "60")); moConnection.Disconnect(); moConnection.Connect(mstrServerIP, mintServerPort); if (relogin == false) { ip = moConnection.IpLocal; mac = moConnection.NetworkAddress; } if (moConnection.Connected) { object[] param = new object[] { userno, pwd, pcname, ip, mac, relogin }; res = moConnection.Call(userno, 101, 110000, 110000, param); if (res.ResultNo == 0) { moUser.UserNo = userno; moUser.BranchCode = Static.ToStr(res.Param[0]); moUser.UserFName = Static.ToStr(res.Param[1]); moUser.UserFName2 = Static.ToStr(res.Param[2]); moUser.UserLevel = Static.ToInt(res.Param[3]); moUser.UserLName = Static.ToStr(res.Param[4]); moUser.UserLName2 = Static.ToStr(res.Param[5]); moUser.Level1 = Static.ToInt(res.Param[6]); moUser.Level2 = Static.ToInt(res.Param[7]); moUser.Level3 = Static.ToInt(res.Param[8]); moUser.Level4 = Static.ToInt(res.Param[9]); moUser.TxnGroupLevel = Static.ToInt(res.Param[10]); mstrDS = res.Data; } return(res); } else { // Серверт холбогдож чадсангүй return(new Result(7, "Серверт холбогдож чадсангүй!")); } } catch (Exception ex) { return(new Result(7, ex.Message)); } }
private void btnSave_Click(object sender, EventArgs e) { if (ValidateFields() == true) { #region [ Нууц үг солих] string OldPass; string NewPass; object[] M = new object[5]; Result res = new Result(); OldPass = Static.Encrypt(txtOldPass.Text); NewPass = Static.Encrypt(txtNewPass.Text); M[0] = moUser.UserNo; M[1] = OldPass; M[2] = NewPass; M[3] = txtNewPass.Text.Length; M[4] = Count; try { res = moConnection.Call(moUser.UserNo, 101, 110002, 110002, M); if (res.ResultNo == 0) { moUser.UserPassword = NewPass; MessageBox.Show("Нууц үгийг амжилттай солилоо", "", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show(res.ResultDesc, "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); this.DialogResult = DialogResult.Cancel; } #endregion } }
internal int LoadTableData(int reportpriv, ref DataSet ds, ref string error) { int success = 0; if (client != null) { if (ds == null) { ds = new DataSet(); } for (int i = 0; i < tables.Count; i++) { string tablename = string.Format("Table{0}", i + 1); string sql = (string)tables[tablename]; if (!string.IsNullOrEmpty(sql)) { #region Collect parameters List <string> paramnames = new List <string>(); ArrayList paramvalues = new ArrayList(); foreach (ParameterItem p in parameters) { if (p == null || p.TableNumbers == null || p.TableNumbers.Length <= 0 || Array.IndexOf <int>(p.TableNumbers, 0) >= 0 || Array.IndexOf <int>(p.TableNumbers, i) >= 0) { // string regexPattern = @"(?<=TO_CHAR(BRANCHNO) =)[^;\n]*"; string regexPattern = @":ppBranchCode"; string regexUserno = @":ppUserNo"; string regexLevel1 = @":pLevelNo1"; string regexLevel2 = @":pLevelNo2"; string regexLevel3 = @":pLevelNo3"; string regexLevel4 = @":pLevelNo4"; string regexLevel5 = @":pTxnDate"; var pBranchCode = Regex.Match(sql, regexPattern); // var pUserNo = Regex.Match(sql, regexUserno); // var LevelNo1 = Regex.Match(sql, regexLevel1); // var LevelNo2 = Regex.Match(sql, regexLevel2); // var LevelNo3 = Regex.Match(sql, regexLevel3); // var LevelNo4 = Regex.Match(sql, regexLevel4); // var Txndate = Regex.Match(sql, regexLevel5); // if (Static.ToStr(pBranchCode) != "") { paramnames.Add("ppBranchCode"); paramvalues.Add(_core.RemoteObject.User.BranchCode); } if (Static.ToStr(pUserNo) != "") { paramnames.Add("ppUserNo"); paramvalues.Add(_core.RemoteObject.User.UserNo); } if (Static.ToStr(LevelNo1) != "") { paramnames.Add("pLevelNo1"); paramvalues.Add(_core.RemoteObject.User.Level1); } if (Static.ToStr(LevelNo2) != "") { paramnames.Add("pLevelNo2"); paramvalues.Add(_core.RemoteObject.User.Level2); } if (Static.ToStr(LevelNo3) != "") { paramnames.Add("pLevelNo3"); paramvalues.Add(_core.RemoteObject.User.Level3); } if (Static.ToStr(LevelNo4) != "") { paramnames.Add("pLevelNo4"); paramvalues.Add(_core.RemoteObject.User.Level4); } if (Static.ToStr(Txndate) != "") { paramnames.Add("pTxnDate"); paramvalues.Add(_core.TxnDate); } paramvalues.Add(p.Value); paramnames.Add(p.Id); } } #endregion #region Calling server function object[] param = new object[] { sql, paramnames.ToArray(), paramvalues.ToArray() }; Result r = client.Call(userno, 107, 107001, reportpriv, param); // Result rr = client.Call(userno, 107, 107001, reportpriv, param); if (r.ResultNo != 0) { success = r.ResultNo; error = r.ResultDesc; break; } r.Data.Tables[0].TableName = tablename; ds.Tables.Add(r.Data.Tables[0].Copy()); r.Data = ds; // string tablename = string.Format("Table{0}", i + 1); // string sql = (string)tables[tablename]; // ds.Tables.Add(r.Data.Tables[1].Copy()); #endregion } } } if (success != 0) { ds.Dispose(); } return(success); }