using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using DBUtility; namespace SCM { public partial class Xt_UserNew : Form { public Xt_UserNew() { InitializeComponent(); } public SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1(); public Pub_Class.ClsPub.Enum_InputMode InputMode; //¼Èë״̬±êÖ¾(0-·Ç¼Èë״̬ 1-Ôö¼Ó 2-ÐÞ¸Ä) public string Czybm; public Int64 HOrgID = -1; public string HProcNo = ""; //´°Ìå¼ÓÔØ private void Xt_UserNew_Load(object sender, EventArgs e) { oWeb.Url = ClsPub1.WEBSURL; lblError.Text = ""; LbYes.Items.Clear(); LbNo.Items.Clear(); //¼ÓÔØ×éÖ¯ÐÅÏ¢ Sub_AddOrdList(); Init(); Display(); } //¼ÓÔØ×éÖ¯ÐÅÏ¢ private void Sub_AddOrdList() { DataSet ds; ds = oWeb.get_ORGANIZATIONSList(); if (ds == null || ds.Tables[0].Rows.Count == 0) { MessageBox.Show("»ñÈ¡×é֯ʧ°Ü"); return; } cmbHOrgID.Items.Clear(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { cmbHOrgID.Items.Add(DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HName"])); } } //²éÕÒÊý¾Ý----Óû§×é private void Display() { if (InputMode == Pub_Class.ClsPub.Enum_InputMode.InputMode_AddNew) { try { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet oDs = new DataSet(); oDs = oWeb.getDataSetBySQL("select GroupID,GroupName from System_UserGroup order by GroupName", "System_UserGroup", ref ClsPub.sExeReturnInfo); if (oDs == null) { MessageBox.Show("ÏÔʾʧ°Ü£¡Ô­Òò£º" + ClsPub.sExeReturnInfo); return; } // for (int i = 0; i <= oDs.Tables[0].Rows.Count - 1; i++) { LbNo.Items.Add(oDs.Tables[0].Rows[i][0].ToString().Trim() + "-" + oDs.Tables[0].Rows[i][1].ToString().Trim()); } } catch (Exception e) { MessageBox.Show(e.Message, "Ìáʾ"); return; } } else { try { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet oDs = new DataSet(); DataSet oDS = new DataSet(); //¼ÓÔز»Êô×é oDs = oWeb.getDataSetBySQL("select GroupID,GroupName from System_UserGroup" +" where Groupid not IN (select Groupid from system_UserGroupInfo where userid='"+Czybm+"')", "System_UserGroup", ref ClsPub.sExeReturnInfo); if (oDs == null) { MessageBox.Show("ÏÔʾʧ°Ü£¡Ô­Òò£º" + ClsPub.sExeReturnInfo); return; } // if (oDs.Tables[0].Rows.Count != 0) { for (int i = 0; i <= oDs.Tables[0].Rows.Count - 1; i++) { LbNo.Items.Add(oDs.Tables[0].Rows[i][0].ToString().Trim() + "-" + oDs.Tables[0].Rows[i][1].ToString().Trim()); } } //¼ÓÔØÊôÓÚ×é oDS = oWeb.getDataSetBySQL("select GroupID,GroupName from System_UserGroup" + " where Groupid IN (select Groupid from system_UserGroupInfo where userid='" + Czybm + "')", "System_UserGroup", ref ClsPub.sExeReturnInfo); if (oDS == null) { MessageBox.Show("ÏÔʾʧ°Ü£¡Ô­Òò£º" + ClsPub.sExeReturnInfo); return; } // if (oDS.Tables[0].Rows.Count != 0) { for (int i = 0; i <= oDS.Tables[0].Rows.Count - 1; i++) { LbYes.Items.Add(oDS.Tables[0].Rows[i][0].ToString().Trim() + "-" + oDS.Tables[0].Rows[i][1].ToString().Trim()); } } } catch (Exception e) { MessageBox.Show(e.Message, "Ìáʾ"); return; } } } //³õʼ»¯½çÃæ private void Init() { txtHK3UserID.ReadOnly = true; txtHKeeperID.ReadOnly = true; txtHSecManagerID.ReadOnly = true; txtHSellManID.ReadOnly = true; txtHDeptID.ReadOnly = true; txtHWhID.ReadOnly = true; txtHSupID.ReadOnly = true; if (InputMode == Pub_Class.ClsPub.Enum_InputMode.InputMode_AddNew) { txtCzybm.Text = ""; txtCzymc.Text = ""; txtCzymm.Text = ""; txtCzyyz.Text = ""; txtExplain.Text = ""; txtHEmpID.Text = ""; txtHK3UserID.Text = ""; txtHKeeperID.Text = ""; txtHSecManagerID.Text = ""; txtHSellManID.Text = ""; txtHDeptID.Text = ""; txtHWhID.Text = ""; txtHSupID.Text = ""; txtHCloudUserName.Text = ""; txtHCloudUserPsd.Text = ""; cmdAllRight.PerformClick(); //»ñÈ¡µ±Ç°×éÖ¯ÐÅÏ¢ DataSet Ds = oWeb.getDataSetBySQL("select * from Xt_ORGANIZATIONS where HItemID=" + ClsPub1.HOrgID, "Xt_ORGANIZATIONS", ref DBUtility.ClsPub.sExeReturnInfo); if (Ds.Tables[0].Rows.Count != 0) { cmbHOrgID.Text = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HName"]); } } else { txtCzybm.ReadOnly = true; txtCzymm.ReadOnly = true; txtCzyyz.ReadOnly = true; ShowData(Czybm); } } //¼ÓÔرíÍ· private void ShowData(string sCzybm) { DataSet oDs = new DataSet(); SCM.ClsIF_User_View oUser = new SCM.ClsIF_User_View(); SCM.ClsIF_Employee_View oEmp = new SCM.ClsIF_Employee_View(); SCM.ClsXt_ORGANIZATIONS_View oORG = new ClsXt_ORGANIZATIONS_View(); try { oDs = oWeb.getDataSetBySQL("select Czybm,Czymc,Explain,HEmpID,HK3UserID,HCloudUserName,HCloudUserPsd,HKeeperID,HKeeper,HSecManagerID,HSecManager,HSellManID,HSellMan,HDeptID,HDept,HWhID,HWHName,HSupID,HSupName,HUSEORGID,HGroup,HGroupID,HProc,HProcNo,HProcName,HSource,HSourceID,HWorkCenter,HWorkCenterID from Gy_Czygl where Czybm='" + sCzybm + "'", "Gy_Czygl", ref ClsPub.sExeReturnInfo); if (oDs == null) { MessageBox.Show("ÏÔʾʧ°Ü£¡Ô­Òò£º" + ClsPub.sExeReturnInfo); return; } else if (oDs.Tables[0].Rows.Count != 0) { txtCzybm.Text = oDs.Tables[0].Rows[0]["Czybm"].ToString().Trim(); txtCzymc.Text = oDs.Tables[0].Rows[0]["Czymc"].ToString().Trim(); txtCzymm.Text = "*****"; txtCzyyz.Text = "*****"; txtExplain.Text = oDs.Tables[0].Rows[0]["Explain"].ToString().Trim(); if (oORG.GetInfoByID(ClsPub.isLong(oDs.Tables[0].Rows[0]["HUSEORGID"]))) { cmbHOrgID.Text = ClsPub.isStrNull(oORG.omodel.HName); } else { cmbHOrgID.Text = ""; } if (oEmp.GetInfoByID(ClsPub.isLong(oDs.Tables[0].Rows[0]["HEmpID"]))) { txtHEmpID.Text = ClsPub.isStrNull(oEmp.omodel.HName); txtHEmpID.Tag = ClsPub.isLong(oEmp.omodel.HItemID); } else { txtHEmpID.Text = ""; txtHEmpID.Tag = 0; } if (oUser.GetInfoByID(ClsPub.isLong(oDs.Tables[0].Rows[0]["HK3UserID"]))) { txtHK3UserID.Text = ClsPub.isStrNull(oUser.omodel.HName); txtHK3UserID.Tag = ClsPub.isLong(oUser.omodel.HItemID); } else { txtHK3UserID.Text = ""; txtHK3UserID.Tag = 0; } txtHKeeperID.Text = oDs.Tables[0].Rows[0]["HKeeper"].ToString().Trim(); txtHKeeperID.Tag = oDs.Tables[0].Rows[0]["HKeeperID"].ToString().Trim(); txtHSecManagerID.Text = oDs.Tables[0].Rows[0]["HSecManager"].ToString().Trim(); txtHSecManagerID.Tag = oDs.Tables[0].Rows[0]["HSecManagerID"].ToString().Trim(); txtHSellManID.Text = oDs.Tables[0].Rows[0]["HSellMan"].ToString().Trim(); txtHSellManID.Tag = oDs.Tables[0].Rows[0]["HSellManID"].ToString().Trim(); txtHDeptID.Text = oDs.Tables[0].Rows[0]["HDept"].ToString().Trim(); txtHDeptID.Tag = oDs.Tables[0].Rows[0]["HDeptID"].ToString().Trim(); txtHWhID.Text = oDs.Tables[0].Rows[0]["HWHName"].ToString().Trim(); txtHWhID.Tag = oDs.Tables[0].Rows[0]["HWhID"].ToString().Trim(); txtHSupID.Text = oDs.Tables[0].Rows[0]["HSupName"].ToString().Trim(); txtHSupID.Tag = oDs.Tables[0].Rows[0]["HSupID"].ToString().Trim(); txtHCloudUserName.Text = oDs.Tables[0].Rows[0]["HCloudUserName"].ToString().Trim(); txtHCloudUserPsd.Text = oDs.Tables[0].Rows[0]["HCloudUserPsd"].ToString().Trim(); textHGroupID.Text = oDs.Tables[0].Rows[0]["HGroup"].ToString().Trim(); textHGroupID.Tag = oDs.Tables[0].Rows[0]["HGroupID"].ToString().Trim(); textHProcNo.Text = oDs.Tables[0].Rows[0]["HProc"].ToString().Trim(); textHProcNo.Tag = oDs.Tables[0].Rows[0]["HProcName"].ToString().Trim(); textHWorkCenterID.Text = oDs.Tables[0].Rows[0]["HWorkCenter"].ToString().Trim(); textHWorkCenterID.Tag = oDs.Tables[0].Rows[0]["HWorkCenterID"].ToString().Trim(); textHSourceID.Text = oDs.Tables[0].Rows[0]["HSource"].ToString().Trim(); textHSourceID.Tag = oDs.Tables[0].Rows[0]["HSourceID"].ToString().Trim(); HProcNo = oDs.Tables[0].Rows[0]["HProcNo"].ToString().Trim(); } } catch (Exception e) { MessageBox.Show(e.Message, "Ìáʾ"); return; } } //È¡Ïû private void cmdCancel_Click(object sender, EventArgs e) { this.Close(); } //×óÒÆ private void cmdLeft_Click(object sender, EventArgs e) { if (this.LbNo.SelectedItems.Count > 0) { int i = this.LbNo.SelectedIndex; this.LbYes.Items.Add(this.LbNo.SelectedItem.ToString()); this.LbNo.Items.RemoveAt(i); } } //È«²¿×óÒÆ private void cmdAllLeft_Click(object sender, EventArgs e) { if (this.LbNo.Items.Count > 0) { for (int i = 0; i <= this.LbNo.Items.Count - 1; i++) { this.LbYes.Items.Add(this.LbNo.Items[i].ToString()); this.LbNo.Items.RemoveAt(i); i--; } } } //ÓÒÒÆ private void cmdRight_Click(object sender, EventArgs e) { if (this.LbYes.SelectedItems.Count > 0) { int i = this.LbYes.SelectedIndex; this.LbNo.Items.Add(this.LbYes.SelectedItem.ToString()); this.LbYes.Items.RemoveAt(i); } } //È«²¿ÓÒÒÆ private void cmdAllRight_Click(object sender, EventArgs e) { if (this.LbYes.Items.Count > 0) { for (int i = 0; i <= this.LbYes.Items.Count - 1; i++) { this.LbNo.Items.Add(this.LbYes.Items[i].ToString()); this.LbYes.Items.RemoveAt(i); i--; } } } //È·¶¨ private void cmdOK_Click(object sender, EventArgs e) { lblError.Text = ""; DataSet oDs = new DataSet(); if (!Sub_AllowSave()) //µ¥¾ÝÍêÕûÐÔÅÐ¶Ï { tabControl1.SelectedIndex = 0; return; } HOrgID = oWeb.get_ORGANIZATIONSIDByName(cmbHOrgID.Text); if (HOrgID == -1) { MessageBox.Show("Ñ¡Ôñ×éÖ¯ÓдíÎó£¡"); return; } if (InputMode == Pub_Class.ClsPub.Enum_InputMode.InputMode_AddNew) { oWeb.getRunProc("insert into Gy_Czygl (Czybm,Czymc,Czmm,Explain,HempID,HK3UserID " + ",HKeeperID,HKeeper,HSecManagerID,HSecManager " + ",HSellManID,HSellMan,HDeptID,HDept " + ",HWhID,HWHName,HSupID,HSupName " + ",HCloudUserName,HCloudUserPsd,HUSEORGID)" + "values (" + "'" + txtCzybm.Text.ToString() + "','" + txtCzymc.Text.ToString() + "','" + ClsPub.StrToPsd(txtCzymm.Text.ToString()) + "','" + txtExplain.Text.ToString() + "'," + ClsPub.isLong(txtHEmpID.Tag).ToString() + "," + ClsPub.isLong(txtHK3UserID.Tag).ToString() + "," + ClsPub.isLong(txtHKeeperID.Tag).ToString() + ",'" + txtHKeeperID.Text.ToString() + "'," + ClsPub.isLong(txtHSecManagerID.Tag).ToString() + ",'" + txtHSecManagerID.Text.ToString() + "'" + "," + ClsPub.isLong(txtHSellManID.Tag).ToString() + ",'" + txtHSellManID.Text.ToString() + "'," + ClsPub.isLong(txtHDeptID.Tag).ToString() + ",'" + txtHDeptID.Text.ToString() + "'" + "," + ClsPub.isLong(txtHWhID.Tag).ToString() + ",'" + txtHWhID.Text.ToString() + "'," + ClsPub.isLong(txtHSupID.Tag).ToString() + ",'" + txtHSupID.Text.ToString() + "'" + ",'" + txtHCloudUserName.Text.ToString() + "','" + txtHCloudUserPsd.Text.ToString() + "'," + HOrgID + ")", ref DBUtility.ClsPub.sExeReturnInfo); oDs = oWeb.getDataSetBySQL("Select * from Gy_Czygl where Czybm='" + txtCzybm.Text.ToString() + "'", "Gy_Czygl", ref DBUtility.ClsPub.sExeReturnInfo); if (oDs == null || oDs.Tables[0].Rows.Count == 0) { MessageBox.Show("ÐÂÔöʧ°Ü£¡", "Ìáʾ"); } this.Czybm = oDs.Tables[0].Rows[0]["Czybm"].ToString(); oWeb.getRunProc("delete from System_UserGroupInfo where UserId='" + Czybm.ToString() + "'", ref DBUtility.ClsPub.sExeReturnInfo); for (int i = 0; i <= LbYes.Items.Count - 1; i++) { oWeb.getRunProc("insert into System_UserGroupInfo (GroupId,UserId) values (" + ClsPub.isLong(Get_Code(this.LbYes.Items[i].ToString())) + ",'" + Czybm.ToString() + "')", ref DBUtility.ClsPub.sExeReturnInfo); } lblError.Text = "* ÐÂÔö³É¹¦£¡"; Init(); tabControl1.SelectedIndex = 0; } else { oWeb.getRunProc("update Gy_Czygl set Czymc='" + txtCzymc.Text.ToString() + "'" + ",Explain='" + txtExplain.Text.ToString() + "'" + ",HEmpID=" + ClsPub.isLong(txtHEmpID.Tag).ToString() + ",HK3UserID=" + ClsPub.isLong(txtHK3UserID.Tag).ToString() + ",HKeeperID=" + ClsPub.isLong(txtHKeeperID.Tag).ToString() + ",HKeeper='" + txtHKeeperID.Text.ToString() + "'" + ",HSecManagerID=" + ClsPub.isLong(txtHSecManagerID.Tag).ToString() + ",HSecManager='" + txtHSecManagerID.Text.ToString() + "'" + ",HSellManID=" + ClsPub.isLong(txtHSellManID.Tag).ToString() + ",HSellMan='" + txtHSellManID.Text.ToString() + "'" + ",HDeptID=" + ClsPub.isLong(txtHDeptID.Tag).ToString() + ",HDept='" + txtHDeptID.Text.ToString() + "'" + ",HWhID=" + ClsPub.isLong(txtHWhID.Tag).ToString() + ",HWHName='" + txtHWhID.Text.ToString() + "'" + ",HSupID=" + ClsPub.isLong(txtHSupID.Tag).ToString() + ",HSupName='" + txtHSupID.Text.ToString() + "'" + ",HCloudUserName='" + txtHCloudUserName.Text.ToString() + "'" + ",HCloudUserPsd='" + txtHCloudUserPsd.Text.ToString() + "'" + ",HUSEORGID=" + HOrgID.ToString() + ",HGroup='" + textHGroupID.Text.ToString() + "'" + ",HGroupID=" + ClsPub.isLong(textHGroupID.Tag).ToString() + ",HProc='" + textHProcNo.Text.ToString() +"'"+ ",HProcName='" + textHProcNo.Tag.ToString() +"'"+ ",HProcNo='" + HProcNo + "'" + ",HWorkCenter='" + textHWorkCenterID.Text.ToString() + "'" + ",HWorkCenterID=" + ClsPub.isLong(textHWorkCenterID.Tag).ToString() + ",HSource='" + textHSourceID.Text.ToString() + "'" + ",HSourceID=" + ClsPub.isLong(textHSourceID.Tag).ToString() + "where Czybm='" + Czybm + "'", ref DBUtility.ClsPub.sExeReturnInfo); // oWeb.getRunProc("delete from System_UserGroupInfo where UserId='" + Czybm + "'", ref DBUtility.ClsPub.sExeReturnInfo); for (int i = 0; i <= LbYes.Items.Count - 1; i++) { oWeb.getRunProc("insert into System_UserGroupInfo (GroupId,UserId) values (" + ClsPub.isLong(Get_Code(this.LbYes.Items[i].ToString())) + ",'" + Czybm + "')", ref DBUtility.ClsPub.sExeReturnInfo); } lblError.Text = "* Ð޸ijɹ¦£¡"; tabControl1.SelectedIndex = 0; } } //µ¥¾ÝÍêÕûÐÔÅÐ¶Ï private bool Sub_AllowSave() { if (txtCzybm.Text.Trim() == "") { lblError.Text = "* ±àÂë²»ÄÜΪ¿Õ£¡"; return false; } if (txtCzymc.Text.Trim() == "") { lblError.Text = "* Óû§Ãû²»ÄÜΪ¿Õ£¡"; return false; } // ÑéÖ¤ÃÜÂë if (txtCzymm.Text.Trim() != "") { if (txtCzymm.Text.Trim() != txtCzyyz.Text.Trim()) { lblError.Text = "* ÃÜÂëÑéÖ¤´íÎó£¡"; return false; } } // Óû§±àÂëºÍÓû§Ãû ÊÇ·ñÖظ´ if (InputMode == Pub_Class.ClsPub.Enum_InputMode.InputMode_AddNew) { DataSet oDs = new DataSet(); DataSet oDS = new DataSet(); oDs = oWeb.getDataSetBySQL("select * from Gy_Czygl where Czybm='" + txtCzybm.Text.ToString() + "'", "Gy_Czygl", ref DBUtility.ClsPub.sExeReturnInfo); oDS = oWeb.getDataSetBySQL("select * from Gy_Czygl where Czymc='" + txtCzymc.Text.ToString() + "'", "Gy_Czygl", ref DBUtility.ClsPub.sExeReturnInfo); if (oDs.Tables[0].Rows.Count != 0) { lblError.Text = "* ±àÂëÖظ´£¡"; return false; } if (oDS.Tables[0].Rows.Count != 0) { lblError.Text = "* Óû§ÃûÖظ´£¡"; return false; } } return true; } //²ð·Ö private string Get_Code(string sCode) { sCode = sCode.Trim(); char c = Convert.ToChar("-"); string[] s = sCode.Split(c); if (s.Length > 1) { return s[0].Trim(); } else { return "0"; } } //ÐÞ¸ÄÃÜÂë private void cmdPassWord_Click(object sender, EventArgs e) { Xt_Password oPassword = new Xt_Password(); oPassword.Czybm = this.Czybm; oPassword.ShowDialog(); } #region ¶ÔÓ¦»ù´¡×ÊÁÏÉèÖà //²éÕÒ½ÇÉ« public int i = 0; //ÐеÄϱê¿ØÖÆÆ÷ (*****¿ØÖÆ´ÓµÚ¼¸ÐпªÊ¼±éÀú*****) public bool notNull = false; //µÝ¹é¿ØÖÆÆ÷ (*****¿ØÖÆÊÇ·ñ¿Éµ÷Óõݹé******) private void cmdHGroup_Click(object sender, EventArgs e) { string sFind = txtHGroup.Text.Trim(); string sGroup = ""; for (int a = i; a <= LbNo.Items.Count - 1; a++) { sGroup = this.LbNo.Items[a].ToString(); if (sGroup.IndexOf(sFind) != -1) { this.LbNo.SelectedIndex = a; i = a + 1; //ʹÏ´αéÀú´Ó¸ÃÐеÄÏÂÒ»ÐпªÊ¼²éÕÒ notNull = true; return; //ÉèÖÃnotNullΪÕæ,Ìø³ö } } if (notNull) //ʼÖÕδÕÒµ½Æ¥ÅäÏîÔò½øÈë { i = 0; //ÖØÖôӵÚÒ»ÐбéÀú notNull = false; //ÉèÖÃnotNullΪ¼Ù,Èç¹ûÔÙÒ»´Î´ÓµÚÒ»ÐбéÀúδÕÒµ½Æ¥ÅäÏîÔò²»»áÔÙ½øÈëIFµ÷Óõݹé cmdHGroup_Click(sender, e); //µÝ¹é } else { MessageBox.Show("δÕÒµ½£¡£¡"); } } private void cmdHEmpID_Click(object sender, EventArgs e) { SCM.ClsIF_Employee_View oEmp = new SCM.ClsIF_Employee_View(); string DeWhere = ""; DeWhere = " "; if (oEmp.RefreshView(DeWhere)) { this.txtHEmpID.Text = oEmp.oModel.HName; this.txtHEmpID.Tag = oEmp.oModel.HItemID.ToString(); } else { this.txtHEmpID.Text = ""; this.txtHEmpID.Tag = 0; } } private void txtHEmpID_TextChanged(object sender, EventArgs e) { if (txtHEmpID.Text.Trim() == "") { txtHEmpID.Tag = "0"; } } //------------------------------------------------------- private void cmdHK3UserID_Click(object sender, EventArgs e) { SCM.ClsIF_User_View oUser = new SCM.ClsIF_User_View(); string DeWhere = ""; DeWhere = " "; if (oUser.RefreshView(DeWhere)) { this.txtHK3UserID.Text = oUser.oModel.HName; this.txtHK3UserID.Tag = oUser.oModel.HItemID.ToString(); } else { this.txtHK3UserID.Text = ""; this.txtHK3UserID.Tag = 0; } } private void txtHK3UserID_TextChanged(object sender, EventArgs e) { if (txtHK3UserID.Text.Trim() == "") { txtHK3UserID.Tag = "0"; } } private void cmdHKeeperID_Click(object sender, EventArgs e) { SCM.ClsIF_Employee_View oEmp = new SCM.ClsIF_Employee_View(); string DeWhere = ""; DeWhere = " "; if (oEmp.RefreshView(DeWhere)) { this.txtHKeeperID.Text = oEmp.oModel.HName; this.txtHKeeperID.Tag = oEmp.oModel.HItemID.ToString(); } else { this.txtHKeeperID.Text = ""; this.txtHKeeperID.Tag = 0; } } private void txtHKeeperID_TextChanged(object sender, EventArgs e) { if (txtHKeeperID.Text.Trim() == "") { txtHKeeperID.Tag = "0"; } } private void cmdHSecManagerID_Click(object sender, EventArgs e) { SCM.ClsIF_Employee_View oEmp = new SCM.ClsIF_Employee_View(); string DeWhere = ""; DeWhere = " "; if (oEmp.RefreshView(DeWhere)) { this.txtHSecManagerID.Text = oEmp.oModel.HName; this.txtHSecManagerID.Tag = oEmp.oModel.HItemID.ToString(); } else { this.txtHSecManagerID.Text = ""; this.txtHSecManagerID.Tag = 0; } } private void txtHSecManagerID_TextChanged(object sender, EventArgs e) { if (txtHSecManagerID.Text.Trim() == "") { txtHSecManagerID.Tag = "0"; } } private void cmdHSellManID_Click(object sender, EventArgs e) { SCM.ClsIF_Employee_View oEmp = new SCM.ClsIF_Employee_View(); string DeWhere = ""; DeWhere = " "; if (oEmp.RefreshView(DeWhere)) { this.txtHSellManID.Text = oEmp.oModel.HName; this.txtHSellManID.Tag = oEmp.oModel.HItemID.ToString(); } else { this.txtHSellManID.Text = ""; this.txtHSellManID.Tag = 0; } } private void txtHSellManID_TextChanged(object sender, EventArgs e) { if (txtHSellManID.Text.Trim() == "") { txtHSellManID.Tag = "0"; } } private void cmdHDeptID_Click(object sender, EventArgs e) { HOrgID = oWeb.get_ORGANIZATIONSIDByName(cmbHOrgID.Text); if (HOrgID == -1) { MessageBox.Show("Ñ¡Ôñ×éÖ¯ÓдíÎ󣬻ñÈ¡ÐÅϢʧ°Ü£¡"); return; } SCM.ClsIF_Department_View oDep = new SCM.ClsIF_Department_View(); string DeWhere = ""; DeWhere = " and HUSEORGID = " + HOrgID; if (oDep.RefreshView(DeWhere)) { this.txtHDeptID.Text = oDep.oModel.HName; this.txtHDeptID.Tag = oDep.oModel.HItemID.ToString(); } else { this.txtHDeptID.Text = ""; this.txtHDeptID.Tag = 0; } } private void txtHDeptID_TextChanged(object sender, EventArgs e) { if (txtHDeptID.Text.Trim() == "") { txtHDeptID.Tag = "0"; } } private void cmdHWhID_Click(object sender, EventArgs e) { HOrgID = oWeb.get_ORGANIZATIONSIDByName(cmbHOrgID.Text); if (HOrgID == -1) { MessageBox.Show("Ñ¡Ôñ×éÖ¯ÓдíÎ󣬻ñÈ¡ÐÅϢʧ°Ü£¡"); return; } SCM.ClsIF_Warehouse_View oWh = new SCM.ClsIF_Warehouse_View(); string DeWhere = ""; DeWhere = " and HUSEORGID = " + HOrgID; if (oWh.RefreshView(DeWhere)) { this.txtHWhID.Text = oWh.oModel.HName; this.txtHWhID.Tag = oWh.oModel.HItemID.ToString(); } else { this.txtHWhID.Text = ""; this.txtHWhID.Tag = 0; } } private void txtHWhID_TextChanged(object sender, EventArgs e) { if (txtHWhID.Text.Trim() == "") { txtHWhID.Tag = "0"; } } private void cmdHSupID_Click(object sender, EventArgs e) { HOrgID = oWeb.get_ORGANIZATIONSIDByName(cmbHOrgID.Text); if (HOrgID == -1) { MessageBox.Show("Ñ¡Ôñ×éÖ¯ÓдíÎ󣬻ñÈ¡ÐÅϢʧ°Ü£¡"); return; } SCM.ClsIF_Supplier_View oSup = new SCM.ClsIF_Supplier_View(); string DeWhere = ""; DeWhere = " and HUSEORGID = " + HOrgID; if (oSup.RefreshView(DeWhere)) { this.txtHSupID.Text = oSup.oModel.HName; this.txtHSupID.Tag = oSup.oModel.HItemID.ToString(); } else { this.txtHSupID.Text = ""; this.txtHSupID.Tag = 0; } } private void txtHSupID_TextChanged(object sender, EventArgs e) { if (txtHSupID.Text.Trim() == "") { txtHSupID.Tag = "0"; } } #endregion private void cmdHGroupID_Click(object sender, EventArgs e) { SCM.ClsGy_Group_View oEmp = new SCM.ClsGy_Group_View(); string DeWhere = ""; DeWhere = " "; if (oEmp.RefreshView(DeWhere)) { this.textHGroupID.Text = oEmp.oModel.HName; this.textHGroupID.Tag = oEmp.oModel.HItemID.ToString(); } else { this.textHGroupID.Text = ""; this.textHGroupID.Tag = 0; } } private void cmdHProcNo_Click(object sender, EventArgs e) { SCM.ClsIF_Process_View oEmp = new SCM.ClsIF_Process_View(); string DeWhere = ""; DeWhere = " "; if (oEmp.RefreshView(DeWhere)) { this.textHProcNo.Text = oEmp.oModel.HName; this.textHProcNo.Tag = oEmp.oModel.HNumber; HProcNo = oEmp.oModel.HRemark; } else { this.textHProcNo.Text = ""; this.textHProcNo.Tag = 0; } } private void cmdHSourceID_Click(object sender, EventArgs e) { SCM.ClsIF_Source_View oEmp = new SCM.ClsIF_Source_View(); string DeWhere = ""; DeWhere = " "; if (oEmp.RefreshView(DeWhere)) { this.textHSourceID.Text = oEmp.oModel.HName; this.textHSourceID.Tag = oEmp.oModel.HItemID.ToString(); } else { this.textHSourceID.Text = ""; this.textHSourceID.Tag = 0; } } private void cmdHWorkCenterID_Click(object sender, EventArgs e) { SCM.ClsIF_WorkCenter_View oEmp = new SCM.ClsIF_WorkCenter_View(); string DeWhere = ""; DeWhere = " "; if (oEmp.RefreshView(DeWhere)) { this.textHWorkCenterID.Text = oEmp.oModel.HName; this.textHWorkCenterID.Tag = oEmp.oModel.HItemID.ToString(); } else { this.textHWorkCenterID.Text = ""; this.textHWorkCenterID.Tag = 0; } } } }