public cls_Response fetch_all_blogs(string uid)
{
try
{
MysqlHelper DAL = new MysqlHelper();
string query = "sp_fetch_all_blogs";
List <MySqlParameter> Prm = new List <MySqlParameter>();
Prm.Add(new MySqlParameter()
{
ParameterName = "_uid", Value = uid
});
DataTable dt = new DataTable();
dt = DAL.GetDataTable(query, CommandType.StoredProcedure, Prm);
response.status = response.Success;
response.data = JsonConvert.SerializeObject(dt);
}
catch (Exception ex)
{
response.status = response.Exception;
response.data = ex.Message;
throw ex;
}
return(response);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="sql"></param>
public bool Add(CarRepairRecord model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("CarID", model.CarID));
parameters.Add(new QfParameter("RepairID", model.RepairID));
parameters.Add(new QfParameter("RepairPlace", string.Format(@"'{0}'", model.RepairPlace)));
parameters.Add(new QfParameter("RepairDate", string.Format(@"'{0}'", model.RepairDate)));
parameters.Add(new QfParameter("ItemStr", string.Format(@"'{0}'", model.ItemStr)));
parameters.Add(new QfParameter("RepairKil", model.RepairKil));
parameters.Add(new QfParameter("Result", string.Format(@"'{0}'", model.Result)));
parameters.Add(new QfParameter("PartsCost", model.PartsCost));
parameters.Add(new QfParameter("CreatID", model.CreatID));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperateID", model.OperateID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName));
string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value));
string sql = string.Format("insert into t_car_repair_record({0}) values ({1})", colStr, atColStr);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
private void synchronousAdd(List <InfoListModel> lists)
{
List <InfoListModel> newlist = lists.Where(u => u.versions == 0).ToList();
string str = JsonConvert.SerializeObject(newlist);
List <InfoListModel> lists1 = JsonConvert.DeserializeObject <List <InfoListModel> >(str);
int count = lists1.Count();
int page = count / 1000 + 1;
ResultJson <string> resultJson = new ResultJson <string>()
{
code = "20000"
};
for (int i = 1; i <= page; i++)
{
List <InfoListModel> data = lists1.Skip((i - 1) * 1000).Take(1000).ToList();
//resultJson = InfoListService.addNucleic(data);
Task <int> task = MysqlHelper.InsertAsync(data);
Console.WriteLine("新增:" + task.Result + "条数据");
}
if (resultJson.code == "20000")
{
foreach (var item in lists.Where(u => u.versions == 0).ToList())
{
item.versions = 1;
}
SettingJsonConfig.saveData(lists);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="sql"></param>
public bool Update(Duty model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("DutyID", model.DutyID));
parameters.Add(new QfParameter("DutyCode", string.Format(@"'{0}'", model.DutyCode)));
parameters.Add(new QfParameter("DutyName", string.Format(@"'{0}'", model.DutyName)));
parameters.Add(new QfParameter("MnemonicCode", string.Format(@"'{0}'", model.MnemonicCode)));
parameters.Add(new QfParameter("Array", model.Array));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperateID", model.OperateID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
string setStr = "";
foreach (var item in parameters)
{
if (item.Value != null && ValueConvert.ToString(item.Value) != "''")
{
setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value);
}
}
setStr = setStr.Substring(0, setStr.LastIndexOf(","));
string sql = string.Format("update t_duty set {0} where DutyID = {1}", setStr, model.DutyID);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="sql"></param>
public bool Add(Duty model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("DutyID", model.DutyID));
parameters.Add(new QfParameter("DutyCode", string.Format(@"'{0}'", model.DutyCode)));
parameters.Add(new QfParameter("DutyName", string.Format(@"'{0}'", model.DutyName)));
parameters.Add(new QfParameter("MnemonicCode", string.Format(@"'{0}'", model.MnemonicCode)));
parameters.Add(new QfParameter("Array", model.Array));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperateID", model.OperateID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName));
string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value));
string sql = string.Format("insert into t_duty({0}) values ({1})", colStr, atColStr);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="sql"></param>
public bool Update(Department model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("DepartmentID", model.DepartmentID));
parameters.Add(new QfParameter("DepartmentCode", string.Format(@"'{0}'", model.DepartmentCode)));
parameters.Add(new QfParameter("DepartmentName", string.Format(@"'{0}'", model.DepartmentName)));
parameters.Add(new QfParameter("ParentID", model.ParentID));
parameters.Add(new QfParameter("InChargeID", model.InChargeID));
parameters.Add(new QfParameter("EmployeeCount", model.EmployeeCount));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperateID", model.OperateID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
string setStr = "";
foreach (var item in parameters)
{
if (item.Value != null && ValueConvert.ToString(item.Value) != "''")
{
setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value);
}
}
setStr = setStr.Substring(0, setStr.LastIndexOf(","));
string sql = string.Format("update t_department set {0} where DepartmentID = {1}", setStr, model.DepartmentID);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="sql"></param>
public bool Add(Department model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("DepartmentID", model.DepartmentID));
parameters.Add(new QfParameter("DepartmentCode", string.Format(@"'{0}'", model.DepartmentCode)));
parameters.Add(new QfParameter("DepartmentName", string.Format(@"'{0}'", model.DepartmentName)));
parameters.Add(new QfParameter("ParentID", model.ParentID));
parameters.Add(new QfParameter("InChargeID", model.InChargeID));
parameters.Add(new QfParameter("EmployeeCount", model.EmployeeCount));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperateID", model.OperateID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName));
string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value));
string sql = string.Format("insert into t_department({0}) values ({1})", colStr, atColStr);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
/// <summary>
/// 修改卡类信息
/// </summary>
/// <param name="model">卡类实体</param>
/// <returns></returns>
public bool EditDataBase(CarTypeModel model)
{
MysqlHelper dbhelper = new MysqlHelper("name=parklotManager", "MySql.Data.MySqlClient");
string commandtext = @"update t_cartype set carTypeName = @carTypeName , carType = @carType , idx = @idx where guid = @guid";
DbParameter carTypeName = dbhelper.factory.CreateParameter();
carTypeName.ParameterName = "@carTypeName";
carTypeName.Value = model.CarTypeName;
DbParameter carType = dbhelper.factory.CreateParameter();
carType.ParameterName = "@carType";
carType.Value = model.CarType;
DbParameter idx = dbhelper.factory.CreateParameter();
idx.ParameterName = "@idx";
idx.Value = model.Idx;
DbParameter guid = dbhelper.factory.CreateParameter();
guid.ParameterName = "@guid";
guid.Value = model.Guid;
DbParameter[] parameter = new DbParameter[] { carTypeName, carType, idx, guid };
return(dbhelper.ExecuteNonQuery(commandtext, parameter) > 0 ? true : false);
}
static void Main(string[] args)
{
MysqlHelper _mysqlHelper = null;
// Filter: .doc and vaild file path
if (null == _mysqlHelper)
{
_mysqlHelper = new MysqlHelper("Database='" + _database + "';" +
"Data Source='" + _dataSource + "';" +
"User Id='" + _userId + "';" +
"Password='******';" +
"charset='" + _charset + "';" +
"pooling=" + _pooling + "");
if (null == _mysqlHelper.Conn)
{
Trace.WriteLine("Error: can not connect to mysql database.");
return;
}
}
string sqlFiles = "select id, value from data2d";
DataTable dataTable = _mysqlHelper.ExecuteDataTable(sqlFiles, null);
double[] array = new double[_number];
int i = 0;
foreach (DataRow row in dataTable.Rows)
{
array[i++] = (double)row[1];
}
// return array;
}
public async Task <DataResult <int> > GroupUserDeleteAsync(QueryData <SysGroupUserDeleteQuery> query)
{
var result = new DataResult <int>();
string sqld = @"delete from sys_groupuser where GroupNo=@GroupNo and UserNo=@UserNo";
string sqlc = @"select Id from sys_groupuser where GroupNo=@GroupNo and UserNo=@UserNo";
using (IDbConnection dbConn = MysqlHelper.OpenMysqlConnection(ConfigOptions.MysqlOptConn))
{
try
{
result.Data = await MysqlHelper.QueryCountAsync(dbConn, sqlc, query.Criteria);
if (result.Data <= 0)
{
result.SetErr("用户不存在或已被删除，请重试！", -101);
return(result);
}
result.Data = await MysqlHelper.ExecuteSqlAsync(dbConn, sqld, query.Criteria);
if (result.Data <= 0)
{
result.SetErr("删除失败！", -101);
return(result);
}
}
catch (Exception ex)
{
result.SetErr(ex, -500);
result.Data = -1;
}
}
return(result);
}
public bool SaveToDataBase(GatherAccountModel model)
{
MysqlHelper dbhelper = new MysqlHelper("name=parklotManager", "MySql.Data.MySqlClient");
string commandtext = @"replace into t_gatheraccount(projectGuid,guid,accountName,aliEntityContent,wxEntityContent)
values(@projectGuid,@guid,@accountName,@aliEntityContent,@wxEntityContent)";
DbParameter projectGuid = dbhelper.factory.CreateParameter();
projectGuid.ParameterName = "@projectGuid";
projectGuid.Value = model.ProjectGuid;
DbParameter guid = dbhelper.factory.CreateParameter();
guid.ParameterName = "@guid";
guid.Value = model.Guid;
DbParameter accountName = dbhelper.factory.CreateParameter();
accountName.ParameterName = "@accountName";
accountName.Value = m_serializer.Serialize(model);
DbParameter aliEntityContent = dbhelper.factory.CreateParameter();
aliEntityContent.ParameterName = "@aliEntityContent";
aliEntityContent.Value = m_serializer.Serialize(model.AlipayAccount ?? new AliPayAccountModel());
DbParameter wxEntityContent = dbhelper.factory.CreateParameter();
wxEntityContent.ParameterName = "@wxEntityContent";
wxEntityContent.Value = m_serializer.Serialize(model.WechatAccount ?? new WeChatAccountModel());
DbParameter[] parameter = new DbParameter[] { projectGuid, guid, accountName, aliEntityContent, wxEntityContent };
return(dbhelper.ExecuteNonQuery(commandtext, parameter) > 0 ? true : false);
}
public void CreateNewPlayer()
{
string sql = "select * from shortcut_information where user_id=" + GameConfig.UserId;
DataTable dt = MysqlHelper.ExecuteTable(sql, CommandType.Text, null);
if (dt.Rows.Count > 0)
{
sql = "update shortcut_information set skill_id=@skill_id where user_id=" + GameConfig.UserId + " and shortcut_id=";
MySqlParameter ps = new MySqlParameter("@skill_id", DBNull.Value);
string sql_next;
for (int i = 0; i < 6; i++)
{
sql_next = sql + i;
MysqlHelper.ExecutNonQuery(sql_next, CommandType.Text, ps);
}
}
else
{
sql = "insert into shortcut_information values(@user_id,@shortcut_id,@skill_id)";
MySqlParameter[] ps =
{
new MySqlParameter("@user_id", GameConfig.UserId),
new MySqlParameter("@shortcut_id", 0),
new MySqlParameter("@skill_id", DBNull.Value),
};
for (int i = 0; i < 6; i++)
{
ps[1].Value = i;
MysqlHelper.ExecutNonQuery(sql, CommandType.Text, ps);
}
}
}
public List <ShortCutInfo> LoadShortCutInfo()
{
List <ShortCutInfo> shortCutInfos = new List <ShortCutInfo>();
string sql = "select * from shortcut_information where user_id=" + GameConfig.UserId + " order by shortcut_id";
DataTable dt = MysqlHelper.ExecuteTable(sql, CommandType.Text, null);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ShortCutInfo shortCutInfo = new ShortCutInfo();
shortCutInfo.ShortCutID = int.Parse(dr["shortcut_id"].ToString());
if (dr["skill_id"] == DBNull.Value)
{
shortCutInfo.SkillID = -1;
}
else
{
shortCutInfo.SkillID = int.Parse(dr["skill_id"].ToString());
}
shortCutInfos.Add(shortCutInfo);
}
}
return(shortCutInfos);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="sql"></param>
public bool Add(CarDispatchApply model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("ApplyID", model.ApplyID));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperatorID", model.OperatorID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
parameters.Add(new QfParameter("ApplyMode", string.Format(@"'{0}'", model.ApplyMode)));
parameters.Add(new QfParameter("IsDriver", model.IsDriver));
parameters.Add(new QfParameter("CarModel", string.Format(@"'{0}'", model.CarModel)));
parameters.Add(new QfParameter("DriverName", string.Format(@"'{0}'", model.DriverName)));
parameters.Add(new QfParameter("DriverLicense", string.Format(@"'{0}'", model.DriverLicense)));
parameters.Add(new QfParameter("DispatchID", model.DispatchID));
parameters.Add(new QfParameter("EmployeeID", model.EmployeeID));
parameters.Add(new QfParameter("ApplyDate", string.Format(@"'{0}'", model.ApplyDate)));
parameters.Add(new QfParameter("CarID", model.CarID));
parameters.Add(new QfParameter("DispatchReason", string.Format(@"'{0}'", model.DispatchReason)));
parameters.Add(new QfParameter("PlaceBackDate", string.Format(@"'{0}'", model.PlaceBackDate)));
parameters.Add(new QfParameter("CarBackDate", string.Format(@"'{0}'", model.CarBackDate)));
parameters.Add(new QfParameter("Status", model.Status));
string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName));
string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value));
string sql = string.Format("insert into t_car_dispatch_apply({0}) values ({1})", colStr, atColStr);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
public DataTable GetUserInfo(string userName)
{
string sql = "select * from user_information where user_name=@user_name";
MySqlParameter ps = new MySqlParameter("@user_name", userName);
return(MysqlHelper.ExecuteTable(sql, CommandType.Text, ps));
}
//public cls_Response verify(string decryptedCookie)
//{
// try
// {
// }
// catch (Exception ex)
// {
// }
//}
public cls_Response update_blog(string brief, string content, string uid)
{
try
{
MysqlHelper DAL = new MysqlHelper();
string query = "sp_add_blog";
List <MySqlParameter> Prm = new List <MySqlParameter>();
Prm.Add(new MySqlParameter()
{
ParameterName = "_brief", Value = brief
});
Prm.Add(new MySqlParameter()
{
ParameterName = "_content", Value = content
});
Prm.Add(new MySqlParameter()
{
ParameterName = "_uid", Value = uid
});
DAL.ExecuteNonQuery(query, CommandType.StoredProcedure, Prm);
response.status = response.Success;
response.data = "Blog updated sucessfully";
}
catch (Exception ex)
{
response.status = response.Exception;
response.data = ex.Message;
throw ex;
}
return(response);
}
public void Delete(string Session)
{
Session = Session.Replace("'", "");
string sql = "delete from checkins where Session = '" + Session + "'";
MysqlHelper.Exec(_ConnectionStr, sql);
}
public List <ContactInfo> getByStatus(String status)
{
List <ContactInfo> results = new List <ContactInfo>();
MySqlDataReader dr = MysqlHelper.query(string.Format(ContactInfoService.GetByStatusSql, status));
return(parseEntities(dr));
}
public IEnumerable <Checks> Get(string TeacherSession)
{
TeacherSession = TeacherSession.Replace("'", "");
DataSet ds = null;
if (string.IsNullOrEmpty(TeacherSession))
{
ds = MysqlHelper.Query(_ConnectionStr, "select * from checkins order by ID desc;");
}
else
{
ds = MysqlHelper.Query(_ConnectionStr, "select * from checkins where TeacherSession = '"
+ TeacherSession + "' order by ID desc;");
}
Checks[] ts = new Checks[ds.Tables[0].Rows.Count];
int idx = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ts[idx] = new Checks();
ts[idx].ID = idx;// (int)dr["ID"];
ts[idx].ClassRoom = (string)dr["ClassRoom"];
ts[idx].Session = (string)dr["Session"];
ts[idx].TeacherSession = (string)dr["TeacherSession"];
ts[idx].Description = (string)dr["Description"];
idx++;
}
return(ts);
}
public Checks Get(string Session, string ClassRoom, string TeacherSession, string Description)
{
Session = Session.Replace("'", "");
ClassRoom = ClassRoom.Replace("'", "");
TeacherSession = TeacherSession.Replace("'", "");
Description = Description.Replace("'", "");
Checks s = new Checks();
string sql = "SELECT a.*,b.Name from checkins a INNER JOIN teachers b ON a.TeacherSession = b.`Session` where a.session = '" + Session + "'";
DataSet ds = MysqlHelper.Query(_ConnectionStr, sql);
if (ds.Tables[0].Rows.Count <= 0)
{
sql = "insert into checkins (Session,ClassRoom,TeacherSession,Description) values "
+ "('" + Session + "','" + ClassRoom + "','" + TeacherSession + "','" + Description + "')";
MysqlHelper.Exec(_ConnectionStr, sql);
sql = "SELECT a.*,b.Name from checkins a INNER JOIN teachers b ON a.TeacherSession = b.`Session` where a.session = '" + Session + "'";
ds = MysqlHelper.Query(_ConnectionStr, sql);
}
//if (s.ClassRoom != ClassRoom || s.TeacherSession != TeacherSession || s.Description != Description)
//{
// sql = "update checkins set ClassRoom = '"
// + ClassRoom + "' ,TeacherSession = '" + TeacherSession
// + "',Description='" + Description
// + "' where Session = '" + Session + "'";
// MysqlHelper.Exec(_ConnectionStr, sql);
//}
s.Session = (string)ds.Tables[0].Rows[0]["Session"];
s.ClassRoom = (string)ds.Tables[0].Rows[0]["ClassRoom"];
s.TeacherSession = (string)ds.Tables[0].Rows[0]["TeacherSession"];
s.Description = (string)ds.Tables[0].Rows[0]["Description"];
s.Name = (string)ds.Tables[0].Rows[0]["Name"];
return(s);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="sql"></param>
public bool Add(CarOutRegistration model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("RegistraID", model.RegistraID));
parameters.Add(new QfParameter("DispatchID", model.DispatchID));
parameters.Add(new QfParameter("CarID", model.CarID));
parameters.Add(new QfParameter("RegistraDate", string.Format(@"'{0}'", model.RegistraDate)));
parameters.Add(new QfParameter("EmployeeID", model.EmployeeID));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperatorID", model.OperatorID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName));
string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value));
string sql = string.Format("insert into t_car_out_registration({0}) values ({1})", colStr, atColStr);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
public Teacher Get(string Session, string Name, string Phone, string Description)
{
Session = Session.Replace("'", "");
Name = Name.Replace("'", "");
Phone = Phone.Replace("'", "");
Description = Description.Replace("'", "");
Teacher s = new Teacher();
string sql = "select * from teachers where session = '" + Session + "'";
DataSet ds = MysqlHelper.Query(_ConnectionStr, sql);
if (ds.Tables[0].Rows.Count <= 0)
{
sql = "insert into teachers (Session,Name,Phone,Description) values "
+ "('" + Session + "','" + Name + "','" + Phone + "','" + Description + "')";
MysqlHelper.Exec(_ConnectionStr, sql);
}
if (s.Name != Name || s.Phone != Phone || s.Description != Description)
{
sql = "update teachers set Name = '"
+ Name + "' ,Phone = '" + Phone
+ "',Description='" + Description
+ "' where Session = '" + Session + "'";
MysqlHelper.Exec(_ConnectionStr, sql);
}
s.Session = Session;
s.Name = Name;
s.Phone = Phone;
s.Description = Description;
return(s);
}
/// <summary>
/// 初始化函数,加载文件路径
/// </summary>
public void Init()
{
PlayerStatusManager.Instance.LvUP += StartUpdateUI;
List <BaseSkill> SkillInfoList = new List <BaseSkill>();
SkillItemList = new List <SkillListItem>();
string sql = "select * from skill_information";
DataTable dt = MysqlHelper.ExecuteTable(sql, CommandType.Text, null);
foreach (DataRow item in dt.Rows)
{
Type type = Type.GetType(item["skill_type"].ToString());
object[] parameters = new object[1];
parameters[0] = item;
object obj = Activator.CreateInstance(type, parameters);
BaseSkill bs = obj as BaseSkill;
SkillInfoList.Add(bs);
}
for (int i = 0; i < SkillInfoList.Count; i++)
{
if (SkillInfoList[i].PlayerType == PlayerStatusManager.Instance.playerInfo.PlayerType)
{
SkillListItem si = (SkillListItem)UIPackage.CreateObject("SkillMenu", "SkillListItem");
si.SkillInfo = SkillInfoList[i];
si.SetValues();
SkillItemList.Add(si);
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="sql"></param>
public bool Update(CarOutRegistration model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("RegistraID", model.RegistraID));
parameters.Add(new QfParameter("DispatchID", model.DispatchID));
parameters.Add(new QfParameter("CarID", model.CarID));
parameters.Add(new QfParameter("RegistraDate", string.Format(@"'{0}'", model.RegistraDate)));
parameters.Add(new QfParameter("EmployeeID", model.EmployeeID));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperatorID", model.OperatorID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
string setStr = "";
foreach (var item in parameters)
{
if (item.Value != null && ValueConvert.ToString(item.Value) != "''")
{
setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value);
}
}
setStr = setStr.Substring(0, setStr.LastIndexOf(","));
string sql = string.Format("update t_car_out_registration set {0} where RegistraID = {1}", setStr, model.RegistraID);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="sql"></param>
public bool Update(CarApplySocialpeople model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("SocialPeopleID", model.SocialPeopleID));
parameters.Add(new QfParameter("ApplyID", model.ApplyID));
parameters.Add(new QfParameter("Name", string.Format(@"'{0}'", model.Name)));
parameters.Add(new QfParameter("IdentityNo", string.Format(@"'{0}'", model.IdentityNo)));
parameters.Add(new QfParameter("DriverLicense", string.Format(@"'{0}'", model.DriverLicense)));
parameters.Add(new QfParameter("DriverLicenseType", string.Format(@"'{0}'", model.DriverLicenseType)));
parameters.Add(new QfParameter("FileNumber", string.Format(@"'{0}'", model.FileNumber)));
string setStr = "";
foreach (var item in parameters)
{
if (item.Value != null && ValueConvert.ToString(item.Value) != "''")
{
setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value);
}
}
setStr = setStr.Substring(0, setStr.LastIndexOf(","));
string sql = string.Format("update t_car_apply_socialpeople set {0} where SocialPeopleID = {1}", setStr, model.SocialPeopleID);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
public string GetGuidByKey(string key)
{
MysqlHelper dbhelper = new MysqlHelper("name=parklotManager", "MySql.Data.MySqlClient");
object guid = dbhelper.ExecuteScalar(string.Format("select guid from t_driveway where deviceMacAddress='{0}'", key));
return(guid == null ? "" : guid.ToString());
}
public List <DiscussGroupLink> getByKey(string key)
{
List <DiscussGroupLink> results = new List <DiscussGroupLink>();
MySqlDataReader dr = MysqlHelper.query(string.Format(DiscussGroupLinkService.GetByKeySql, key));
return(parseEntities(dr));
}
private T FirstOrDefault(MysqlVisitor <T> visitor)
{
IEnumerable <Parameter> parameters;
var sql = BuildQuerySQL(visitor, out parameters);
string orderBy = "Id ASC";
if (visitor.OrderClauses != null && visitor.OrderClauses.Count > 0)
{
orderBy = ToOrderString(visitor);
}
sql = string.Format("SELECT * FROM ({0})T ORDER BY {1} limit {2},1", sql, orderBy, visitor.Skip);
var command = BuildCommand(sql, parameters);
T content = default(T);
MySqlConnection connection;
using (var dataReader = MysqlHelper.ExecuteReader(ContentQuery.Repository, command, out connection))
{
if (dataReader.Read())
{
content = new T();
dataReader.ToContent(content);
}
dataReader.Close();
connection.Close();
}
return(content);
}
/// <summary>
/// 获取所有读者信息
/// </summary>
/// <returns></returns>
public List <Reader> GetReaderInfo()
{
List <Reader> readers = new List <Reader>();
MySqlDataReader mdr = null;
MySqlConnection con = MysqlHelper.Connection();
MysqlHelper mh = new MysqlHelper();
mh.OpenConnection();
MySqlCommand msc = new MySqlCommand("select * from reader", con);
mdr = msc.ExecuteReader(CommandBehavior.CloseConnection);
while (mdr.Read())
{
int r_id = mdr.GetInt16("r_id");
String r_name = mdr.GetString("r_name");
String r_sex = mdr.GetString("r_sex");
String r_no = mdr.GetString("r_no");
String r_pno = mdr.GetString("r_pno");
String r_pic = mdr.GetString("r_pic");
Reader reader = new Reader(r_id, r_name, r_sex, r_no, r_pno, r_pic);
readers.Add(reader);
}
mh.CloseConnection();
return(readers);
}
public void SaveLoadBagInfo(List <SlotInfo> slotInfos)
{
string sql = "update bag_item_information set item_id=@item_id,slot_item_count=@slot_item_count where user_id=" + GameConfig.UserId + " and slot_id=";
string sql_next;
MySqlParameter[] ps =
{
new MySqlParameter("@item_id", 0),
new MySqlParameter("@slot_item_count", 0)
};
for (int i = 0; i < 25; i++)
{
if (slotInfos[i].ItemID == -1)
{
ps[0].Value = DBNull.Value;
}
else
{
ps[0].Value = slotInfos[i].ItemID;
}
ps[1].Value = slotInfos[i].ItemCount;
sql_next = sql + i;
MysqlHelper.ExecutNonQuery(sql_next, CommandType.Text, ps);
}
}
public List <SlotInfo> LoadBagInfo()
{
List <SlotInfo> slotInfos = new List <SlotInfo>();
string sql = "select * from bag_item_information where user_id=" + GameConfig.UserId;
DataTable dt = MysqlHelper.ExecuteTable(sql, CommandType.Text, null);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SlotInfo slotInfo = new SlotInfo();
slotInfo.SlotID = int.Parse(dr["slot_id"].ToString());
slotInfo.ItemCount = int.Parse(dr["slot_item_count"].ToString());
if (dr["item_id"] == DBNull.Value)
{
slotInfo.ItemID = -1;
}
else
{
slotInfo.ItemID = int.Parse(dr["item_id"].ToString());
}
slotInfos.Add(slotInfo);
}
}
slotInfos.Sort(delegate(SlotInfo x, SlotInfo y)
{
return(x.SlotID.CompareTo(y.SlotID));
});
return(slotInfos);
}
internal void HandleJson()
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Multiselect = true;
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
List<string> handle = new List<string>();
// MysqlHelper mysqlhelper = new MysqlHelper();
foreach (string file in openFileDialog1.FileNames)
{
List<Question> question_list = new List<Question>();
try
{
Console.WriteLine(file);
//System.IO.DirectoryInfo di = new System.IO.DirectoryInfo(file);
string text = System.IO.File.ReadAllText(file);
JObject jobject = (JObject)JsonConvert.DeserializeObject(text);
JArray resultArray = (JArray)JsonConvert.DeserializeObject(jobject["list"].ToString());
var course = JsonConvert.DeserializeObject(jobject["courseSectionID"].ToString());
var pre_list = JsonConvert.DeserializeObject<List<Question>>(resultArray.ToString());
question_list.AddRange(pre_list);
MysqlHelper mysqlhelper = new MysqlHelper();
foreach (Question question in question_list)
{
question.content = Exp(question.content);
question.answerExplain = Exp(question.answerExplain);
string sql = string.Format("insert into question set questionID='{0}',questionNo='{1}',content='{2}',questionType='{3}',rightAnswer='{4}',answerExplain='{5}',difficulty='{6}',rightRate='{7}',isCollect='{8}',isOut='{9}',hot='{10}',courseSectionID='{11}'", question.questionID, question.questionNo, question.content, question.questionType, question.rightAnswer, question.answerExplain, question.difficulty, question.rightRate, question.isCollect, question.isOut, question.hot, course);
mysqlhelper.Insert(sql);
}
}
catch (Exception t)
{
Console.WriteLine(t.Message);
}
Console.WriteLine("Finish " + file);
}
}
//MysqlHelper mysqlhelper = new MysqlHelper();
//foreach (Question question in question_list)
//{
// question.content = Exp(question.content);
// question.answerExplain = Exp(question.answerExplain);
// string sql = string.Format("insert into question set questionID='{0}',questionNo='{1}',content='{2}',questionType='{3}',rightAnswer='{4}',answerExplain='{5}',difficulty='{6}',rightRate='{7}',isCollect='{8}',isOut='{9}',hot='{10}'", question.questionID, question.questionNo, question.content, question.questionType, question.rightAnswer, question.answerExplain, question.difficulty, question.rightRate, question.isCollect, question.isOut, question.hot);
// // mysqlhelper.Insert(sql);
//}
}
internal void Start()
{
MysqlHelper mysqlhelper = new MysqlHelper();
string area_string = Properties.Settings.Default.Area;
MatchCollection matches = Regex.Matches(area_string,"value=\"(.*?)\".*?>(.*?)</option>",RegexOptions.Singleline);
foreach (Match mac in matches)
{
if (mac.Groups[1].Length < 2)
continue;
else
{
string value = mac.Groups[1].ToString().Trim();
string area = mac.Groups[2].ToString().Trim();
MysqlHelper.Insert(value, area);
}
}
}
