/// <summary> /// 增加一条数据 /// </summary> public bool Add(EVE_Central.Model.typrID model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into typrID("); strSql.Append("typeID,groupID,name_de,name_en,name_fr,name_ja,name_ru,name_zh,iconID,marketGroupID,mass,description_de,description_en,description_fr,description_ja,description_ru,description_zh)"); strSql.Append(" values ("); strSql.Append("@SQL2012typeID,@SQL2012groupID,@SQL2012name_de,@SQL2012name_en,@SQL2012name_fr,@SQL2012name_ja,@SQL2012name_ru,@SQL2012name_zh,@SQL2012iconID,@SQL2012marketGroupID,@SQL2012mass,@SQL2012description_de,@SQL2012description_en,@SQL2012description_fr,@SQL2012description_ja,@SQL2012description_ru,@SQL2012description_zh)"); SqlParameter[] parameters = { new SqlParameter("@SQL2012typeID", SqlDbType.Int, 4), new SqlParameter("@SQL2012groupID", SqlDbType.Int, 4), new SqlParameter("@SQL2012name_de", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012name_en", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012name_fr", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012name_ja", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012name_ru", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012name_zh", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012iconID", SqlDbType.Int, 4), new SqlParameter("@SQL2012marketGroupID", SqlDbType.Int, 4), new SqlParameter("@SQL2012mass", SqlDbType.NVarChar, 50), new SqlParameter("@SQL2012description_de", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012description_en", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012description_fr", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012description_ja", SqlDbType.NVarChar, -1), new SqlParameter("@SQL2012description_ru", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012description_zh", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.typeID; parameters[1].Value = model.groupID; parameters[2].Value = model.name_de; parameters[3].Value = model.name_en; parameters[4].Value = model.name_fr; parameters[5].Value = model.name_ja; parameters[6].Value = model.name_ru; parameters[7].Value = model.name_zh; parameters[8].Value = model.iconID; parameters[9].Value = model.marketGroupID; parameters[10].Value = model.mass; parameters[11].Value = model.description_de; parameters[12].Value = model.description_en; parameters[13].Value = model.description_fr; parameters[14].Value = model.description_ja; parameters[15].Value = model.description_ru; parameters[16].Value = model.description_zh; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("SQL2012tblName", SqlDbType.VarChar, 255), * new SqlParameter("SQL2012fldName", SqlDbType.VarChar, 255), * new SqlParameter("SQL2012PageSize", SqlDbType.Int), * new SqlParameter("SQL2012PageIndex", SqlDbType.Int), * new SqlParameter("SQL2012IsReCount", SqlDbType.Bit), * new SqlParameter("SQL2012OrderType", SqlDbType.Bit), * new SqlParameter("SQL2012strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "typrID"; * parameters[1].Value = "id"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod public EVE_Central.Model.typrID GetModelfromtypeID(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,typeID,groupID,name_de,name_en,name_fr,name_ja,name_ru,name_zh,iconID,marketGroupID,mass,description_de,description_en,description_fr,description_ja,description_ru,description_zh from typrID "); strSql.Append(" where typeid=@SQL2012id "); SqlParameter[] parameters = { new SqlParameter("@SQL2012id", SqlDbType.Int, 4) }; parameters[0].Value = id; EVE_Central.Model.typrID model = new EVE_Central.Model.typrID(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 高水 等迷糊词检索 /// </summary> /// <param name="s"></param> /// <returns></returns> public string gaosipip(string s) { int k = 0; int[] i = null; switch (s) { case "加4": case "+4": i = new int[] { 10208, 10216, 10221, 10212, 10225 }; break; case "加3": case "+3": i = new int[] { 9899, 9941, 9942, 9943, 9956 }; break; case "加5": case "+5": i = new int[] { 10209, 10217, 10222, 10213, 10226 }; break; case "高水": case "高级水晶": case "High-grade Crystal": i = new int[] { 20121, 20157, 20158, 20159, 20160, 20161 }; break; case "高蝰": case "高级蝰蛇": case "High-grade Snake": i = new int[] { 19540, 19551, 19553, 19554, 19555, 19556 }; break; case "高斯": case "高级斯拉夫": case "High-grade Slave": i = new int[] { 20499, 20501, 20503, 20505, 20507, 20509 }; break; case "高魔爪": case "高级魔爪": case "High-grade Talon": k = 31962; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "高圣杯": case "高级圣杯": case "High-grade Grail": k = 31954; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "高马刺": case "高级马刺": case "High-grade Spur": k = 31968; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "高豺狼": case "高级豺狼": case "High-grade Jackal": k = 31974; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "高统御": case "高级统御": case "High-grade Ascendancy": k = 33525; i = new int[] { 33516, k, k + 1, k + 2, k + 3, k + 4 }; break; case "高圣光": case "高级圣光": case "High-grade Halo": k = 20500; i = new int[] { k - 2, k, k + 2, k + 4, k + 6, k + 8 }; break; case "高阿斯克雷": case "高级阿斯克雷": case "High-Grade Asklepian": k = 42210; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "高护符": case "高级护符": case "High-grade Talisman": k = 19534; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "中水": case "中级水晶": case "Mid-grade Crystal": i = new int[] { 22107, 22108, 22109, 22110, 22111, 22112 }; break; case "中蝰": case "中级蝰蛇": case "Mid-grade Snake": i = new int[] { 22125, 22126, 22127, 22128, 22129, 22130 }; break; case "中斯": case "中级斯拉夫": case "Mid-grade Slave": i = new int[] { 22119, 22120, 22121, 22122, 22123, 22124 }; break; case "中百夫": case "中级百夫长": case "Mid-grade Centurion": k = 28790; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "中游牧": case "中级游牧者": case "Mid-grade Nomad": k = 28796; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "中圣光": case "中级圣光": case "Mid-grade Halo": k = 22113; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "中采集": case "中级采集": case "Mid-grade Harvest": k = 28802; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "中护符": case "中级护符": case "Mid-grade Talisman": k = 22121; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "中美德": case "中级美德": case "Mid-grade Virtue": k = 28808; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "中强势": case "中级强势": case "Mid-grade Edge": k = 28814; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "中统御": case "中级统御": case "Mid-grade Ascendancy": k = 33555; i = new int[] { k, k + 2, k + 4, k + 6, k + 8, k + 10 }; break; case "中阿斯克雷": case "中级阿斯克雷": case "Mid-Grade Asklepian": k = 42204; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低水": case "低级水晶": case "Low-grade Crystal": i = new int[] { 33923, 33924, 33925, 33926, 33927, 33928 }; break; case "低蝰": case "低级蝰蛇": case "Low-grade Snake": k = 33959; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低斯": case "低级斯拉夫": case "Low-grade Slave": k = 33953; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低百夫": case "低级百夫长": case "Low-grade Centurion": k = 33917; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低游牧": case "低级游牧者": case "Low-grade Nomad": k = 33947; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低圣光": case "低级圣光": case "Low-grade Halo": k = 33935; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低采集": case "低级采集": case "Low-grade Harvest": k = 33941; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低护符": case "低级护符": case "Low-grade Talisman": k = 33965; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低美德": case "低级美德": case "Low-grade Virtue": k = 33971; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低强势": case "低级强势": case "Low-grade Edge": k = 33929; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, k + 5 }; break; case "低阿斯克雷": case "低级阿斯克雷": case "Low-Grade Asklepian": k = 42200; i = new int[] { 42154, 42156, k, k + 1, k + 2, k + 3 }; break; case "低魔爪": case "低级魔爪": case "Low-grade Talon": k = 32112; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, 32125 }; break; case "低圣杯": case "低级圣杯": case "Low-grade Grail": k = 32101; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, 32122 }; break; case "低马刺": case "低级马刺": case "Low-grade Spur": k = 32107; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, 32124 }; break; case "低豺狼": case "低级豺狼": case "Low-grade Jackal": k = 32117; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, 32123 }; break; case "第一中文匹配": case "第二中文匹配": case "英文匹配": k = 32117; i = new int[] { k, k + 1, k + 2, k + 3, k + 4, 32123 }; break; default: return(null); } string ss = null; EVE_Central.BLL.api api = new EVE_Central.BLL.api(); EVE_Central.BLL.Central cenbll = new EVE_Central.BLL.Central(); EVE_Central.BLL.typrID typebll = new EVE_Central.BLL.typrID(); EVE_Central.Model.marketstat mark = new EVE_Central.Model.marketstat(); EVE_Central.Model.cnoren ce = new EVE_Central.Model.cnoren(); EVE_Central.Model.typrID typemodel = new EVE_Central.Model.typrID(); int x = i.Length; double isk = 0; for (int g = 0; g < x; g++) { mark = api.marketstat(i[g]); isk += Convert.ToDouble(mark.sell_min); mark = isktom(mark, true); typemodel = typebll.GetModelfromtypeID(i[g]); ss += typemodel.name_en.Trim().Replace("\n", string.Empty) + ":" + mark.sell_min + '\n'; } isk = Math.Round(isk, 2); ss += "合计:" + misk(isk.ToString("0.00")); return(ss); }
/// <summary> /// 得到一个对象实体 /// </summary> public EVE_Central.Model.typrID DataRowToModel(DataRow row) { EVE_Central.Model.typrID model = new EVE_Central.Model.typrID(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["typeID"] != null && row["typeID"].ToString() != "") { model.typeID = int.Parse(row["typeID"].ToString()); } if (row["groupID"] != null && row["groupID"].ToString() != "") { model.groupID = int.Parse(row["groupID"].ToString()); } if (row["name_de"] != null) { model.name_de = row["name_de"].ToString(); } if (row["name_en"] != null) { model.name_en = row["name_en"].ToString(); } if (row["name_fr"] != null) { model.name_fr = row["name_fr"].ToString(); } if (row["name_ja"] != null) { model.name_ja = row["name_ja"].ToString(); } if (row["name_ru"] != null) { model.name_ru = row["name_ru"].ToString(); } if (row["name_zh"] != null) { model.name_zh = row["name_zh"].ToString(); } if (row["iconID"] != null && row["iconID"].ToString() != "") { model.iconID = int.Parse(row["iconID"].ToString()); } if (row["marketGroupID"] != null && row["marketGroupID"].ToString() != "") { model.marketGroupID = int.Parse(row["marketGroupID"].ToString()); } if (row["mass"] != null) { model.mass = row["mass"].ToString(); } if (row["description_de"] != null) { model.description_de = row["description_de"].ToString(); } if (row["description_en"] != null) { model.description_en = row["description_en"].ToString(); } if (row["description_fr"] != null) { model.description_fr = row["description_fr"].ToString(); } if (row["description_ja"] != null) { model.description_ja = row["description_ja"].ToString(); } if (row["description_ru"] != null) { model.description_ru = row["description_ru"].ToString(); } if (row["description_zh"] != null) { model.description_zh = row["description_zh"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EVE_Central.Model.typrID model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update typrID set "); strSql.Append("id=SQL2012id,"); strSql.Append("typeID=SQL2012typeID,"); strSql.Append("groupID=SQL2012groupID,"); strSql.Append("name_de=SQL2012name_de,"); strSql.Append("name_en=SQL2012name_en,"); strSql.Append("name_fr=SQL2012name_fr,"); strSql.Append("name_ja=SQL2012name_ja,"); strSql.Append("name_ru=SQL2012name_ru,"); strSql.Append("name_zh=SQL2012name_zh,"); strSql.Append("iconID=SQL2012iconID,"); strSql.Append("marketGroupID=SQL2012marketGroupID,"); strSql.Append("mass=SQL2012mass,"); strSql.Append("description_de=SQL2012description_de,"); strSql.Append("description_en=SQL2012description_en,"); strSql.Append("description_fr=SQL2012description_fr,"); strSql.Append("description_ja=SQL2012description_ja,"); strSql.Append("description_ru=SQL2012description_ru,"); strSql.Append("description_zh=SQL2012description_zh"); strSql.Append(" where id=SQL2012id "); SqlParameter[] parameters = { new SqlParameter("SQL2012id", SqlDbType.Int, 4), new SqlParameter("SQL2012typeID", SqlDbType.Int, 4), new SqlParameter("SQL2012groupID", SqlDbType.Int, 4), new SqlParameter("SQL2012name_de", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012name_en", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012name_fr", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012name_ja", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012name_ru", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012name_zh", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012iconID", SqlDbType.Int, 4), new SqlParameter("SQL2012marketGroupID", SqlDbType.Int, 4), new SqlParameter("SQL2012mass", SqlDbType.NVarChar, 50), new SqlParameter("SQL2012description_de", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012description_en", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012description_fr", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012description_ja", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012description_ru", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012description_zh", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.id; parameters[1].Value = model.typeID; parameters[2].Value = model.groupID; parameters[3].Value = model.name_de; parameters[4].Value = model.name_en; parameters[5].Value = model.name_fr; parameters[6].Value = model.name_ja; parameters[7].Value = model.name_ru; parameters[8].Value = model.name_zh; parameters[9].Value = model.iconID; parameters[10].Value = model.marketGroupID; parameters[11].Value = model.mass; parameters[12].Value = model.description_de; parameters[13].Value = model.description_en; parameters[14].Value = model.description_fr; parameters[15].Value = model.description_ja; parameters[16].Value = model.description_ru; parameters[17].Value = model.description_zh; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }