/// <summary> /// @author : TrungMT /// @CreateDate:05/05/2008 /// @Description: show form and play many clip /// </summary> public FrmClipView(DataRowCollection pClipRows, TimeSpan ptServerLocalDelay,QTC.Adv.DataModule.Single.Workstation workstation) { InitializeComponent(); this.workstation = workstation; mClipRows = pClipRows; Stopped = true; InitTimmerList(); mTimer.Enabled = true; mtServerLocalDelay = ptServerLocalDelay; mFullScreen = new FullScreen(this); }
internal void UpdateItem(Workstation wupdate) { BWorkstation workstation = new BWorkstation(); dgrWorkstation["colCode", currentRow].Value = wupdate.WorkstationCode; dgrWorkstation["colName", currentRow].Value = wupdate.Name; dgrWorkstation["colIP", currentRow].Value = wupdate.IPAddress; dgrWorkstation["colUinitManager", currentRow].Value = wupdate.UnitManager; dgrWorkstation["colUniManagerTel", currentRow].Value = wupdate.PhoneNumber; dgrWorkstation["colAddress", currentRow].Value = wupdate.Address; dgrWorkstation["colAdminManger", currentRow].Value = wupdate.AdminName; dgrWorkstation["colAdminManagerTel", currentRow].Value = wupdate.AdminPhone; }
public DataSet Login(Workstation pWorkstation) { IDbDataParameter[] parameters = { MakeParameter("@CODE", DbType.String, 10), MakeParameter("@PASSWORD", DbType.String, 400) }; parameters[0].Value = pWorkstation.WorkstationCode; parameters[1].Value = pWorkstation.Password; DataSet ds = RunProcedure("sp_ADV_WORKSTATION_LOGIN", parameters, "ADV_WORKSTATION"); return ds; }
internal void AddItem(Workstation wupdate) { BWorkstation workstation = new BWorkstation(); DataRow newRow = ds.Tables[0].NewRow(); currentRow = dgrWorkstation.Rows.Count + 1; newRow["STT"] = currentRow; newRow["WORKSTATION_ID"] = wupdate.WorkstationId; newRow["CODE"] = wupdate.WorkstationCode; newRow["NAME"] = wupdate.Name; newRow["IP"] = wupdate.IPAddress; newRow["UNIT_MANAGER"] = wupdate.UnitManager; newRow["TEL"] = wupdate.PhoneNumber; newRow["ADDRESS"] = wupdate.Address; newRow["ADMIN_NAME"] = wupdate.AdminName; newRow["ADMIN_TEL"] = wupdate.AdminPhone; ds.Tables[0].Rows.Add(newRow); }
public static Workstation GetWorkstasion(int workstationId) { Workstation wkt = new Workstation(); ConnectionFactory Connection = InternalGlobal.MakeConnectionFactory(); PrWorkstation dworkstation = new PrWorkstation(Connection); Connection.Open(); DataRow dr = dworkstation.Retrieves(workstationId); Connection.Close(); wkt.WorkstationId = (int)dr["WORKSTATION_ID"]; wkt.WorkstationCode = (string)dr["CODE"]; wkt.Name= (string)dr["NAME"]; wkt.Password = (string)dr["PASSWORD"]; wkt.IPAddress = (string)dr["IP"]; wkt.UnitManager = (string)dr["UNIT_MANAGER"]; wkt.Address = (string)dr["ADDRESS"]; wkt.PhoneNumber = (string)dr["TEL"]; wkt.AdminName = (string)dr["ADMIN_NAME"]; wkt.AdminPhone = (string)dr["ADMIN_TEL"]; wkt.AreaId = (int)dr["AREA_ID"]; return wkt; }
private void DeleteRowsSelected() { int workstationId = (int)dgrWorkstation["colID",currentRow].Value; BWorkstation bw = new BWorkstation(); Workstation w = new Workstation(workstationId); try { bool ret = bw.Delete(w); } catch (Exception exp) { MsgBoxVN.ShowError(exp.Message,Dic.STRING_WARNING); } }
private void LoadDetail(DataRow dr) { workstation = new QTC.Adv.DataModule.Single.Workstation(); workstation.WorkstationId = (int)dr["WORKSTATION_ID"]; workstation.WorkstationCode = (string)dr["CODE"]; workstation.Name = (string)dr["NAME"]; workstation.Password = (string)dr["PASSWORD"]; workstation.IPAddress = (string)dr["IP"]; workstation.UnitManager = (string)dr["UNIT_MANAGER"]; workstation.Address = (string)dr["ADDRESS"]; workstation.PhoneNumber = (string)dr["TEL"]; workstation.AdminName = (string)dr["ADMIN_NAME"]; workstation.AdminPhone = (string)dr["ADMIN_TEL"]; workstation.AreaId = (int)dr["AREA_ID"]; workstation.Status = dr["STATUS"]==DBNull.Value?(byte)0:(bool)dr["STATUS"] ? (byte)1:(byte)0 ; workstation.LogTime = (DateTime)dr["LOG_TIME"]; }
private void ShowFormUpdate() { wupdate = BWorkstation.GetWorkstasion(workstationId); txtCode.Text = wupdate.WorkstationCode; txtName.Text = wupdate.Name; txtPassword.Text = "QTC-ADVERTISE"; txtAddress.Text = wupdate.Address; txtIP.Text = wupdate.IPAddress.Trim(); txtUnitManager.Text = wupdate.UnitManager; txtAddress.Text = wupdate.Address; txtTel.Text = wupdate.PhoneNumber.Trim(); txtAdminManager.Text = wupdate.AdminName; txtAdminTel.Text = wupdate.AdminPhone.Trim(); DisPlayAreaName(wupdate.AreaId); }
private void SaveNew() { BWorkstation newWT = new BWorkstation(); Workstation data = new Workstation(txtCode.Text, txtName.Text, MD5.EncryptionToString(txtPassword.Text.Trim()), txtIP.Text, txtUnitManager.Text, txtAddress.Text, txtTel.Text, txtAdminManager.Text, txtAdminTel.Text, (int)cboArea.SelectedValue); try { data.WorkstationId = newWT.Add(data); frmWorkstation.AddItem(data); ClearFields(); } catch (SqlException exp) { if(exp.Number ==2627) MsgBoxVN.ShowError("Mã máy trạm đã tồn tại.","Thông báo"); else MsgBoxVN.ShowError("Có lỗi trong quá trình cập nhật.\n\nLỗi ---> " + exp.Message, "Thông báo"); return; } }
/// <summary> /// @author : khoaht /// @createDate : 14/7/2009 /// </summary> /// <param name="code"></param> private void WriteLoginLog(string code) { try { BWorkstation bw = new BWorkstation(); DataRow dr = BWorkstation.SearchCode(code).Tables[0].Rows[0]; Workstation mw = new Workstation(); mw.WorkstationId = (int)dr["WORKSTATION_ID"]; mw.WorkstationCode = (string)dr["CODE"]; mw.Name = (string)dr["NAME"]; mw.Password = (string)dr["PASSWORD"]; mw.IPAddress = (string)dr["IP"]; mw.UnitManager = (string)dr["UNIT_MANAGER"]; mw.Address = (string)dr["ADDRESS"]; mw.PhoneNumber = (string)dr["TEL"]; mw.AdminName = (string)dr["ADMIN_NAME"]; mw.AdminPhone = (string)dr["ADMIN_TEL"]; mw.AreaId = (int)dr["AREA_ID"]; mw.Status = (byte)1; mw.LogTime = DateTime.Now; bw.UpdateLog(mw); } catch { } }
public bool UpdateLog(Workstation workstation) { PrWorkstation dworkstation = new PrWorkstation(Connection); bool update = false; try { Open(); update = dworkstation.UpdateLog(workstation); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return update; }
public bool Delete(Workstation workstation) { PrWorkstation dworkstation = new PrWorkstation(Connection); bool delete = false; try { Open(); delete = dworkstation.Delete(workstation); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return delete; }
public int Add(Workstation workstation) { PrWorkstation dworkstation = new PrWorkstation(Connection); int workstationId = -1; try { Open(); workstationId = dworkstation.Create(workstation); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return workstationId; }
private Global() { mWorkstation = new QTC.Adv.DataModule.Single.Workstation(); }
public static void Logout() { mWorkstation = null; }
public static bool Login(string pstrWorkstationCode, string pstrPasswordEngcypt, bool pblnSaveInfo) { bool blnLogin=false; try { Logout(); mWorkstation = new QTC.Adv.DataModule.Single.Workstation(); mWorkstation.WorkstationId = -1; mWorkstation.WorkstationCode = pstrWorkstationCode.Trim(); mWorkstation.Password = Qtc.Libs.Security.MD5.EncryptionToString(pstrPasswordEngcypt); BWorkstation bWorkstation = new BWorkstation(); blnLogin = bWorkstation.Login(mWorkstation); // Load FTP info QTC.Adv.BusinessModule.Global.LoadPropertiesInfo(); if (pblnSaveInfo) { Properties.Settings.Default.UserName = pstrWorkstationCode; Properties.Settings.Default.Password = pstrPasswordEngcypt; Properties.Settings.Default.SaveInfo = pblnSaveInfo; Properties.Settings.Default.WorkstationId = mWorkstation.WorkstationId; Properties.Settings.Default.Save(); } else { Properties.Settings.Default.UserName = ""; Properties.Settings.Default.Password = ""; Properties.Settings.Default.SaveInfo = pblnSaveInfo; Properties.Settings.Default.Save(); } } catch (Exception) { return false; } return blnLogin; }
/// <summary> /// @author : khoaht /// @createDate : 14/7/2008 /// </summary> /// <param name="pWorkstation"></param> /// <returns></returns> public bool Login(Workstation pWorkstation) { try { Open(); // Login PrWorkstation prWorkstation = new PrWorkstation(mcnnFactory); // Return if cannot login DataSet ds = prWorkstation.Login(pWorkstation); if (ds.Tables[0].Rows.Count <= 0) return false; // Check match password if (!Qtc.Libs.Security.MD5.CompareHash(pWorkstation.Password, (string)ds.Tables[0].Rows[0]["PASSWORD"])) return false; // Get workstation info pWorkstation.IPAddress = (string) ds.Tables[0].Rows[0]["IP"]; pWorkstation.WorkstationId = (int) ds.Tables[0].Rows[0]["WORKSTATION_ID"]; pWorkstation.Name = (string) ds.Tables[0].Rows[0]["NAME"]; // WRITE LOGIN LOG WriteLoginLog(pWorkstation.WorkstationCode); return true; } catch (Exception exp) { throw exp; } finally { Close(); } //return false; }
public bool UpdateLog(Workstation workstation) { IDbDataParameter[] parameters = { MakeParameter("@CODE", DbType.String, 10), MakeParameter("@NAME", DbType.String, 200), MakeParameter("@PASSWORD", DbType.String, 400), MakeParameter("@IP", DbType.String, 30), MakeParameter("@UNIT_MANAGER", DbType.String, 200), MakeParameter("@ADDRESS", DbType.String, 400), MakeParameter("@TEL", DbType.String, 20), MakeParameter("@ADMIN_NAME", DbType.String, 200), MakeParameter("@ADMIN_TEL", DbType.String, 20), MakeParameter("@AREA_ID", DbType.Int32, 4), MakeParameter("@STATUS", DbType.Byte, 1), MakeParameter("@LOG_TIME", DbType.DateTime,8), MakeParameter("@WORKSTATION_ID", DbType.Int32, 4), }; parameters[0].Value = workstation.WorkstationCode; parameters[1].Value = workstation.Name; parameters[2].Value = workstation.Password; parameters[3].Value = workstation.IPAddress; parameters[4].Value = workstation.UnitManager; parameters[5].Value = workstation.Address; parameters[6].Value = workstation.PhoneNumber; parameters[7].Value = workstation.AdminName; parameters[8].Value = workstation.AdminPhone; parameters[9].Value = workstation.AreaId; parameters[10].Value = workstation.Status; parameters[11].Value = workstation.LogTime; parameters[12].Value = workstation.WorkstationId; int rowsAffected = 0; RunProcedure("sp_ADV_WORKSTATION_Update_Log", parameters, out rowsAffected); return (rowsAffected == 1); }