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);
}
}
