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