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