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