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