/// <summary>
/// 根据主键查询
/// </summary>
/// <param name="primaryKey"></param>
/// <returns></returns>
public DialogueSettingBO Get(string primaryKey)
{
string sql = "SELECT client,username,password,database_id,workspace_id,emailtype_id,email_id,ftp_account_id,prefix,sms_account,sms_password,sms_pid FROM t_dialoguesetting where APIKey=@APIKey";
using (MySqlConnection mycn = new MySqlConnection(mysqlConnection))
{
mycn.Open();
MySqlCommand command = new MySqlCommand(sql, mycn);
command.Parameters.AddWithValue("@APIKey", primaryKey);
MySqlDataReader reader = command.ExecuteReader();
DialogueSettingBO DB_DialogueSetting = null;
if (reader.Read())
{
DB_DialogueSetting = new DialogueSettingBO();
DB_DialogueSetting.client = reader["client"] == DBNull.Value ? "" : reader["client"].ToString();
DB_DialogueSetting.username = reader["username"] == DBNull.Value ? "" : reader["username"].ToString();
DB_DialogueSetting.password = reader["password"] == DBNull.Value ? "" : reader["password"].ToString();
DB_DialogueSetting.contactDatabaseId = reader["database_id"] == DBNull.Value ? "" : reader["database_id"].ToString();
DB_DialogueSetting.workspaceId = reader["workspace_id"] == DBNull.Value ? "" : reader["workspace_id"].ToString();
DB_DialogueSetting.emailTypeId = reader["emailtype_id"] == DBNull.Value ? "" : reader["emailtype_id"].ToString();
DB_DialogueSetting.directEmailId = reader["email_id"] == DBNull.Value ? "" : reader["email_id"].ToString();
DB_DialogueSetting.ftpAccountId = reader["ftp_account_id"] == DBNull.Value ? "" : reader["ftp_account_id"].ToString();
DB_DialogueSetting.sms_account = reader["sms_account"] == DBNull.Value ? "" : reader["sms_account"].ToString();
DB_DialogueSetting.sms_password = reader["sms_password"] == DBNull.Value ? "" : reader["sms_password"].ToString();
DB_DialogueSetting.sms_pid = reader["sms_pid"] == DBNull.Value ? "" : reader["sms_pid"].ToString();
DB_DialogueSetting.prefix = reader["prefix"] == DBNull.Value ? "" : reader["prefix"].ToString();
}
return DB_DialogueSetting;
}
}
/// <summary>
/// 添加数据
/// </summary>
/// <returns></returns>
public int Add(DialogueSettingBO entity)
{
string sql = "INSERT INTO cimuser (userid,userNickName) VALUE (@userid,@userNickName)";
using (MySqlConnection mycn = new MySqlConnection(mysqlConnection))
{
mycn.Open();
MySqlCommand command = new MySqlCommand(sql, mycn);
command.Parameters.AddWithValue("@userid", entity.client);
command.Parameters.AddWithValue("@userNickName", entity.username);
return command.ExecuteNonQuery();
}
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Update(DialogueSettingBO entity)
{
string sql = "UPDATE cimuser SET userNickName=@userNickName WHERE userid=@userid";
using (MySqlConnection mycn = new MySqlConnection(mysqlConnection))
{
mycn.Open();
MySqlCommand command = new MySqlCommand(sql, mycn);
// command.Parameters.AddWithValue("@userid", entity.UserId);
// command.Parameters.AddWithValue("@userNickName", entity.UserNickName);
return command.ExecuteNonQuery();
}
}
/// <summary>
/// 查询集合
/// </summary>
/// <returns></returns>
public IList<DialogueSettingBO> GetList()
{
string sql = "SELECT userid,userNickName FROM cimuser limit 1,10";
using (MySqlConnection mycn = new MySqlConnection(mysqlConnection))
{
mycn.Open();
MySqlCommand command = new MySqlCommand(sql, mycn);
MySqlDataReader reader = command.ExecuteReader();
IList<DialogueSettingBO> list = new List<DialogueSettingBO>();
DialogueSettingBO DB_DialogueSetting = null;
while (reader.Read())
{
DB_DialogueSetting = new DialogueSettingBO();
// DB_DialogueSetting.UserId = Convert.ToInt32(reader["userid"]);
// DB_DialogueSetting.UserNickName = reader["userNickName"] == DBNull.Value ? null : reader["userNickName"].ToString();
list.Add(DB_DialogueSetting);
}
return list;
}
}
