private void buttonLogin_Click(object sender, EventArgs e) { string userName, pw, dbPW; userName = userNameText.Text.Trim(); pw = passWordText.Text.Trim(); SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("uN", userName.Trim())); sqlcmd.CommandText = "SELECT * FROM [Esunnet].[dbo].[TS_ADMIN] where TS_ADMIN_ID=@uN"; System.Data.SqlClient.SqlDataReader SDR = sqlcmd.ExecuteReader(); SDR.Read(); dbPW = SDR["TS_PASSWORD"].ToString();; sqlcmd.Dispose(); sqlcon.Dispose(); if (!dbPW.Equals(pw)) { MessageBox.Show("密码错误", "警告"); return; } this.Visible = false; ec = new EsunnetConfig(); ec.Show(); }
private void addOrUpdate(string name, string add, string id) { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("name", name.Trim())); sqlcmd.Parameters.Add(new SqlParameter("add", add.Trim())); if (string.IsNullOrEmpty(id)) { sqlcmd.CommandText = " insert into TS_POPUP_URL(TS_URLNAME,TS_URLADDRESS) values(@name,@add)"; } else { //修改 sqlcmd.Parameters.Add(new SqlParameter("id", id.Trim())); sqlcmd.CommandText = " update TS_POPUP_URL set TS_URLNAME=@name,TS_URLADDRESS=@add where TS_URLNAME=@id"; } int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); }
public void grant(string groupId, string agentId, string handel) { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("groupId", groupId.Trim())); sqlcmd.Parameters.Add(new SqlParameter("agentId", agentId.Trim())); if (handel == "del") { sqlcmd.CommandText = "delete from [TS_AGENT_IN_GROUP] where [TS_GROUP_ID]=@groupId and TS_AGENT_ID=@agentId"; } else if (handel == "add") { sqlcmd.CommandText = "insert into TS_AGENT_IN_GROUP (TS_GROUP_ID,TS_AGENT_ID) values(@groupId,@agentId)"; } else { sqlcmd.Parameters.Add(new SqlParameter("agentLevel", handel.Trim())); sqlcmd.CommandText = "update TS_AGENT_IN_GROUP set TS_AGENT_LEVEL=@agentLevel where [TS_GROUP_ID]=@groupId and TS_AGENT_ID=@agentId"; } int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); }
private void addOrUpdate(string agentName, string agentId, string agentDescription) { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("agentName", agentName)); sqlcmd.Parameters.Add(new SqlParameter("agentDescription", agentDescription)); if (string.IsNullOrEmpty(agentId)) { sqlcmd.CommandText = " insert into TS_AGENT_GROUP(TS_GROUP_ID,TS_GROUP_NAME,TS_DESCRIPTION) values(@agentName,@agentName,@agentDescription)"; } else { //修改 sqlcmd.Parameters.Add(new SqlParameter("agentId", agentId)); sqlcmd.CommandText = " update TS_AGENT_GROUP set TS_GROUP_NAME=@agentName,TS_DESCRIPTION=@agentDescription where TS_GROUP_ID=@agentId"; } int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); }
public void bindDatagridView() { db = new Tools.DataBase(); SqlConnection sqlcon = db.getConnection(); SqlDataAdapter sqldap = new SqlDataAdapter("SELECT [TS_PARAMETER] as 'key',[TS_DESCRIPTION] as 'description',[TS_VALUE] as 'value' FROM [Esunnet].[dbo].[TS_MEDIASERVER_SET]", sqlcon); DataSet ds = new DataSet(); sqldap.Fill(ds); this.ctiDriveDataGridView.DataSource = ds.Tables[0]; }
public void bindDatagridView() { db = new Tools.DataBase(); SqlConnection sqlcon = db.getConnection(); SqlDataAdapter sqldap = new SqlDataAdapter("SELECT [TS_GROUP_NAME] as agentName, TS_DESCRIPTION as agentDescription , [TS_GROUP_ID] as agentId FROM [Esunnet].[dbo].[TS_AGENT_GROUP] order by TS_GROUP_ID", sqlcon); DataSet ds = new DataSet(); sqldap.Fill(ds); this.DataGridView.DataSource = ds.Tables[0]; }
public void bindDatagridView() { db = new Tools.DataBase(); SqlConnection sqlcon = db.getConnection(); SqlDataAdapter sqldap = new SqlDataAdapter("SELECT [TS_URLNAME] as URLName ,[TS_URLADDRESS] as URLAdd ,[TS_URLNAME] as id FROM [Esunnet].[dbo].[TS_POPUP_URL]", sqlcon); DataSet ds = new DataSet(); sqldap.Fill(ds); this.URLConfigDataGridView.DataSource = ds.Tables[0]; }
public void bindDatagridView() { db = new Tools.DataBase(); SqlConnection sqlcon = db.getConnection(); SqlDataAdapter sqldap = new SqlDataAdapter("SELECT [TS_NUMBER] as number,case TS_DEVICE_TYPE when '1' then '模拟' when '0' then '数字' when '2' then '路由' end as deviceType,case TS_USER_TYPE when '1' then '坐席' when '0' then '自动语音' when '2' then '其他' end as userType,[TS_CHANNEL] as Channel,TS_DESCRIPTION as description FROM [Esunnet].[dbo].[TS_DEVICE] order by TS_CHANNEL", sqlcon); DataSet ds = new DataSet(); sqldap.Fill(ds); this.DriveDataGridView.DataSource = ds.Tables[0]; }
public void bindDatagridView() { db = new Tools.DataBase(); SqlConnection sqlcon = db.getConnection(); SqlDataAdapter sqldap = new SqlDataAdapter("SELECT [TS_AGENT_ID] as agentId,[TS_AGENT_ID] as Id,[TS_AGENT_NAME] as AgentName,case [TS_IS_MONITOR] when '1' then '是' else '否' end as isMonitor ,case [TS_CATEGORY] when '1' then '呼入' when '3' then '全部' when '2' then '呼出' end as serviceType FROM [Esunnet].[dbo].[TS_AGENT] order by TS_AGENT_ID ", sqlcon); DataSet ds = new DataSet(); sqldap.Fill(ds); this.DataGridView.DataSource = ds.Tables[0]; }
private void addOrUpdate(string number, string userType, string driveType, string description, string channel) { int ut = 0, dt = 0; SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); if (userType.Trim() == "坐席") { ut = 1; } else if (userType.Trim() == "自动语音") { ut = 0; } else { ut = 2; } if (driveType.Trim() == "模拟") { dt = 1; } else if (driveType.Trim() == "数字") { dt = 0; } else { dt = 2; } sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("number", number.Trim())); sqlcmd.Parameters.Add(new SqlParameter("userType", ut)); sqlcmd.Parameters.Add(new SqlParameter("driveType", dt)); if (string.IsNullOrEmpty(channel)) { //添加 channel = queryChannelMax().ToString(); sqlcmd.Parameters.Add(new SqlParameter("channel", channel.Trim())); sqlcmd.CommandText = " insert into TS_DEVICE(TS_NUMBER,TS_DEVICE_TYPE,TS_USER_TYPE,TS_DESCRIPTION,TS_CHANNEL) values(@number,@driveType,@userType,@number,@channel)"; } else { //修改 sqlcmd.CommandText = " update TS_DEVICE set TS_USER_TYPE=@userType,TS_DEVICE_TYPE=@driveType where TS_NUMBER=@number"; } int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); }
public void bindDatagridView() { db = new Tools.DataBase(); SqlConnection sqlcon = db.getConnection(); SqlDataAdapter sqldap = new SqlDataAdapter(" select TS_CAUSE_ID as caseId,TS_DESCRIPTION as description from TS_LEAVE_DESCRIPTION ", sqlcon); // sqldap.SelectCommand.Parameters.Add(new SqlParameter("groupId", groupId.Trim())); DataSet ds = new DataSet(); sqldap.Fill(ds); this.DriveDataGridView.DataSource = ds.Tables[0]; }
private void addOrUpdate(string id, string agentId, string agentName, string isMonitor, string serviceType) { int mi = 0, si = 0; SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); if (isMonitor.Trim() == "是") { mi = 1; } else { mi = 0; } if (serviceType.Trim() == "呼出") { si = 2; } else if (serviceType.Trim() == "呼入") { si = 1; } else { si = 3; } sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("agentName", agentName.Trim())); sqlcmd.Parameters.Add(new SqlParameter("isMonitor", mi)); sqlcmd.Parameters.Add(new SqlParameter("serviceType", si)); sqlcmd.Parameters.Add(new SqlParameter("agentId", agentId)); if (string.IsNullOrEmpty(id)) { sqlcmd.CommandText = " insert into TS_AGENT(TS_AGENT_ID,TS_AGENT_NAME,TS_IS_MONITOR,TS_CATEGORY,TS_PASSWORD,TS_AGENT,TS_SERVERFLAG) values(@agentId,@agentName,@isMonitor,@serviceType,@agentId,'','')"; } else { //修改 sqlcmd.Parameters.Add(new SqlParameter("Id", id.Trim())); sqlcmd.CommandText = " update TS_AGENT set TS_AGENT_ID=@agentId,TS_AGENT_NAME=@agentName,TS_IS_MONITOR=@isMonitor,TS_CATEGORY=@serviceType where TS_AGENT_ID=@Id"; } int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); }
private void delteDrive(string number, string channel) { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("channel", channel.Trim())); sqlcmd.CommandText = "delete from [TS_DEVICE] where TS_CHANNEL=@channel"; int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); }
private void delteDrive(string id) { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("id", id.Trim())); sqlcmd.CommandText = "delete from [TS_AGENT] where [TS_AGENT_ID]=@id"; int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); }
private void deleteURLConfig(string id) { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("id", id.Trim())); sqlcmd.CommandText = "delete from [TS_POPUP_URL] where TS_URLNAME=@id"; int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); }
public void update(string key, string description, string value) { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("key", key.Trim())); sqlcmd.Parameters.Add(new SqlParameter("value", value.Trim())); sqlcmd.Parameters.Add(new SqlParameter("description", description.Trim())); sqlcmd.CommandText = " update TS_MEDIASERVER_SET set TS_VALUE=@value,TS_DESCRIPTION=@description where TS_PARAMETER=@key"; int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); }
private void modifyAgentPassword() { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.Parameters.Add(new SqlParameter("Password", Password.Trim())); sqlcmd.Parameters.Add(new SqlParameter("agentId", userName.Trim())); sqlcmd.CommandText = " update TS_AGENT set TS_PASSWORD=@Password where TS_AGENT_ID=@agentId"; int x = sqlcmd.ExecuteNonQuery(); sqlcmd.Dispose(); sqlcon.Dispose(); MessageBox.Show("修改成功"); }
public int queryChannelMax() { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.CommandText = "select max(TS_CHANNEL) as channelMax from TS_DEVICE"; System.Data.SqlClient.SqlDataReader SDR = sqlcmd.ExecuteReader(); if (SDR.HasRows) { SDR.Read(); max = Convert.ToInt32(SDR["channelMax"]); } sqlcmd.Dispose(); sqlcon.Dispose(); max = max + 1; return(max); }
public void showSonNode(System.Windows.Forms.TreeNode currentNode) { System.Windows.Forms.TreeNode treeNode; string sonNodeName; SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; string last = ""; if (currentNode.Name == "agentGroup") { sqlcmd.CommandText = "select [TS_GROUP_NAME] as nodeId from [TS_AGENT_GROUP] order by TS_GROUP_ID"; last = "组"; } System.Data.SqlClient.SqlDataReader SDR = sqlcmd.ExecuteReader(); while (SDR.Read()) { // SDR.NextResult(); sonNodeName = SDR["nodeId"].ToString(); treeNode = new System.Windows.Forms.TreeNode(sonNodeName); treeNode.Name = currentNode.Name + "<" + sonNodeName; treeNode.Text = sonNodeName + last; if (!currentNode.Nodes.ContainsKey(treeNode.Name)) { currentNode.Nodes.Add(treeNode); } } sqlcmd.Dispose(); sqlcon.Dispose(); }
public void bindDatagridView() { db = new Tools.DataBase(); SqlConnection sqlcon = db.getConnection(); SqlDataAdapter sqldap = new SqlDataAdapter(" select TS_AGENT.TS_AGENT_id as agentId,TS_AGENT.TS_AGENT_NAME as agentName, case when TS_AGENT.TS_AGENT_id in (select TS_AGENT.TS_AGENT_ID from TS_AGENT_IN_GROUP left join TS_AGENT on TS_AGENT_IN_GROUP.TS_AGENT_ID=TS_AGENT.TS_AGENT_ID where TS_AGENT_IN_GROUP.TS_GROUP_ID=@groupId ) then 'true' else 'false' end as inAgentGroup, isNull(groupInfo.TS_AGENT_LEVEL,-1) as agentLevel" + " from TS_AGENT left join ( select TS_AGENT_IN_GROUP.TS_GROUP_ID,TS_AGENT.TS_AGENT_ID,TS_AGENT_LEVEL,TS_AGENT_IN_GROUP.TS_SERVERFLAG from TS_AGENT_IN_GROUP right join TS_AGENT on TS_AGENT_IN_GROUP.TS_AGENT_ID=TS_AGENT.TS_AGENT_ID where TS_AGENT_IN_GROUP.TS_GROUP_ID=@groupId ) as groupInfo on groupInfo.TS_AGENT_ID=TS_AGENT.TS_AGENT_id ", sqlcon); /** * * * select TS_AGENT.TS_AGENT_id as agentId,TS_AGENT.TS_AGENT_NAME as agentName, case when TS_AGENT.TS_AGENT_id in (select TS_AGENT.TS_AGENT_ID from TS_AGENT_IN_GROUP left join TS_AGENT on TS_AGENT_IN_GROUP.TS_AGENT_ID=TS_AGENT.TS_AGENT_ID where TS_AGENT_IN_GROUP.TS_GROUP_ID=@groupId ) then 'true' else 'false' end as inAgentGroup, isNull(groupInfo.TS_AGENT_LEVEL,-1) as level ,isnull(groupInfo.TS_SERVERFLAG,-1) as serverFlag" + " from TS_AGENT left join ( select TS_AGENT_IN_GROUP.TS_GROUP_ID,TS_AGENT.TS_AGENT_ID,TS_AGENT_LEVEL,TS_AGENT_IN_GROUP.TS_SERVERFLAG from TS_AGENT_IN_GROUP right join TS_AGENT on TS_AGENT_IN_GROUP.TS_AGENT_ID=TS_AGENT.TS_AGENT_ID where TS_AGENT_IN_GROUP.TS_GROUP_ID=@groupId ) as groupInfo on groupInfo.TS_AGENT_ID=TS_AGENT.TS_AGENT_id + + */ sqldap.SelectCommand.Parameters.Add(new SqlParameter("groupId", groupId.Trim())); DataSet ds = new DataSet(); sqldap.Fill(ds); this.DriveDataGridView.DataSource = ds.Tables[0]; }