private void AddData() { if (this.gv_SalesOrder.RowCount > 0) return; //显示客户查询 ZX.Win.FunctionParameter Qry = new ZX.Win.FunctionParameter(); Qry.SqlQrystr = "select sCustID,sCustName,sSalesMan,sSOClass,sTaxCode from Bas_Customer"; Form f = SystemClass.ApplicationFormMain.LoadFunction("Form_Main_CommonQry", Qry, null); Dictionary<string, string> Dic = (Dictionary<string, string>)f.Tag; if (Dic.Count > 1) { DataRow dr = ((DataTable)gc_SalesOrder.DataSource).NewRow(); dr["sSOClass"] = Dic["sSOClass"]; dr["sSalesMan"] = Dic["sSalesMan"]; dr["sCustID"] = Dic["sCustID"]; dr["sTaxCode"] = Dic["sTaxCode"]; dr["sSO"] = ZX.ZXSystem.DBUtility.DbHelperSQL.GetBilNo("sSO"); //设置sSo FP.pub_Object = dr["sSO"]; dr["sBOM"] = ZX.ZXSystem.DBUtility.DbHelperSQL.GetBilNo("sBOM"); // dr["sBOM"] = ZX.ZXSystem.DBUtility.DbHelperSQL.GetBilNo("sBOM"); ((DataTable)gc_SalesOrder.DataSource).Rows.Add(dr); } //一定放在新增行之后 }
private void Form_Main_ChangePassword_Load(object sender, EventArgs e) { //this.PictureBox1.Image = System.Drawing.Image.FromFile(Application.StartupPath + @"\Images\Backgroup\Title.jpg"); FP = (ZX.Win.FunctionParameter)this.Tag; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); this.txtOldPassWord.Focus(); this.txtOldPassWord.Select(); }
private void dgv_Common_DefaultValuesNeeded(object sender, DataGridViewRowEventArgs e) { e.Row.Cells["CreateDate"].Value = System.DateTime.Now; e.Row.Cells["ModifyDate"].Value = System.DateTime.Now; ZX.Win.FunctionParameter fp = new ZX.Win.FunctionParameter(); fp = (ZX.Win.FunctionParameter)this.Tag; e.Row.Cells["ModifierName"].Value=fp.pub_sUserNameByChinese; if (e.Row.Cells["CreateName"].Value==null) { e.Row.Cells["CreateName"].Value = fp.pub_sUserNameByChinese; } }
private void ButtonOK_Click(object sender, EventArgs e) { //程序启动时,将数据联结串设置好 ZX.ZXSystem.DBUtility.DbHelperSQL.connectionString = SystemClass.ConnectString.GetConnectionString(); string strUserName = this.TxtUserName.Text; string strPassWord = this.TxtPassword.Text; ZX.Class.StringOption.Encrypt ET = new ZX.Class.StringOption.Encrypt(); strPassWord = ET.EncryptString(strPassWord); if (GenCode.CheckSN() == false) { return; } string strSql = "select sUSERID,sUserName,sUserNameByChinese,sLoginPassword,sRole,sDepartMent,sEMail,sMemo from SYS_USER_INFO where sUserName='******' and sLoginPassword='******'"; // MessageBox.Show(strSql); try { DataTable DT = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; if (DT.Rows.Count != 0 && DT.Rows[0]["sLoginPassword"].ToString() == strPassWord && DT.Rows[0]["sUserName"].ToString() == strUserName) { ZX.Class.Log.WriteLog.Write("ZXSystem.Form_Login", "ButtonOK_Click", "用户登录成功:" + strUserName, ZX.Class.Log.NormalLogType.InfoLog); FP = new ZX.Win.FunctionParameter(); FP.functionFormID = "-1"; FP.toolStripItemDisplayStyle = ToolStripItemDisplayStyle.ImageAndText; FP.pub_CnnDest = SystemClass.ConnectString.GetConnectionString(); FP.pub_ComputerName = SystemClass.ConnectString.GetComputerName(); FP.pub_DbPassWord = SystemClass.ConnectString.GetPassWord(); FP.pub_DBUsername = SystemClass.ConnectString.GetUserName(); FP.pub_DbName = SystemClass.ConnectString.GetDatabase(); FP.pub_sUserName = DT.Rows[0]["sUserName"].ToString(); //用户类型 FP.pub_YHLX = DT.Rows[0]["sDepartMent"].ToString(); FP.pub_sUserNameByChinese = DT.Rows[0]["sUserNameByChinese"].ToString(); FP.Pub_sRole = DT.Rows[0]["sRole"].ToString(); //FP.pub_SJDWBH = DT.Rows[0]["SJDWBH"].ToString(); this.Tag = FP; IsTrue = true; this.Close(); } else { SystemClass.MessageBoxShow.ShowMessage("输入的用户名与密码不正确,请确认后重试!"); ZX.Class.Log.WriteLog.Write("ZXSystem.Form_Login", "ButtonOK_Click", "输入的用户名与密码不正确,请确认后重试", ZX.Class.Log.NormalLogType.InfoLog); } } catch { FP = new ZX.Win.FunctionParameter(); FP.ToolStripitemDisplayStyle = ToolStripItemDisplayStyle.ImageAndText; FP.functionFormID = "-1"; ZX.Win.ReflectionFunction RF = new ZX.Win.ReflectionFunction(); RF.LoadMdiForm("ZXSystem.Function.SetServerComputer.dll", "ZXSystem.Function.SetServerComputer.Form_Main_SetServerComputer",null, FP); GC.Collect(); } }
private void Form_Main_UserManage_Load(object sender, EventArgs e) { FP = (ZX.Win.FunctionParameter)this.Tag; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); this.gc_UserManage.Tag = "SYS_USER_INFO"; LoadData(); ZX.Controls.DataGridViewEx.GridControlEx.GetDatagridviewFromDB("通用", gc_UserManage); }
private void ModifiData() { string so = this.gv_SalesOrder.GetFocusedRowCellValue(gv_SalesOrder.Columns.ColumnByFieldName("sSO")).ToString(); ZX.Win.FunctionParameter FP = new ZX.Win.FunctionParameter(); FP = (ZX.Win.FunctionParameter)this.Tag; FP.pub_Object = so; //MessageBox.Show(this.MdiParent.Name.ToString()); Form f = SystemClass.ApplicationFormMain.LoadFunction("Form_Main_WorkOrd", FP, this.MdiParent); System.Windows.Forms.TabPage TP = new System.Windows.Forms.TabPage(f.Text); TP.Tag = f; TP.ToolTipText = f.Text; foreach (Control item in this.ParentForm.Controls) { if ((item is System.Windows.Forms.TabControl) && (item.Name == "TabControFormList")) { TabControl c = (TabControl)item; c.TabPages.Add(TP); c.SelectedTab = TP; } } TP.Select(); this.Close(); }
private void gc_Routing_DoubleClick(object sender, EventArgs e) { //string Machine = this.gv_Routing.GetFocusedRowCellValue(gv_Routing.Columns.ColumnByFieldName("sMachine")).ToString(); //MessageBox.Show(Machine); if (gv_WorkOrder.RowCount > 0) { ZX.Win.FunctionParameter Qry = new ZX.Win.FunctionParameter(); Qry = (ZX.Win.FunctionParameter)this.Tag; Qry.pub_Object = this.gv_WorkOrder.GetFocusedRowCellValue(gv_WorkOrder.Columns.ColumnByFieldName("sWO")).ToString(); //Qry.pub_Object = this.gv_Routing.GetFocusedRowCellValue(gv_Routing.Columns.ColumnByFieldName("sWO")).ToString(); Form f = SystemClass.ApplicationFormMain.LoadFunction("Form_Main_ProductProcess", Qry, null); } }
private void FrxReport() { ZX.Win.FunctionParameter param = new ZX.Win.FunctionParameter(); param.Pub_ReportName = "FrxWO"; param.Pub_StoredProcName = "sp_FrxWO"; SqlParameter[] parameters = { new SqlParameter("@sWO", SqlDbType.VarChar,20) }; parameters[0].Value = gv_WorkOrder.GetFocusedRowCellValue(gv_WorkOrder.Columns.ColumnByFieldName("sWO")); param.Pub_Sqlparam = parameters; Form f = SystemClass.ApplicationFormMain.LoadFunction("Form_Main_FrxReport", param, null); }
private void Form_Main_Load(object sender, EventArgs e) { FP = (ZX.Win.FunctionParameter)this.Tag; //DataGridView HRDG = FP.MyGridView; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); gc_SalesOrder.Tag = "Sal_SalesOrder"; gv_SalesOrder.OptionsView.ColumnAutoWidth = false; //初始化工单信息 this.gc_WorkOrder.Tag = "PP_WorkOrder"; gv_WorkOrder.OptionsView.ColumnAutoWidth = false; //初始化工序信息 this.gc_Routing.Tag = "PP_Routing"; gv_Routing.OptionsView.ColumnAutoWidth = false; //单选行 //gv_Routing.OptionsSelection.MultiSelectMode = GridMultiSelectMode.RowSelect; //gv_Routing.OptionsSelection.MultiSelect = false; //初始化机床信息 this.gc_Machine.Tag = "Bas_Machines"; gv_Machine.OptionsView.ColumnAutoWidth = false; //设置不可编辑 gv_Machine.OptionsBehavior.Editable = false; string strSql2 = "select * from Bas_Machines order by ssortby"; DTBas_Machines = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql2).Tables[0]; gc_Machine.DataSource = DTBas_Machines; if (FP.pub_Object.ToString() == "") { LoadDataNull(); } else { LoadData(FP.pub_Object.ToString()); } ZX.Controls.DataGridViewEx.GridControlEx.GetDatagridviewFromDB("通用", gc_Machine); }
//#region "隐藏性的添加功能(当系统第一次运行时)" //private void treeViewLeftFun_KeyUp(object sender, KeyEventArgs e) //{ // if (e.KeyCode == Keys.F11 && e.Control == true && e.Alt == true) // { // ZX.Win.FunctionParameter FP = new ZX.Win.FunctionParameter(); // FP.ToolStripitemDisplayStyle = ToolStripItemDisplayStyle.ImageAndText; // FP.functionFormID = "-1"; // ZX.Win.ReflectionFunction RF = new ZX.Win.ReflectionFunction(); // Form frm = RF.LoadMdiForm("ZXSystem.Function.FunManage.dll", "ZXSystem.Function.FunManage.Form_Main_FunManage", this, FP); // System.Windows.Forms.TabPage TP = new System.Windows.Forms.TabPage(frm.Text); // TP.Tag = frm; // this.TabControFormList.TabPages.Add(TP); // this.TabControFormList.SelectedTab = TP; // TP.Select(); // } //} //#endregion private void Form_Main_Load(object sender, EventArgs e) { zxPanel1.ShowGrid = false; //没有搞明白为什么删除控件主界面会无法显示窗体内容 slidingTitleBarLeft.Visible = false; //没有搞明白为什么删除控件主界面会无法显示窗体内容 this.slidingTitleBarRight.Visible = false; this.slidingTitleBarRight.SendToBack(); FormMainFP = (ZX.Win.FunctionParameter)this.Tag; if (FormMainFP == null) { return; } this.TabControFormList.SelectedTab = null; //菜单 AddMenu(); //toolstripMain AddToolStripMain(); //去掉超级用户特权 if (FormMainFP.Pub_sUserNameByChinese != "admin") { SystemClass.ApplicationFormMain.CheckFunctionAssign(this.menuStrip1, FormMainFP.Pub_sUserName); } AddTreeViewFunctionNodes(); AddTreeViewHelpNodes(); LoadWorkFile(); SystemClass.ApplicationFormMain.SetFunctionEnabled(true, this); SetControl(); SetStatus(); LoadZXPanel(); }
private void Form_Main_KeyUp(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F11) { ZX.Win.FunctionParameter FP = new ZX.Win.FunctionParameter(); FP.ToolStripitemDisplayStyle = ToolStripItemDisplayStyle.ImageAndText; FP.functionFormID = "-1"; ZX.Win.ReflectionFunction RF = new ZX.Win.ReflectionFunction(); Form frm = RF.LoadMdiForm("ZXSystem.Function.FunManage.dll", "ZXSystem.Function.FunManage.Form_Main_FunManage", this, FP); System.Windows.Forms.TabPage TP = new System.Windows.Forms.TabPage(frm.Text); TP.Tag = frm; this.TabControFormList.TabPages.Add(TP); this.TabControFormList.SelectedTab = TP; TP.Select(); this.zxPanel1.Visible = false; } ///F12重新加载菜单 if (e.KeyCode == Keys.F12) { AddMenu(); AddToolStripMain(); ZX.Win.SetToolBarIcon SBI1 = new ZX.Win.SetToolBarIcon(); SBI1.SetImage(Application.StartupPath + @"\Images\TooBarIco\", this.ToolStripMain, ToolStripItemDisplayStyle.ImageAndText); } }