public void InitConfig() { try { XElement xmlFile = ConfigHelper.Load("config.xml"); Consts.HuanYingSiYuanRoleCountTotal = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "HuanYingSiYuanRoleCountTotal", "value", 16L); Consts.HuanYingSiYuanRoleCountPerSide = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "HuanYingSiYuanRoleCountPerSide", "value", 8L); this.SignUpWaitSecs1 = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "SignUpWaitSecs1", "value", 30L); this.SignUpWaitSecs2 = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "SignUpWaitSecs2", "value", 60L); if (this.CurrGameId == Global.UninitGameId) { this.CurrGameId = (int)((long)DbHelperMySQL.GetSingle("SELECT IFNULL(MAX(id),0) FROM t_hysy_0;")); } this.Initialized = true; } catch (Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); } }
/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount_DepartmentCharge(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM view_chart_DepartmentCharge "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = DbHelperMySQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 判断改数据是否存在,存在则不再保存 /// </summary> /// <param name="info">相关信息</param> /// <returns>是否存在</returns> protected bool JudegeInfoExist(BusinessInfo info) { string SQL_GetInfo = "Select * From business where business.Source=?Source and business.BusinessTitle=?BusinessTitle"; MySqlParameter[] getinfoParameters = new MySqlParameter[] { new MySqlParameter("Source", MySqlDbType.VarChar, 50), new MySqlParameter("BusinessTitle", MySqlDbType.VarChar, 200) }; getinfoParameters[0].Value = info.Source; getinfoParameters[1].Value = info.Title; object infoobj = DbHelperMySQL.GetSingle(SQL_GetInfo, getinfoParameters); if (infoobj != null) //如果已经有了该数据 { return(true); } return(false); }
/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM ims_check_task_standard "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = DbHelperMySQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取记录总数 /// </summary> public int GetListCount(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM bus_dish "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = DbHelperMySQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount_Registration(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM View_messages_registration "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = DbHelperMySQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM t_ind_twittercredential "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = DbHelperMySQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 检测是否本月是否可以举行活动,是为了考虑到该版本的更新问题 /// 例如活动每月10号开启,但是这个版本是15号更新上去的,那么虽然有天数推迟功能,那么这个活动举行么? /// 策划的答复: 1-9号, 以及10号15:30分之前的版本更新 会正常开启众神争霸 /// </summary> /// <param name="now"></param> /// <param name="dayBeginTicks"></param> /// <returns></returns> private bool CheckThisMonthInActivity(DateTime now, long dayBeginTicks) { try { // 这个字段记录当前存储的争霸信息是哪个月的,默认插入201111(2011年11月) DbHelperMySQL.ExecuteSql( string.Format("INSERT IGNORE INTO t_async(`id`,`value`) VALUES({0},{1});", AsyncTypes.ZhengBaCurrMonth, ZhengBaConsts.DefaultAsyncMonth) ); // 取出来记录的月份 int oldMonth = (int)DbHelperMySQL.GetSingle("select value from t_async where id = " + AsyncTypes.ZhengBaCurrMonth); if (oldMonth == ZhengBaConsts.DefaultAsyncMonth) { // 如果当前记录的月份是默认值201111,那么说明还没有举行过一次众神争霸,有可能是第一次升级该版本,所以检测本月是否能够开启活动 if (now.Day > ZhengBaConsts.StartMonthDay) { return(false); // 第一次启动是在10号之后, 那么本月不举行 } else if (now.Day < ZhengBaConsts.StartMonthDay) { return(true); // 第一次启动是在10号之前, 那么本月举行 } else { return(now.TimeOfDay.Ticks < dayBeginTicks); // 第一次启动是10号,那么检测当前时间是否在15:30之前 } } else { // 不是默认值,说明已经举行过了 return(true); } } catch (Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); return(false); } }
private bool HaveRepeat(string barcode) { bool flag = false; string s = DateTime.Now.ToString("yyyy-MM-dd"); string sql = string.Format("select count(ID) from zkhw_tj_jk where bar_code='{0}' and createtime>='{1}'", barcode, s); object obj = DbHelperMySQL.GetSingle(sql); if (obj != null) { string tmp = obj.ToString(); if (tmp == "") { tmp = "0"; } if (int.Parse(tmp) > 0) { flag = true; } } return(flag); }
protected void BindGrid() { string sql = "SELECT tabie.TabieName," + "sum(Population) as Population," + "sum(Moneys) as Moneys," + "COUNT(tui.TabieID) as usecount " + "FROM tm_tabieusinginfo tui " + "LEFT JOIN tm_tabie tabie on(tui.TabieID=tabie.ID) " + GetSqlWhere() + " GROUP BY tui.TabieID " + "ORDER BY usecount DESC"; DataSet ds = DbHelperMySQL.Query(sql + " limit " + Grid1.PageIndex * Grid1.PageSize + "," + Grid1.PageSize); int count = Int32.Parse(DbHelperMySQL.GetSingle("select count(1) from(" + sql + ") aa").ToString()); if (ds.Tables[0] != null) { Grid1.RecordCount = count; Grid1.DataSource = ds.Tables[0]; Grid1.DataBind(); } }
/// <summary> /// 获得数据列表 /// </summary> public string getSumScore(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append(" select sum(score) as score "); strSql.Append(" FROM Personal_Score "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = DbHelperMySQL.GetSingle(strSql.ToString()); if (obj == null) { return("0"); } else { return(obj.ToString()); } }
public int DBWeekAndStepGet(int type) { int result = 0; int result2; try { object obj = DbHelperMySQL.GetSingle("select value from t_async where id = " + type); if (obj != null && obj != DBNull.Value) { int.TryParse(obj.ToString(), out result); } result2 = result; } catch (Exception ex) { LogManager.WriteException(ex.ToString()); result2 = -1; } return(result2); }
public void InitConfig() { try { XElement xmlFile = ConfigHelper.Load("config.xml"); this.SignUpWaitSecs3 = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "SignUpWaitSecs3", "value", 10L); this.SignUpWaitSecsAll = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "SignUpWaitSecsAll", "value", 15L); this.RankData.MaxPaiMingRank = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "MaxPaiMingRank", "value", 50000L); this.MaxSendDetailDataCount = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "MaxSendDetailDataCount", "value", 100L); this.MaxRolePairFightCount = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "MaxRolePairFightCount", "value", 3L); if (this.CurrGameId == Global.UninitGameId) { this.CurrGameId = (int)((long)DbHelperMySQL.GetSingle("SELECT IFNULL(MAX(id),0) FROM t_tianti_game_fuben;")); } this.Initialized = true; } catch (Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XHD.Model.Param_SysParam model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Param_SysParam("); strSql.Append("Factory_Id,parentid,params_name,params_order,Create_id,Create_date,Update_id,Update_date)"); strSql.Append(" values ("); strSql.Append("@Factory_Id,@parentid,@params_name,@params_order,@Create_id,@Create_date,@Update_id,@Update_date)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@parentid", MySqlDbType.Int32, 4), new MySqlParameter("@params_name", MySqlDbType.VarChar, 250), new MySqlParameter("@params_order", MySqlDbType.Int32, 4), new MySqlParameter("@Create_id", MySqlDbType.Int32, 4), new MySqlParameter("@Create_date", MySqlDbType.DateTime), new MySqlParameter("@Update_id", MySqlDbType.Int32, 4), new MySqlParameter("@Update_date", MySqlDbType.DateTime) }; parameters[0].Value = model.Factory_Id; parameters[1].Value = model.parentid; parameters[2].Value = model.params_name; parameters[3].Value = model.params_order; parameters[4].Value = model.Create_id; parameters[5].Value = model.Create_date; parameters[6].Value = model.Update_id; parameters[7].Value = model.Update_date; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XHD.Model.ssn_role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ssn_role("); strSql.Append("Factory_Id,RoleName,RoleDscript,RoleSort,CreateID,CreateDate,UpdateID,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@Factory_Id,@RoleName,@RoleDscript,@RoleSort,@CreateID,@CreateDate,@UpdateID,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@RoleName", MySqlDbType.VarChar, 255), new MySqlParameter("@RoleDscript", MySqlDbType.VarChar, 255), new MySqlParameter("@RoleSort", MySqlDbType.Int32, 4), new MySqlParameter("@CreateID", MySqlDbType.Int32, 4), new MySqlParameter("@CreateDate", MySqlDbType.DateTime), new MySqlParameter("@UpdateID", MySqlDbType.Int32, 4), new MySqlParameter("@UpdateDate", MySqlDbType.DateTime) }; parameters[0].Value = model.Factory_Id; parameters[1].Value = model.RoleName; parameters[2].Value = model.RoleDscript; parameters[3].Value = model.RoleSort; parameters[4].Value = model.CreateID; parameters[5].Value = model.CreateDate; parameters[6].Value = model.UpdateID; parameters[7].Value = model.UpdateDate; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XHD.Model.hr_position model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into hr_position("); strSql.Append("factory_Id,position_name,position_order,position_level,create_id,create_date,isDelete,Delete_time)"); strSql.Append(" values ("); strSql.Append("@factory_Id,@position_name,@position_order,@position_level,@create_id,@create_date,@isDelete,@Delete_time)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@position_name", MySqlDbType.VarChar, 250), new MySqlParameter("@position_order", MySqlDbType.Int32, 4), new MySqlParameter("@position_level", MySqlDbType.VarChar, 50), new MySqlParameter("@create_id", MySqlDbType.Int32, 4), new MySqlParameter("@create_date", MySqlDbType.DateTime), new MySqlParameter("@isDelete", MySqlDbType.Int32, 4), new MySqlParameter("@Delete_time", MySqlDbType.DateTime) }; parameters[0].Value = model.factory_Id; parameters[1].Value = model.position_name; parameters[2].Value = model.position_order; parameters[3].Value = model.position_level; parameters[4].Value = model.create_id; parameters[5].Value = model.create_date; parameters[6].Value = model.isDelete; parameters[7].Value = model.Delete_time; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public byte[] LoadBHMatchRoleData(int type, int rid) { byte[] result; try { object roledata = DbHelperMySQL.GetSingle(string.Format("SELECT data1 FROM t_banghui_match_roles WHERE `type`={0} AND rid={1}", type, rid)); if (null == roledata) { result = null; } else { result = (byte[])roledata; } } catch (Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); result = null; } return(result); }
/// <summary> /// 创建一个幻影寺院副本 /// </summary> /// <param name="huanYingSiYuanAgent"></param> /// <param name="groupIndex"></param> /// <param name="roleNum"></param> /// <returns></returns> public HuanYingSiYuanFuBenData CreateHysyGameFuBen(HuanYingSiYuanAgent huanYingSiYuanAgent, int groupIndex, int roleNum) { int fuBenSeqId = huanYingSiYuanAgent.PopFuBenSeqId(); if (fuBenSeqId <= 0) { return(null); } int gameId; int serverId = huanYingSiYuanAgent.ClientInfo.ServerId; try { gameId = (int)DbHelperMySQL.GetSingle(string.Format("select CreateHysyGameFuBen({0},{1},{2})", serverId, fuBenSeqId, roleNum)); //id = (int)DbHelperMySQL.GetSingle(string.Format("select CreateHysyGameFuBen('{0}',{1},{2},{3})", DateTime.Now.ToString("yyMMdd"), serverId, fuBenSeqId, roleNum)); } catch (System.Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); gameId = -1; } HuanYingSiYuanFuBenData huanYingSiYuanFuBenData = null; if (gameId > 0) { huanYingSiYuanFuBenData = new HuanYingSiYuanFuBenData() { ServerId = serverId, GroupIndex = groupIndex, SequenceId = fuBenSeqId, GameId = gameId, EndTime = Global.NowTime.AddMinutes(Consts.HuanYingSiYuanGameFuBenMaxExistMinutes), }; } return(huanYingSiYuanFuBenData); }
public byte[] LoadCompRoleData4Selector(int rid) { byte[] result; try { object roledata = DbHelperMySQL.GetSingle(string.Format("SELECT data1 FROM t_comp_roles WHERE rid={0}", rid)); if (null == roledata) { result = null; } else { result = (byte[])roledata; } } catch (Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); result = null; } return(result); }
public bool Exists(string strSql) { object obj = dbHelper.GetSingle(strSql); string cmdresult; if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { cmdresult = ""; } else { cmdresult = obj.ToString(); } if (cmdresult == "") { return(false); } else { return(true); } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * MySqlParameter[] parameters = { * new MySqlParameter("@tblName", MySqlDbType.VarChar, 255), * new MySqlParameter("@fldName", MySqlDbType.VarChar, 255), * new MySqlParameter("@PageSize", MySqlDbType.Int32), * new MySqlParameter("@PageIndex", MySqlDbType.Int32), * new MySqlParameter("@IsReCount", MySqlDbType.Bit), * new MySqlParameter("@OrderType", MySqlDbType.Bit), * new MySqlParameter("@strWhere", MySqlDbType.VarChar,1000), * }; * parameters[0].Value = "urlconfigs_k"; * parameters[1].Value = "kId"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperMySQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod public int AddBringId(KiwiCrawler.Model.Urlconfigs_k model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into urlconfigs_k("); strSql.Append("kUrl,kPageTotal,kCaptureType,kDetailPattern,kDetailPatternType,kNextPagePattern,kNextPagePatternType,kComplateDegree,kAddressBusinessType,kKeyWords,kNotes)"); strSql.Append(" output inserted.kId"); strSql.Append(" values ("); strSql.Append("@kUrl,@kPageTotal,@kCaptureType,@kDetailPattern,@kDetailPatternType,@kNextPagePattern,@kNextPagePatternType,@kComplateDegree,@kAddressBusinessType,@kKeyWords,@kNotes)"); MySqlParameter[] parameters = { new MySqlParameter("@kUrl", MySqlDbType.Text), new MySqlParameter("@kPageTotal", MySqlDbType.Int32, 11), new MySqlParameter("@kCaptureType", MySqlDbType.Text), new MySqlParameter("@kDetailPattern", MySqlDbType.Text), new MySqlParameter("@kDetailPatternType", MySqlDbType.VarChar, 255), new MySqlParameter("@kNextPagePattern", MySqlDbType.Text), new MySqlParameter("@kNextPagePatternType", MySqlDbType.VarChar, 255), new MySqlParameter("@kComplateDegree", MySqlDbType.Float), new MySqlParameter("@kAddressBusinessType", MySqlDbType.Text), new MySqlParameter("@kKeyWords", MySqlDbType.Text), new MySqlParameter("@kNotes", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.kUrl; parameters[1].Value = model.kPageTotal; parameters[2].Value = model.kCaptureType; parameters[3].Value = model.kDetailPattern; parameters[4].Value = model.kDetailPatternType; parameters[5].Value = model.kNextPagePattern; parameters[6].Value = model.kNextPagePatternType; parameters[7].Value = model.kComplateDegree; parameters[8].Value = model.kAddressBusinessType; parameters[9].Value = model.kKeyWords; parameters[10].Value = model.kNotes; int id = Convert.ToInt32(DbHelperMySQL.GetSingle(strSql.ToString(), parameters)); return(id); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XHD.Model.Exchange model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Exchange("); strSql.Append("Factory_Id,proNam,proId,empId,createDate,empname,isChange)"); strSql.Append(" values ("); strSql.Append("@Factory_Id,@proNam,@proId,@empId,@createDate,@empname,@isChange)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@proNam", MySqlDbType.VarChar, 10), new MySqlParameter("@proId", MySqlDbType.Int32, 11), new MySqlParameter("@empId", MySqlDbType.Int32, 11), new MySqlParameter("@createDate", MySqlDbType.VarChar, 50), new MySqlParameter("@empname", MySqlDbType.VarChar, 50), new MySqlParameter("@isChange", MySqlDbType.Int16, 4) }; parameters[0].Value = model.Factory_Id; parameters[1].Value = model.proNam; parameters[2].Value = model.proId; parameters[3].Value = model.empId; parameters[4].Value = model.createDate; parameters[5].Value = model.empname; parameters[6].Value = model.isChange; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 初始化配置文件 /// </summary> public void InitConfig() { try { XElement xmlFile = ConfigHelper.Load("config.xml"); YongZheZhanChangRoleCount = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "MinEnterCount", "value", 100); //勇者战场 KuaFuBossRoleCount = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "KuaFuBossRoleCount", "value", 50); //跨服Boss KingOfBattleRoleCount = (int)ConfigHelper.GetElementAttributeValueLong(xmlFile, "add", "key", "KingOfBattleRoleCount", "value", 40); //王者战场 string strLangHunLingYuResetCityTime = ConfigHelper.GetElementAttributeValue(xmlFile, "add", "key", "LangHunLingYuResetCityTime", "value", ""); //跨服Boss if (string.IsNullOrEmpty(strLangHunLingYuResetCityTime) || !TimeSpan.TryParse(strLangHunLingYuResetCityTime, out LangHunLingYuResetCityTime)) { //如果未配置或者解析出错,则设置充值时间为不可达到的值,防止在错误的时间重置引起玩家数据丢失 LangHunLingYuResetCityTime = TimeSpan.MaxValue; } //强制限制单服最大活动副本数 int MaxRoleCount = Math.Max(YongZheZhanChangRoleCount, KuaFuBossRoleCount); MaxRoleCount = Math.Max(MaxRoleCount, KingOfBattleRoleCount); MaxServerCapcity = Math.Max(3000 / MaxRoleCount, 30); InitLangHunLingYuConfig(); if (CurrGameId == Global.UninitGameId) { CurrGameId = (int)((long)DbHelperMySQL.GetSingle("SELECT IFNULL(MAX(id),0) FROM t_yongzhezhanchang_game_fuben;")); } Initialized = true; } catch (System.Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XHD.Model.Personal_notes model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Personal_notes("); strSql.Append("emp_id,emp_name,note_content,note_color,xyz,note_time)"); strSql.Append(" values ("); strSql.Append("@emp_id,@emp_name,@note_content,@note_color,@xyz,@note_time)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@emp_id", MySqlDbType.Int32, 4), new MySqlParameter("@emp_name", MySqlDbType.VarChar, 250), new MySqlParameter("@note_content", MySqlDbType.VarChar, -1), new MySqlParameter("@note_color", MySqlDbType.VarChar, 250), new MySqlParameter("@xyz", MySqlDbType.VarChar, 250), new MySqlParameter("@note_time", MySqlDbType.DateTime) }; parameters[0].Value = model.emp_id; parameters[1].Value = model.emp_name; parameters[2].Value = model.note_content; parameters[3].Value = model.note_color; parameters[4].Value = model.xyz; parameters[5].Value = model.note_time; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public ActionResult Activity_GetListByPage(SearchModel model) { string sql1 = "select t.*,t1.name teamname,t2.name abilityname from f_activity t left join f_team t1 on t.teamid=t1.id left join f_team_ability t2 on t.abilityid=t2.id where t.del=0 and date_format(t.time,'%Y')='" + model.number1 + "'"; string sql2 = "select count(*) from f_activity t where t.del=0 and date_format(t.time,'%Y')='" + model.number1 + "'"; if (!string.IsNullOrWhiteSpace(model.string1)) { string and = " and t.name like '%" + model.string1 + "%'"; sql1 += and; sql2 += and; } if (model.number2 != -1) { string and = " and t.state=" + model.number2; sql1 += and; sql2 += and; } sql1 += string.Format(" order by t.id desc limit {0}", Util.getPage(model.page, model.limit)); DataTable dt = DbHelperMySQL.Query(sql1).Tables[0]; var data = dt.ConvertToModel <f_activity>(); int count = Convert.ToInt32(DbHelperMySQL.GetSingle(sql2)); return(Json(Result.Success(count, data), JsonRequestBehavior.AllowGet)); }
public ActionResult Xzqh_GetListByPage(SearchModel model) { string sql1 = "select t.*,substr(code,1,9) as short_code from t_xzqh t where t.pcode!='0'"; string sql2 = "select count(*) from t_xzqh t where t.pcode!='0'"; if (model.string1 != "-1") { string and = " and t.pcode='" + model.string1 + "'"; sql1 += and; sql2 += and; } if (!string.IsNullOrWhiteSpace(model.string2)) { string and = " and t.name like '%" + model.string2 + "%'"; sql1 += and; sql2 += and; } sql1 += " order by short_code,pcode limit " + Util.getPage(model.page, model.limit); DataTable dt = DbHelperMySQL.Query(sql1).Tables[0]; var data = dt.ConvertToModel <t_xzqh>(); int count = Convert.ToInt32(DbHelperMySQL.GetSingle(sql2)); return(Json(Result.Success(count, data), JsonRequestBehavior.AllowGet)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XHD.Model.CRM_product_category model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CRM_product_category("); strSql.Append("product_category,parentid,product_icon,isDelete,Delete_id,Delete_time)"); strSql.Append(" values ("); strSql.Append("@product_category,@parentid,@product_icon,@isDelete,@Delete_id,@Delete_time)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@product_category", MySqlDbType.VarChar, 250), new MySqlParameter("@parentid", MySqlDbType.Int32, 4), new MySqlParameter("@product_icon", MySqlDbType.VarChar, 250), new MySqlParameter("@isDelete", MySqlDbType.Int32, 4), new MySqlParameter("@Delete_id", MySqlDbType.Int32, 4), new MySqlParameter("@Delete_time", MySqlDbType.DateTime) }; parameters[0].Value = model.product_category; parameters[1].Value = model.parentid; parameters[2].Value = model.product_icon; parameters[3].Value = model.isDelete; parameters[4].Value = model.Delete_id; parameters[5].Value = model.Delete_time; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public ActionResult getNewIndexData() { Dictionary <string, Object> result = new Dictionary <string, object>(); //秸秆焚烧数据 //智慧农业数据 //村务公开数据 //////新闻数量 Dictionary <string, Object> cwgk = new Dictionary <string, object>(); string sql = "select count(*) from t_news t where t.del=0 and t.state=1"; int count = Convert.ToInt32(DbHelperMySQL.GetSingle(sql)); cwgk.Add("news_count", count); //////消息数量 List <t_user_message> messages = new List <t_user_message>(); sql = string.Format("select count(*) from t_user_xzqh t where t.userid={0} and t.newcount>0", Common.getUser().id); count = Convert.ToInt32(DbHelperMySQL.GetSingle(sql)); sql = string.Format("select count(*) from t_news_talk t where t.userid={0} and t.read=0", Common.getUser().id); count += Convert.ToInt32(DbHelperMySQL.GetSingle(sql)); cwgk.Add("message_count", count); result.Add("cwgk", cwgk); //电商扶贫数据 return(Json(Result.Success(1, result), JsonRequestBehavior.AllowGet)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XHD.Model.scm_supply_app model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sys_app("); strSql.Append("App_name,App_order,App_url,App_handler,App_type,App_icon)"); strSql.Append(" values ("); strSql.Append("@App_name,@App_order,@App_url,@App_handler,@App_type,@App_icon)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@App_name", MySqlDbType.VarChar, 100), new MySqlParameter("@App_order", MySqlDbType.Int32, 4), new MySqlParameter("@App_url", MySqlDbType.VarChar, 250), new MySqlParameter("@App_handler", MySqlDbType.VarChar, 250), new MySqlParameter("@App_type", MySqlDbType.VarChar, 50), new MySqlParameter("@App_icon", MySqlDbType.VarChar, 250) }; parameters[0].Value = model.App_name; parameters[1].Value = model.App_order; parameters[2].Value = model.App_url; parameters[3].Value = model.App_handler; parameters[4].Value = model.App_type; parameters[5].Value = model.App_icon; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XHD.Model.Sys_Button model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Button("); strSql.Append("Btn_name,Btn_icon,Btn_handler,Menu_id,Menu_name,Btn_order)"); strSql.Append(" values ("); strSql.Append("@Btn_name,@Btn_icon,@Btn_handler,@Menu_id,@Menu_name,@Btn_order)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@Btn_name", MySqlDbType.VarChar, 255), new MySqlParameter("@Btn_icon", MySqlDbType.VarChar, 50), new MySqlParameter("@Btn_handler", MySqlDbType.VarChar, 255), new MySqlParameter("@Menu_id", MySqlDbType.Int32, 4), new MySqlParameter("@Menu_name", MySqlDbType.VarChar, 255), new MySqlParameter("@Btn_order", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.Btn_name; parameters[1].Value = model.Btn_icon; parameters[2].Value = model.Btn_handler; parameters[3].Value = model.Menu_id; parameters[4].Value = model.Menu_name; parameters[5].Value = model.Btn_order; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }