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