private void EnterButton_Click(object sender, EventArgs e)
{
_connect = new MySqlConnect();
if (!_connect.GetConfig())
{
return;
}
if (_connect.EmployeeEntry(LoginTextBox.Text, PasswordTextBox.Text))
{
UserProfile.EnterUserData(LoginTextBox.Text);
MainForm mainForm = new MainForm();
this.Hide();
mainForm.ShowDialog();
}
else
{
MessageBox.Show("Логин или пароль неверны. Попробуйте еще раз или обратитесь к директору.", "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
this.Close();
}
/// <summary>
/// 数据库参数式新增、修改、删除操作
/// </summary>
/// <param name="sqlStr">sql字符</param>
/// <returns>无</returns>
public static int insOrUpdOrDel(string sqlStr, MySqlParameter[] commandParameters)
{
//创建数据库连接
MySqlConnection conn = new MySqlConnect().getConnection(new MySqlConnect().connection());
//启动一个事务
MySqlTransaction myTrans = conn.BeginTransaction();
//事务命令
MySqlCommand cmd = conn.CreateCommand();
//事务命令
cmd.Transaction = myTrans;
int result = 0;
try
{
//执行数据库新增、修改、删除操作
result = MySqlHelper.ExecuteNonQuery(conn, sqlStr, commandParameters);
//事务提交
myTrans.Commit();
//关闭释放连接资源
conn.Close();
//
return(result);
}
catch (Exception ex)
{
//异常回滚
myTrans.Rollback();
//关闭释放连接资源
conn.Close();
//异常日志
LogHelper.WriteError("新增、修改、删除操作异常回滚：" + ex.Message);
return(0);
}
}
/// <summary>
/// 新增、修改、删除操作
/// </summary>
/// <param name="sqlStr">sql字符</param>
/// <returns>无</returns>
public static void insOrUpdOrDel(string sqlStr)
{
//创建数据库连接
MySqlConnection conn = new MySqlConnect().getConnection(new MySqlConnect().connection());
//启动一个事务
MySqlTransaction myTrans = conn.BeginTransaction();
//事务命令
MySqlCommand cmd = conn.CreateCommand();
//事务命令
cmd.Transaction = myTrans;
try
{
//执行数据库新增、修改、删除操作
MySqlHelper.ExecuteNonQuery(conn, sqlStr);
//事务提交
myTrans.Commit();
//关闭释放连接资源
conn.Close();
}
catch (Exception ex)
{
//遇到错误回滚
myTrans.Rollback();
//关闭释放连接资源
conn.Close();
//错误日志
LogHelper.WriteError("新增、修改、删除操作异常回滚：" + ex.Message);
}
}
private void tabPageUsers_Enter(object sender, EventArgs e)
{
using (MySqlConnect data = new MySqlConnect())
{
var users = data.GetOsoby(new User {
});
if (users.Count > 0)
{
radGridViewUsers.DataSource = users;
}
}
}
/// <summary>
/// 查询返回字符集
/// </summary>
/// <param name="sqlStr">sql字符</param>
/// <returns>string</returns>
public static string getResultString(string sqlStr)
{
//创建数据库连接
MySqlConnection conn = new MySqlConnect().getConnection(new MySqlConnect().connection());
//执行数据库查询操作
string result = MySqlHelper.ExecuteScalar(conn, sqlStr).ToString();
//关闭释放连接资源
conn.Close();
//返回字符集
return(result);
}
/// <summary>
/// 数据库参数式查询返回List<T>
/// </summary>
/// <typeparam name="T">泛型类</typeparam>
/// <param name="sqlStr">sql语句</param>
/// <returns>List<T></returns>
public static List <T> getResultList <T>(string sqlStr, MySqlParameter[] commandParameters)
{
//创建数据库连接
MySqlConnection conn = new MySqlConnect().getConnection(new MySqlConnect().connection());
//执行数据库查询操作
DataTable dt = MySqlHelper.ExecuteDataset(conn, sqlStr, commandParameters).Tables[0];
//关闭释放连接资源
conn.Close();
//DataTable转List对应实体类
return(dt.ToList <T>());
}
/// <summary>
/// 查询返回DataTable
/// </summary>
/// <param name="sqlStr">sql语句</param>
/// <returns>DataTable<T></returns>
public static DataTable getDataTable(string sqlStr)
{
//创建数据库连接
MySqlConnection conn = new MySqlConnect().getConnection(new MySqlConnect().connection());
//执行数据库查询操作
DataTable dt = MySqlHelper.ExecuteDataset(conn, sqlStr).Tables[0];
//关闭释放连接资源
conn.Close();
//返回DataTable
return(dt);
}
//Initialize values
public void Initialize()
{
server = "localhost";
database = "***";
uid = "****";
password = "******";
string connectionString;
connectionString = "SERVER=" + server + ";" + "DATABASE=" +
database + ";" + "UID=" + uid + ";" + "PASSWORD="******";";
connection = new MySqlConnect(server, database, uid, password);
}
/// <summary>
/// Generate a JSON file for each order
/// Filename is the Id of order
/// </summary>
public void GenerateJson()
{
using (CarsFactoryDbContext ctx = new CarsFactoryDbContext())
{
var ordersList = (from order in ctx.Orders
let date =
order.Date
let totalRevenue =
(decimal?)order.Cars.Where(
y =>
y.OrderId != null &&
y.Order.OrderStatus == OrderStatus.Closed)
.Sum(x => x.Price)
let unitsSold =
order.Cars.Count(
y =>
y.OrderId != null &&
y.Order.OrderStatus == OrderStatus.Closed)
select new
{
OrderId = order.Id,
Date = date,
UnitsSold = unitsSold,
TotalRevenue = totalRevenue,
})
.ToList();
foreach (var order in ordersList)
{
var path = "..\\..\\..\\Output\\Json-Reports";
var di = Directory.CreateDirectory(path);
using (var writer = new StreamWriter("..\\..\\..\\Output\\Json-Reports\\" + order.OrderId + ".json"))
{
writer.Write(JsonConvert.SerializeObject(order, Formatting.Indented));
}
MySqlConnect dbConn = new MySqlConnect();
dbConn.Insert(JsonConvert.SerializeObject(order, Formatting.Indented));
}
}
}
public DataRequest Get()
{
var request = MySqlConnect.Connect();
return(request);
}
public UserDAO()
{
conn = new MySqlConnect();
}
public CategoryMySql()
{
_connect = new MySqlConnect();
}
public EmployeeMySql()
{
_connect = new MySqlConnect();
}
public JobsDAO()
{
conn = new MySqlConnect();
}
