/// <summary>
/// 将DataRow赋值到实体
/// </summary>
private Category_360Entity SetDsToEntity(DataSet ds, Category_360Entity model)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["Cateid"].ToString() != "")
{
model.Cateid = int.Parse(ds.Tables[0].Rows[0]["Cateid"].ToString());
}
if (ds.Tables[0].Rows[0]["C1SysNo"].ToString() != "")
{
model.C1SysNo = int.Parse(ds.Tables[0].Rows[0]["C1SysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["C2SysNo"].ToString() != "")
{
model.C2SysNo = int.Parse(ds.Tables[0].Rows[0]["C2SysNo"].ToString());
}
model.C1Name = ds.Tables[0].Rows[0]["C1Name"].ToString();
model.C2Name = ds.Tables[0].Rows[0]["C2Name"].ToString();
model.C3Name = ds.Tables[0].Rows[0]["C3Name"].ToString();
model.Alias = ds.Tables[0].Rows[0]["Alias"].ToString();
model.APIName = ds.Tables[0].Rows[0]["APIName"].ToString();
model.APINameEnd = ds.Tables[0].Rows[0]["APINameEnd"].ToString();
if (ds.Tables[0].Rows[0]["Isred"].ToString() != "")
{
model.Isred = int.Parse(ds.Tables[0].Rows[0]["Isred"].ToString());
}
if (ds.Tables[0].Rows[0]["Isnew"].ToString() != "")
{
model.Isnew = int.Parse(ds.Tables[0].Rows[0]["Isnew"].ToString());
}
if (ds.Tables[0].Rows[0]["Minihot"].ToString() != "")
{
model.Minihot = int.Parse(ds.Tables[0].Rows[0]["Minihot"].ToString());
}
if (ds.Tables[0].Rows[0]["Minired"].ToString() != "")
{
model.Minired = int.Parse(ds.Tables[0].Rows[0]["Minired"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["LastUpdateTime"].ToString() != "")
{
model.LastUpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastUpdateTime"].ToString());
}
return(model);
}
public int AddNew(Category_360Entity model)
{
string sql = "SELECT DISTINCT SysNo FROM dbo.Category_360 WHERE Cateid = " + Util.ToSqlString(Convert.ToString(model.Cateid));
string sysNo = Convert.ToString(SqlHelper.ExecuteScalar(AppConfig.Conn_O2O2, sql));
if (!string.IsNullOrEmpty(sysNo))
{
return(Convert.ToInt32(sysNo));
}
else
{
return(Add(model));
}
}
public Category_360Entity ReturnCategory(JsonData jsonData, int level)
{
Category_360Entity Entity = new Category_360Entity();
string cateid = Convert.ToString(jsonData["cateid"]);
string name = Convert.ToString(jsonData["name"]);
string alias = Convert.ToString(jsonData["alias"]);
string isred = Convert.ToString(jsonData["isred"]);
string isnew = Convert.ToString(jsonData["isnew"]);
string minihot = Convert.ToString(jsonData["minihot"]);
string minired = Convert.ToString(jsonData["minired"]);
Entity.Cateid = Convert.ToInt32(cateid);
Entity.Alias = alias;
Entity.Isred = Convert.ToInt32(isred);
Entity.Isnew = Convert.ToInt32(isnew);
Entity.Minihot = Convert.ToInt32(minihot);
Entity.Minired = Convert.ToInt32(minired);
if (level == 1)
{
if (!string.IsNullOrEmpty(alias))
{
Entity.C1Name = alias;
}
else
{
Entity.C1Name = name;
}
Entity.APIName = name;
}
else if (level == 2)
{
Entity.C2Name = name;
}
else if (level == 3)
{
Entity.C3Name = name;
}
//else//不要购物不要四级
//{
// Entity.C4Name = name;
//}
Entity.APINameEnd = name;
return(Entity);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Category_360Entity GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from dbo.Category_360");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4)
};
parameters[0].Value = SysNo;
Category_360Entity model = new Category_360Entity();
DataSet ds = SqlHelper.ExecuteDataSet(AppConfig.Conn_O2O2, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
SetDsToEntity(ds, model);
return(model);
}
else
{
return(null);
}
}
//360分类数据
protected void Button3_Click(object sender, EventArgs e)
{
string sMessage = PostByHttpRequest("", "http://api.tuan.360.cn/open_category.php?format=json");
JsonData jd = JsonMapper.ToObject(sMessage);
int status = 0;
DateTime lasthUpdateTime = DateTime.Now;
for (int i = 0; i < jd.Count; i++)
{
JsonData jdItem = jd[i];
if (Convert.ToString(jdItem["name"]) == "网上购物")
{
continue;
}
//string C1cateid = Convert.ToString(jdItem["cateid"]);
//string C1name = Convert.ToString(jdItem["name"]);
//string C1alias = Convert.ToString(jdItem["alias"]);
//string C1isred = Convert.ToString(jdItem["isred"]);
//string C1isnew = Convert.ToString(jdItem["isnew"]);
//string C1minihot = Convert.ToString(jdItem["minihot"]);
//string C1minired = Convert.ToString(jdItem["minired"]);
Category_360Entity tceC1 = ReturnCategory(jdItem, 1);
tceC1.Status = status;
tceC1.LastUpdateTime = lasthUpdateTime;
//插入一级类别
int C1SysNo = new Category_360Dac().Add(tceC1);
if (jdItem.Count > 7)
{
JsonData jdSons = jdItem[7];
for (int j = 0; j < jdSons.Count; j++)
{
JsonData jdSon = jdSons[j];
//string C2cateid = Convert.ToString(jdSon["cateid"]);
//string C2name = Convert.ToString(jdSon["name"]);
//string C2alias = Convert.ToString(jdSon["alias"]);
//string C2isred = Convert.ToString(jdSon["isred"]);
//string C2isnew = Convert.ToString(jdSon["isnew"]);
//string C2minihot = Convert.ToString(jdSon["minihot"]);
//string C2minired = Convert.ToString(jdSon["minired"]);
Category_360Entity tceC2 = ReturnCategory(jdSon, 2);
tceC2.C1SysNo = C1SysNo;
tceC2.C1Name = tceC1.C1Name;
tceC2.APIName = tceC1.APIName;
tceC2.Status = status;
tceC2.LastUpdateTime = lasthUpdateTime;
//插入二级类别
int C2SysNo = new Category_360Dac().Add(tceC2);
if (jdSon.Count > 7)
{
JsonData jdSonSons = jdSon[7];
for (int k = 0; k < jdSonSons.Count; k++)
{
JsonData jdSonSonsSon = jdSonSons[k];
//string C3cateid = Convert.ToString(jdSonSonsSon["cateid"]);
//string C3name = Convert.ToString(jdSonSonsSon["name"]);
//string C3alias = Convert.ToString(jdSonSonsSon["alias"]);
//string C3isred = Convert.ToString(jdSonSonsSon["isred"]);
//string C3isnew = Convert.ToString(jdSonSonsSon["isnew"]);
//string C3minihot = Convert.ToString(jdSonSonsSon["minihot"]);
//string C3minired = Convert.ToString(jdSonSonsSon["minired"]);
Category_360Entity tceC3 = ReturnCategory(jdSonSonsSon, 3);
tceC3.C1SysNo = C1SysNo;
tceC3.C1Name = tceC1.C1Name;
tceC3.APIName = tceC1.APIName;
tceC3.C2SysNo = C2SysNo;
tceC3.C2Name = tceC2.C2Name;
tceC3.Status = 0;
tceC3.LastUpdateTime = lasthUpdateTime;
//插入三级类别
int C3SysNo = new Category_360Dac().Add(tceC3);
//if (jdSonSonsSon.Count > 7)//不要购物 不要四级
//{
// JsonData jdSonSonsSonSons = jdSonSonsSon[7];
// for (int z = 0; z < jdSonSonsSonSons.Count; z++)
// {
// JsonData jdSonSonsSonSonsSon = jdSonSonsSonSons[z];
// Category_360Entity tceC4 = ReturnCategory(jdSonSonsSonSonsSon, 4);
// tceC4.C1SysNo = C1SysNo;
// tceC4.C1Name = tceC1.C1Name;
// tceC4.APIName = tceC1.APIName;
// tceC4.C2SysNo = C2SysNo;
// tceC4.C2Name = tceC2.C2Name;
// tceC4.C3SysNo = C3SysNo;
// tceC4.C3Name = tceC3.C3Name;
// //插入四级类别
// int C4SysNo = new Category_360Dac().Add(tceC4);
// }
//}
}
}
}
}
}
Response.Write("成功");
}
//360分类数据导入
private void button1_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
string sMessage = PostByHttpRequest("", ConfigurationManager.AppSettings["APICategory"]);// ConfigurationManager.AppSettings["APICategory"];
JsonData jd = JsonMapper.ToObject(sMessage);
int status = 0;
DateTime lasthUpdateTime = DateTime.Now;
for (int i = 0; i < jd.Count; i++)
{
JsonData jdItem = jd[i];
if (Convert.ToString(jdItem["name"]) == "网上购物")
{
continue;
}
//string C1cateid = Convert.ToString(jdItem["cateid"]);
//string C1name = Convert.ToString(jdItem["name"]);
//string C1alias = Convert.ToString(jdItem["alias"]);
//string C1isred = Convert.ToString(jdItem["isred"]);
//string C1isnew = Convert.ToString(jdItem["isnew"]);
//string C1minihot = Convert.ToString(jdItem["minihot"]);
//string C1minired = Convert.ToString(jdItem["minired"]);
Category_360Entity tceC1 = ReturnCategory(jdItem, 1);
tceC1.Status = status;
tceC1.LastUpdateTime = lasthUpdateTime;
//插入一级类别
int C1SysNo = new Category_360Dac().AddNew(tceC1);
if (jdItem.Count > 7)
{
JsonData jdSons = jdItem[7];
for (int j = 0; j < jdSons.Count; j++)
{
JsonData jdSon = jdSons[j];
//string C2cateid = Convert.ToString(jdSon["cateid"]);
//string C2name = Convert.ToString(jdSon["name"]);
//string C2alias = Convert.ToString(jdSon["alias"]);
//string C2isred = Convert.ToString(jdSon["isred"]);
//string C2isnew = Convert.ToString(jdSon["isnew"]);
//string C2minihot = Convert.ToString(jdSon["minihot"]);
//string C2minired = Convert.ToString(jdSon["minired"]);
Category_360Entity tceC2 = ReturnCategory(jdSon, 2);
tceC2.C1SysNo = C1SysNo;
tceC2.C1Name = tceC1.C1Name;
tceC2.APIName = tceC1.APIName;
tceC2.Status = status;
tceC2.LastUpdateTime = lasthUpdateTime;
//插入二级类别
int C2SysNo = new Category_360Dac().AddNew(tceC2);
if (jdSon.Count > 7)
{
JsonData jdSonSons = jdSon[7];
for (int k = 0; k < jdSonSons.Count; k++)
{
JsonData jdSonSonsSon = jdSonSons[k];
//string C3cateid = Convert.ToString(jdSonSonsSon["cateid"]);
//string C3name = Convert.ToString(jdSonSonsSon["name"]);
//string C3alias = Convert.ToString(jdSonSonsSon["alias"]);
//string C3isred = Convert.ToString(jdSonSonsSon["isred"]);
//string C3isnew = Convert.ToString(jdSonSonsSon["isnew"]);
//string C3minihot = Convert.ToString(jdSonSonsSon["minihot"]);
//string C3minired = Convert.ToString(jdSonSonsSon["minired"]);
Category_360Entity tceC3 = ReturnCategory(jdSonSonsSon, 3);
tceC3.C1SysNo = C1SysNo;
tceC3.C1Name = tceC1.C1Name;
tceC3.APIName = tceC1.APIName;
tceC3.C2SysNo = C2SysNo;
tceC3.C2Name = tceC2.C2Name;
tceC3.Status = 0;
tceC3.LastUpdateTime = lasthUpdateTime;
//插入三级类别
int C3SysNo = new Category_360Dac().AddNew(tceC3);
//if (jdSonSonsSon.Count > 7)//不要购物 不要四级
//{
// JsonData jdSonSonsSonSons = jdSonSonsSon[7];
// for (int z = 0; z < jdSonSonsSonSons.Count; z++)
// {
// JsonData jdSonSonsSonSonsSon = jdSonSonsSonSons[z];
// Category_360Entity tceC4 = ReturnCategory(jdSonSonsSonSonsSon, 4);
// tceC4.C1SysNo = C1SysNo;
// tceC4.C1Name = tceC1.C1Name;
// tceC4.APIName = tceC1.APIName;
// tceC4.C2SysNo = C2SysNo;
// tceC4.C2Name = tceC2.C2Name;
// tceC4.C3SysNo = C3SysNo;
// tceC4.C3Name = tceC3.C3Name;
// //插入四级类别
// int C4SysNo = new Category_360Dac().Add(tceC4);
// }
//}
}
}
}
}
}
Cursor.Current = Cursors.Default;
MessageBox.Show("导入成功！");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Category_360Entity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.Category_360(");
strSql.Append("Cateid,C1SysNo,C2SysNo,C1Name,C2Name,C3Name,Alias,APIName,APINameEnd,Isred,Isnew,Minihot,Minired,Status,LastUpdateTime)");
strSql.Append(" values (");
strSql.Append("@Cateid,@C1SysNo,@C2SysNo,@C1Name,@C2Name,@C3Name,@Alias,@APIName,@APINameEnd,@Isred,@Isnew,@Minihot,@Minired,@Status,@LastUpdateTime)");
strSql.Append(";select @@IDENTITY");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@Cateid", SqlDbType.Int, 4),
new SqlParameter("@C1SysNo", SqlDbType.Int, 4),
new SqlParameter("@C2SysNo", SqlDbType.Int, 4),
new SqlParameter("@C1Name", SqlDbType.NVarChar, 20),
new SqlParameter("@C2Name", SqlDbType.NVarChar, 20),
new SqlParameter("@C3Name", SqlDbType.NVarChar, 20),
new SqlParameter("@Alias", SqlDbType.NVarChar, 20),
new SqlParameter("@APIName", SqlDbType.NVarChar, 20),
new SqlParameter("@APINameEnd", SqlDbType.NVarChar, 20),
new SqlParameter("@Isred", SqlDbType.SmallInt, 2),
new SqlParameter("@Isnew", SqlDbType.SmallInt, 2),
new SqlParameter("@Minihot", SqlDbType.SmallInt, 2),
new SqlParameter("@Minired", SqlDbType.SmallInt, 2),
new SqlParameter("@Status", SqlDbType.SmallInt, 2),
new SqlParameter("@LastUpdateTime", SqlDbType.DateTime),
};
if (model.Cateid != AppConst.IntNull)
{
parameters[0].Value = model.Cateid;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.C1SysNo != AppConst.IntNull)
{
parameters[1].Value = model.C1SysNo;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.C2SysNo != AppConst.IntNull)
{
parameters[2].Value = model.C2SysNo;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.C1Name != AppConst.StringNull)
{
parameters[3].Value = model.C1Name;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.C2Name != AppConst.StringNull)
{
parameters[4].Value = model.C2Name;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
if (model.C3Name != AppConst.StringNull)
{
parameters[5].Value = model.C3Name;
}
else
{
parameters[5].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[5]);
if (model.Alias != AppConst.StringNull)
{
parameters[6].Value = model.Alias;
}
else
{
parameters[6].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[6]);
if (model.APIName != AppConst.StringNull)
{
parameters[7].Value = model.APIName;
}
else
{
parameters[7].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[7]);
if (model.APINameEnd != AppConst.StringNull)
{
parameters[8].Value = model.APINameEnd;
}
else
{
parameters[8].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[8]);
if (model.Isred != AppConst.IntNull)
{
parameters[9].Value = model.Isred;
}
else
{
parameters[9].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[9]);
if (model.Isnew != AppConst.IntNull)
{
parameters[10].Value = model.Isnew;
}
else
{
parameters[10].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[10]);
if (model.Minihot != AppConst.IntNull)
{
parameters[11].Value = model.Minihot;
}
else
{
parameters[11].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[11]);
if (model.Minired != AppConst.IntNull)
{
parameters[12].Value = model.Minired;
}
else
{
parameters[12].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[12]);
if (model.Status != AppConst.IntNull)
{
parameters[13].Value = model.Status;
}
else
{
parameters[13].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[13]);
if (model.LastUpdateTime != AppConst.DateTimeNull)
{
parameters[14].Value = model.LastUpdateTime;
}
else
{
parameters[14].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[14]);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(AppConfig.Conn_O2O2, cmd)));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Category_360Entity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.Category_360 set ");
SqlCommand cmd = new SqlCommand();
if (model.SysNo != AppConst.IntNull)
{
SqlParameter param = new SqlParameter("@SysNo", SqlDbType.Int, 4);
param.Value = model.SysNo;
cmd.Parameters.Add(param);
}
if (model.Cateid != AppConst.IntNull)
{
strSql.Append("Cateid=@Cateid,");
SqlParameter param = new SqlParameter("@Cateid", SqlDbType.Int, 4);
param.Value = model.Cateid;
cmd.Parameters.Add(param);
}
if (model.C1SysNo != AppConst.IntNull)
{
strSql.Append("C1SysNo=@C1SysNo,");
SqlParameter param = new SqlParameter("@C1SysNo", SqlDbType.Int, 4);
param.Value = model.C1SysNo;
cmd.Parameters.Add(param);
}
if (model.C2SysNo != AppConst.IntNull)
{
strSql.Append("C2SysNo=@C2SysNo,");
SqlParameter param = new SqlParameter("@C2SysNo", SqlDbType.Int, 4);
param.Value = model.C2SysNo;
cmd.Parameters.Add(param);
}
if (model.C1Name != AppConst.StringNull)
{
strSql.Append("C1Name=@C1Name,");
SqlParameter param = new SqlParameter("@C1Name", SqlDbType.NVarChar, 20);
param.Value = model.C1Name;
cmd.Parameters.Add(param);
}
if (model.C2Name != AppConst.StringNull)
{
strSql.Append("C2Name=@C2Name,");
SqlParameter param = new SqlParameter("@C2Name", SqlDbType.NVarChar, 20);
param.Value = model.C2Name;
cmd.Parameters.Add(param);
}
if (model.C3Name != AppConst.StringNull)
{
strSql.Append("C3Name=@C3Name,");
SqlParameter param = new SqlParameter("@C3Name", SqlDbType.NVarChar, 20);
param.Value = model.C3Name;
cmd.Parameters.Add(param);
}
if (model.Alias != AppConst.StringNull)
{
strSql.Append("Alias=@Alias,");
SqlParameter param = new SqlParameter("@Alias", SqlDbType.NVarChar, 20);
param.Value = model.Alias;
cmd.Parameters.Add(param);
}
if (model.APIName != AppConst.StringNull)
{
strSql.Append("APIName=@APIName,");
SqlParameter param = new SqlParameter("@APIName", SqlDbType.NVarChar, 20);
param.Value = model.APIName;
cmd.Parameters.Add(param);
}
if (model.APINameEnd != AppConst.StringNull)
{
strSql.Append("APINameEnd=@APINameEnd,");
SqlParameter param = new SqlParameter("@APINameEnd", SqlDbType.NVarChar, 20);
param.Value = model.APINameEnd;
cmd.Parameters.Add(param);
}
if (model.Isred != AppConst.IntNull)
{
strSql.Append("Isred=@Isred,");
SqlParameter param = new SqlParameter("@Isred", SqlDbType.SmallInt, 2);
param.Value = model.Isred;
cmd.Parameters.Add(param);
}
if (model.Isnew != AppConst.IntNull)
{
strSql.Append("Isnew=@Isnew,");
SqlParameter param = new SqlParameter("@Isnew", SqlDbType.SmallInt, 2);
param.Value = model.Isnew;
cmd.Parameters.Add(param);
}
if (model.Minihot != AppConst.IntNull)
{
strSql.Append("Minihot=@Minihot,");
SqlParameter param = new SqlParameter("@Minihot", SqlDbType.SmallInt, 2);
param.Value = model.Minihot;
cmd.Parameters.Add(param);
}
if (model.Minired != AppConst.IntNull)
{
strSql.Append("Minired=@Minired,");
SqlParameter param = new SqlParameter("@Minired", SqlDbType.SmallInt, 2);
param.Value = model.Minired;
cmd.Parameters.Add(param);
}
if (model.Status != AppConst.IntNull)
{
strSql.Append("Status=@Status,");
SqlParameter param = new SqlParameter("@Status", SqlDbType.SmallInt, 2);
param.Value = model.Status;
cmd.Parameters.Add(param);
}
if (model.LastUpdateTime != AppConst.DateTimeNull)
{
strSql.Append("LastUpdateTime=@LastUpdateTime,");
SqlParameter param = new SqlParameter("@LastUpdateTime", SqlDbType.DateTime);
param.Value = model.LastUpdateTime;
cmd.Parameters.Add(param);
}
strSql.Remove(strSql.Length - 1, 1);
strSql.Append(" where SysNo=@SysNo ");
cmd.CommandText = strSql.ToString();
return(SqlHelper.ExecuteNonQuery(AppConfig.Conn_O2O2, cmd));
}
