private void GetPrivForThisForm() { //if(this.PriviFile== glb_function.ProgramType.none ) // return; if (glb_function.glb_strUserName == "") { return; } ConnectionToDB cnn = new ConnectionToDB(); DataTable dtTemplete = cnn.GetDataTable("select u.templet_id,h.form_name from templet_header h,user_templet u " + " where h.swid = u.templet_id " + " and h.form_eng_name = '" + this.Name + "' and u.user_id=" + glb_function.glb_strUserId); if (dtTemplete == null || dtTemplete.Rows.Count <= 0) { return; } lstTemplet.DataSource = dtTemplete; lstTemplet.ValueMember = "templet_id"; lstTemplet.DisplayMember = "form_name"; lstTemplet.SelectedIndex = -1; lstTemplet.SelectedIndex = 0; }
public static string GetSelectHash(string strStat) { strStat = strStat.Replace("'", "''"); ConnectionToDB cnnHash = new ConnectionToDB(); DataTable dtHash = cnnHash.GetDataTable("select dbms_sqlhash.getHash('" + strStat + "', 1) from dual"); string strHash = BitConverter.ToString((byte[])dtHash.Rows[0][0]).Replace("-", string.Empty); return(strHash); }
private void btnJournal_Click(object sender, EventArgs e) { ConnectionToDB cnn = new ConnectionToDB(); DataTable dtDifFir = cnn.GetDataTable("select swid,acc_no,acc_name from accounts where system_acc_type='فرق كسر'"); if (dtDifFir == null || dtDifFir.Rows.Count <= 0) { glb_function.MsgBox("لايوجد حساب لفرق الكسر"); } else { Accounts.frmJournal frm = new Accounts.frmJournal(); glb_function.OpenForm(this, frm, false); // new Account.frmJournal().Show(this); } }
public static void FillListWithId(ref myList lstBranch, string strTable, string strCol) { ConnectionToDB conn = new ConnectionToDB(); DataTable MyDataTable; //myList lstBranch = new myList(); MyDataTable = conn.GetDataTable("Select SWID," + strCol + " From " + strTable + " order by " + strCol + ""); if (MyDataTable != null) { lstBranch.DataSource = MyDataTable; lstBranch.ValueMember = "SWID"; lstBranch.DisplayMember = strCol; lstBranch.SelectedIndex = -1; } }
public static void FillList(ref myList lstRequired, string strTable, string strCol) { ConnectionToDB conn = new ConnectionToDB(); DataTable MyDataTable; //myList lstBranch = new myList(); MyDataTable = conn.GetDataTable("Select distinct " + strCol + " From " + strTable + " order by 1"); if (MyDataTable != null) { lstRequired.DataSource = MyDataTable; lstRequired.DisplayMember = strCol; lstRequired.SelectedIndex = -1; } }
public static decimal GetAccBalance(string Currid, string accId) { //تستخدم لمعرفة رصيد حساب معين ConnectionToDB cnn = new ConnectionToDB(); DataTable dtGetAcc = cnn.GetDataTable("select nvl( sum(jd.jour_value),0) from journal_header jh join journal_details jd on(jh.swid=jd.jour_id) " + " where jd.curr_id =" + Currid + " and jd.acc_id = " + accId + " and jd.stat <> 'ملغي' and jh.stat <> 'ملغي'"); decimal balance = 0; if (dtGetAcc == null || dtGetAcc.Rows.Count <= 0) { balance = 0; } else { balance = Convert.ToDecimal(dtGetAcc.Rows[0][0].ToString()); } return(balance); }
private void myBottun1_Click(object sender, EventArgs e) { ConnectionToDB cnn = new ConnectionToDB(); if (txtItemSwid.Text == "") { if (txtItemNo.Text == "") { glb_function.MsgBox("الرجاء ادخال رقم القطعة"); return; } DataTable dt = cnn.GetDataTable("select swid from items where item_no='" + txtItemNo.Text + "'"); if (dt == null || dt.Rows.Count <= 0) { glb_function.MsgBox("No data"); return; } else if (dt.Rows.Count > 1) { glb_function.MsgBox("more than One Item"); txtItemSwid.Text = dt.Rows[0][0].ToString(); // return; } else { return; } } int icheck = cnn.TranDataToDB("delete from ITEM_UNITS where item_id=" + txtItemSwid.Text); if (icheck < 0) { glb_function.MsgBox("Error in item units"); return; } // icheck = cnn.TranDataToDB("delete from PROPERTY_ITEM where item_id=" + txtItemSwid.Text); //if (icheck < 0) //{ // glb_function.MsgBox("Error in item PROPERTY"); // cnn.glb_RollbackTransaction(); // return; //} icheck = cnn.TranDataToDB("delete from PROPERTY_ITEM where item_id=" + txtItemSwid.Text); if (icheck < 0) { glb_function.MsgBox("Error in item PROPERTY"); cnn.glb_RollbackTransaction(); return; } icheck = cnn.TranDataToDB("delete from PACK_ITEM where itemid=" + txtItemSwid.Text); if (icheck < 0) { glb_function.MsgBox("Error in item Package"); cnn.glb_RollbackTransaction(); return; } icheck = cnn.TranDataToDB("delete from items where swid=" + txtItemSwid.Text); if (icheck <= 0) { glb_function.MsgBox("Error in items"); cnn.glb_RollbackTransaction(); return; } cnn.glb_commitTransaction(); glb_function.MsgBox("Deleted"); }
private void btnLogin_Click(object sender, EventArgs e) { // CnnDB cnn = new CnnDB(); ConnectionToDB cnn = new ConnectionToDB(); DataTable dtLogin = cnn.GetDataTable("select swid,STAT,USER_LOGIN,USER_NAME,USER_BRANCH,(select branch_aname from branches where swid=nvl(USER_BRANCH,0)) BranchName,access_type,dept_id,(select d.dept_aname from departements d where d.swid=dept_id) dept_name,to_char(sysdate,'dd/mm/yyyy') TodayDate from USERINFO " + " where USER_LOGIN=N'" + txtUserid.Text.Trim().Replace("'", "").Trim() + "' and USER_PASSWORD='******'"); if (dtLogin != null && dtLogin.Rows.Count != 0) { #region test // frmMain f = (frmMain)Application.OpenForms["frmMain"]; //new glb_function(). LoginMethod(txtUserid.Text); #endregion if (dtLogin.Rows[0]["stat"].ToString() == "غير فعال") { glb_function.MsgBox("المستخدم غير فعال", "رسالة نظام"); return; } string userip = glb_function.GetLocalIPAddress(); DataTable dtUserAcc = new DataTable(); // 1التاكد من ان المستخدم لديه الحق في الدخول من هذا الجهاز string str = dtLogin.Rows[0]["access_type"].ToString(); if (dtLogin.Rows[0]["access_type"].ToString() != "كل") { dtUserAcc = cnn.GetDataTable("select swid from USER_COMPUTERS t " + " where t.userid =" + dtLogin.Rows[0]["swid"].ToString() + " and (device_code = '" + glb_function.GetProcessorId() + "' or '" + userip + "' like t.device_code || '%' ) "); if (dtUserAcc == null || dtUserAcc.Rows.Count <= 0) { glb_function.MsgBox("ليس لديك صلاحية للدخول من هذا الجهاز"); return; } } //1******************************************************* //2التاكد ان المستخدم داخل من جهاز ثاني dtUserAcc.Rows.Clear(); dtUserAcc = cnn.GetDataTable("select swid,ip from USER_LOGS where user_id=" + dtLogin.Rows[0]["swid"].ToString() + " and (logoff_date ='' or logoff_date is null)"); if (dtUserAcc.Rows.Count >= 1) { IPAddress ip = IPAddress.Parse(dtUserAcc.Rows[0]["ip"].ToString()); if (dtUserAcc.Rows[0]["ip"].ToString() != glb_function.GetLocalIPAddress()) { if (glb_function.MsgBox("هذا المستخدم مسجل بجهاز اخر هل تريد الخروج منه والتسجيل من هذا الجهاز", "", true)) { // glb_function. SendMessage("<log off user >" +txtUserid.Text.Trim(), ip); } else { return; } } int icheck1 = cnn.TranDataToDB("update USER_LOGS set logoff_date= sysdate where user_id=" + dtLogin.Rows[0]["swid"].ToString() + " and (logoff_date ='' or logoff_date is null)"); if (icheck1 <= 0) { glb_function.MsgBox("حدث خطأ "); return; } cnn.glb_commitTransaction(); } //2******************************** //3 فحص هل المستخدم تغير ام لا if (glb_function.glb_strUserLogin != txtUserid.Text) { //OpenForms f = new Application.OpenForms(); for (int i = Application.OpenForms.Count - 1; i >= 0; i--) { if (((Form)(Application.OpenForms[i])).Name != "frmMain" && Application.OpenForms[i].Name != "frmLogin") { Application.OpenForms[i].Close(); } } } //3*************************** //4 إنشاء بيانات الدخول وفتح جلسة للمستخدم int icheck = cnn.TranDataToDB("insert into USER_LOGS values((select nvl(max(swid),0)+1 from USER_LOGS)," + dtLogin.Rows[0]["swid"].ToString() + ",sys_context('USERENV','SID'),sys_context('USERENV','HOST'),sysdate,null,'" + userip + "')"); if (icheck <= 0) { glb_function.MsgBox("حدث خطأ اثناء تسجيل بيانات الدخول"); return; } cnn.glb_commitTransaction(); //4*************************************** glb_function.glb_strUserId = dtLogin.Rows[0]["swid"].ToString(); glb_function.glb_strUserLogin = dtLogin.Rows[0]["USER_LOGIN"].ToString(); glb_function.glb_strUserName = dtLogin.Rows[0]["USER_NAME"].ToString(); glb_function.glb_BranchNo = Convert.ToInt16(dtLogin.Rows[0]["USER_BRANCH"].ToString()); glb_function.glb_BranchName = dtLogin.Rows[0]["BranchName"].ToString(); glb_function.glb_deptId = Convert.ToInt16(dtLogin.Rows[0]["dept_id"].ToString()); glb_function.glb_DeptName = dtLogin.Rows[0]["dept_name"].ToString(); glb_function.dtSysdate = DateTime.ParseExact(dtLogin.Rows[0]["TodayDate"].ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); //*************** DataTable dtMainCurr = cnn.GetDataTable("select swid,curr_name,curr_decimal from currency c where c.is_main_curr = '1'"); if (dtMainCurr == null || dtMainCurr.Rows.Count <= 0) { glb_function.MsgBox("لايوجد عملة رئيسية للنظام"); // SOWAID.frmCurrency frm = new frmCurrency(); //frm.FormClosed += Frm_FormClosed; //frm.ShowDialog(); } else { glb_function.glb_MainCurrencyId = Convert.ToInt16(dtMainCurr.Rows[0]["swid"].ToString()); glb_function.glbMainCurrencyName = dtMainCurr.Rows[0]["curr_name"].ToString(); glb_function.glbMainDecimalPoint = Convert.ToInt16(dtMainCurr.Rows[0]["curr_decimal"].ToString()); } //***************** } else { glb_function.MsgBox("كلمة السر او اسم المستخدم غير صحيحة", "تنبية"); return; } //DataTable dtSession = cnn.GetDataTable("select sys_context('USERENV', 'SID') from dual "); //MessageBox.Show(dtSession.Rows[0][0].ToString()); this.Close(); }
private void lstTemplet_SelectedIndexChanged(object sender, EventArgs e) { new glb_function().clearItems(this); if (lstTemplet.SelectedValue == null) { return; } if (lstTemplet.SelectedValue.ToString() != "System.Data.DataRowView" && lstTemplet.SelectedValue.ToString() != "") { string strStat = "select h.swid,h.form_eng_name,h.form_type ,d.control_type,d.en_name,d.real_value,d.ar_name,multi_form_for_user " + " from templet_header h,templet_details d" + " where h.swid = d.temp_header_id" + " and h.swid = " + lstTemplet.SelectedValue.ToString(); ConnectionToDB cnn = new ConnectionToDB(); dtPri = cnn.GetDataTable(strStat); if (dtPri.Rows[0]["multi_form_for_user"].ToString() == "1") { lstTemplet.Visible = true; lblTemplet.Visible = true; } for (int i = 0; i < dtPri.Rows.Count; i++) { if (dtPri.Rows[i]["control_type"].ToString() == "Visability") { if (dtPri.Rows[i]["real_value"].ToString() == "1") { Control ctr = GetControlByName(this, dtPri.Rows[i]["en_name"].ToString()); if (ctr != null) { ctr.Visible = true; } } else { Control ctr = GetControlByName(this, dtPri.Rows[i]["en_name"].ToString()); if (ctr != null) { ctr.Visible = false; } } } else if (dtPri.Rows[i]["control_type"].ToString() == "Enability") { if (dtPri.Rows[i]["real_value"].ToString() == "1") { Control ctr = GetControlByName(this, dtPri.Rows[i]["en_name"].ToString()); if (ctr != null) { ctr.Enabled = true; } //string strss = dtPri.Rows[i]["en_name"].ToString(); //this.Controls[dtPri.Rows[i]["en_name"].ToString()].Enabled = true; } else { Control ctr = GetControlByName(this, dtPri.Rows[i]["en_name"].ToString()); if (ctr != null) { ctr.Enabled = false; } } } else if (dtPri.Rows[i]["control_type"].ToString() == "List" || dtPri.Rows[i]["control_type"].ToString() == "Text" || dtPri.Rows[i]["control_type"].ToString() == "MultiChoices" || dtPri.Rows[i]["control_type"].ToString() == "Free MultiChoices" || dtPri.Rows[i]["control_type"].ToString() == "Free List") { //if (dtPri.Rows[i]["ar_name"].ToString() == "الفروع" || dtPri.Rows[i]["ar_name"].ToString() == "الفرع") //{ // // (GetControlByName(this, dtPri.Rows[i]["en_name"].ToString())).Text = dtPri.Rows[i]["real_value"].ToString(); // Control ctr = GetControlByName(this, dtPri.Rows[i]["en_name"].ToString()); // if (ctr != null) // ctr.Text = dtPri.Rows[i]["real_value"].ToString(); //} //else if (dtPri.Rows[i]["ar_name"].ToString() == "الاقسام" || dtPri.Rows[i]["ar_name"].ToString() == "القسم") //{ // // (GetControlByName(this, dtPri.Rows[i]["en_name"].ToString())).Text = dtPri.Rows[i]["real_value"].ToString(); Control ctr = GetControlByName(this, dtPri.Rows[i]["en_name"].ToString()); if (ctr != null) { ctr.Text = dtPri.Rows[i]["real_value"].ToString(); } //} } } lstTemplet_MorePrivilleges(sender, e); } }
private void InitialLogin() { ConnectionToDB myconn = new ConnectionToDB(); DataTable MyDataTable; MyDataTable = myconn.GetDataTable("select Instance_name From sys.V_$INSTANCE"); this.Text = this.Text + " @ " + MyDataTable.Rows[0][0].ToString(); foreach (RibbonTab ribonTab in sowaidribbon.Tabs) { ribonTab.Visible = false; } //***************888 Rectangle rect = Screen.FromHandle(this.Handle).WorkingArea; rect.Location = new Point(0, 0); this.MaximizedBounds = rect; this.WindowState = FormWindowState.Maximized; Theme.ColorTable = new sowaidRibbonRendererColorTableBlack(); //*********** //pnlToolBar.Width = splitContainer2.Width / 3 * 2; //pnlToolBar.Left = splitContainer2.Width - pnlToolBar.Width; //pnlToolBar.Height = splitContainer2.Panel1.Height; //pnlToolBar.Top = 0; splitContainer2.SplitterWidth = 1; splitContainer2.SplitterDistance = sowaidribbon.Height; // pbxSowaidLogo.Height = splitContainer2.Panel1.Height + 10; pbxLogo.Left = 0; pbxLogo.Top = 27; //tmrCurrentTime.Start(); // lblUserLable.Text = "اسم المستخدم : ....."; //glb_function.glb_strUserName = ""; // lblUserLable.Left = pnlRight.Width / 2 - lblUserLable.Width / 2; RemoveUserToolIcons(); frmLogin myform = new frmLogin(); myform.ShowDialog(this); //if (glb_function.glb_strUserName == "") //{ // this.Close(); // return; //} lblUserLable.Text = " " + glb_function.glb_strUserName; // lblUserLable.Left = pbxLogout.Left + lblUserLable.Width -50; //lblUserLable.Top = pbxLogout.Top; ConnectionToDB cnn = new ConnectionToDB(); //dtUserForm = cnn.GetDataTable("select p.swid,m.form_name,m.form_type from models_file m " + // " join privilege_file p on(m.swid = p.model_no and user_no = " + glb_function.glb_strUserId + ")" + // " union all" + // " select p.swid, m.form_name, m.form_type from models_account m" + // " join privilege_account p on (m.swid = p.model_no and user_no = " + glb_function.glb_strUserId + ")" + // " union all" + // " select p.swid,m.form_name,m.form_type from MODELS_CHARITIES m " + // " join PRIVILEGE_CHARITIES p on(m.swid = p.model_no and user_no = " + glb_function.glb_strUserId + ")" + // ""); dtUserForm = cnn.GetDataTable("select u.swid,m.form_name,m.form_eng_name,m.form_type from templet_header m,user_templet u " + " where m.swid = u.templet_id and u.user_id= " + glb_function.glb_strUserId); CreateToolIcons(this); }