public List<Maticsoft.Model.Shop.Products.ProductStationMode> DataTableToList(DataTable dt) { List<Maticsoft.Model.Shop.Products.ProductStationMode> list = new List<Maticsoft.Model.Shop.Products.ProductStationMode>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Maticsoft.Model.Shop.Products.ProductStationMode item = new Maticsoft.Model.Shop.Products.ProductStationMode(); if ((dt.Rows[i]["StationId"] != null) && (dt.Rows[i]["StationId"].ToString() != "")) { item.StationId = int.Parse(dt.Rows[i]["StationId"].ToString()); } if ((dt.Rows[i]["ProductId"] != null) && (dt.Rows[i]["ProductId"].ToString() != "")) { item.ProductId = long.Parse(dt.Rows[i]["ProductId"].ToString()); } if ((dt.Rows[i]["DisplaySequence"] != null) && (dt.Rows[i]["DisplaySequence"].ToString() != "")) { item.DisplaySequence = int.Parse(dt.Rows[i]["DisplaySequence"].ToString()); } if ((dt.Rows[i]["Type"] != null) && (dt.Rows[i]["Type"].ToString() != "")) { item.Type = int.Parse(dt.Rows[i]["Type"].ToString()); } list.Add(item); } } return list; }
private string InsertProductStationMode(HttpContext context) { JsonObject obj2 = new JsonObject(); int productId = Convert.ToInt32(context.Request.Form["ProductId"]); int type = Convert.ToInt32(context.Request.Form["Type"]); if (this.productStationModeBLL.Exists(productId, type)) { obj2.Put("STATUS", "Presence"); return obj2.ToString(); } Maticsoft.Model.Shop.Products.ProductStationMode model = new Maticsoft.Model.Shop.Products.ProductStationMode { ProductId = productId, DisplaySequence = (this.productStationModeBLL.GetRecordCount(string.Empty) == 0) ? 1 : (this.productStationModeBLL.GetRecordCount(string.Empty) + 1), Type = type }; if (this.productStationModeBLL.Add(model) > 0) { obj2.Put("STATUS", "SUCCESS"); obj2.Put("DATA", "Approve"); return obj2.ToString(); } obj2.Put("STATUS", "NODATA"); return obj2.ToString(); }
public Maticsoft.Model.Shop.Products.ProductStationMode GetModel(int StationId) { StringBuilder builder = new StringBuilder(); builder.Append("SELECT TOP 1 StationId,ProductId,DisplaySequence,Type FROM Shop_ProductStationModes "); builder.Append(" WHERE StationId=@StationId"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@StationId", SqlDbType.Int, 4) }; cmdParms[0].Value = StationId; Maticsoft.Model.Shop.Products.ProductStationMode mode = new Maticsoft.Model.Shop.Products.ProductStationMode(); DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if ((set.Tables[0].Rows[0]["StationId"] != null) && (set.Tables[0].Rows[0]["StationId"].ToString() != "")) { mode.StationId = int.Parse(set.Tables[0].Rows[0]["StationId"].ToString()); } if ((set.Tables[0].Rows[0]["ProductId"] != null) && (set.Tables[0].Rows[0]["ProductId"].ToString() != "")) { mode.ProductId = long.Parse(set.Tables[0].Rows[0]["ProductId"].ToString()); } if ((set.Tables[0].Rows[0]["DisplaySequence"] != null) && (set.Tables[0].Rows[0]["DisplaySequence"].ToString() != "")) { mode.DisplaySequence = int.Parse(set.Tables[0].Rows[0]["DisplaySequence"].ToString()); } if ((set.Tables[0].Rows[0]["Type"] != null) && (set.Tables[0].Rows[0]["Type"].ToString() != "")) { mode.Type = int.Parse(set.Tables[0].Rows[0]["Type"].ToString()); } return mode; }
protected void ButUpload_Click(object sender, EventArgs e) { try { if ((this.FileUploadProducts.PostedFile != null) && (this.FileUploadProducts.PostedFile.ContentLength > 0)) { string str = Path.GetExtension(this.FileUploadProducts.PostedFile.FileName).ToLower(); ".csv".IndexOf(str); if ((!this.CheckBox1.Checked && !this.CheckBox2.Checked) && (!this.CheckBox3.Checked && !this.CheckBox4.Checked)) { MessageBox.ShowFailTip(this, "请至少选择一种商品推荐方式!"); } else { int num = Convert.ToInt32((this.ProductsBatchUploadDropList.SelectedValue == this.dropItem0Value) ? "-1" : this.ProductsBatchUploadDropList.SelectedValue); int num2 = Convert.ToInt32((this.dropProductTypes.SelectedValue == this.dropItem0Value) ? "-1" : this.dropProductTypes.SelectedValue); int num3 = Convert.ToInt32((this.dropBrands.SelectedValue == this.dropItem0Value) ? "-1" : this.dropBrands.SelectedValue); int num4 = Convert.ToInt32((this.dropEnterprise.SelectedValue == this.dropItem0Value) ? "-1" : this.dropEnterprise.SelectedValue); string str2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; OleDbConnection selectConnection = new OleDbConnection(str2 + this.FileUploadProducts.PostedFile.FileName.Replace(this.FileUploadProducts.FileName, string.Empty) + ";Extended Properties=\"text;HDR=Yes;FMT=Delimited\""); DataSet dataSet = new DataSet(); new OleDbDataAdapter("select * from " + this.FileUploadProducts.FileName, selectConnection).Fill(dataSet); selectConnection.Close(); int num5 = 0; Maticsoft.Model.Shop.Products.ProductInfo model = new Maticsoft.Model.Shop.Products.ProductInfo(); Maticsoft.BLL.Shop.Products.ProductInfo info2 = new Maticsoft.BLL.Shop.Products.ProductInfo(); for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { model.CategoryId = num; model.TypeId = new int?(num2); model.BrandId = num3; model.SupplierId = num4; model.SaleStatus = this.CheckBoxSaleStatus.Checked ? 1 : 0; model.ProductName = dataSet.Tables[0].Rows[i]["商品名称"].ToString(); model.Description = dataSet.Tables[0].Rows[i]["简单介绍"].ToString(); model.AddedDate = Convert.ToDateTime(dataSet.Tables[0].Rows[i]["添加时间"]); model.ImageUrl = dataSet.Tables[0].Rows[i]["清晰图"].ToString(); model.MarketPrice = new decimal?(Convert.ToDecimal(dataSet.Tables[0].Rows[i]["市场价"].ToString())); model.LineId = 1; int num7 = Convert.ToInt32(info2.Add(model)); if (num7 != 0) { Maticsoft.Model.Shop.Products.ProductStationMode mode = new Maticsoft.Model.Shop.Products.ProductStationMode(); Maticsoft.BLL.Shop.Products.ProductStationMode mode2 = new Maticsoft.BLL.Shop.Products.ProductStationMode(); int num8 = 0; for (int j = 1; j <= 4; j++) { CheckBox box = (CheckBox) this.divCheckBox.FindControl("CheckBox" + j); if (box.Checked) { mode.ProductId = num7; mode.DisplaySequence = mode2.GetRecordCount(" ProductId = " + num7) + 1; mode.Type = Convert.ToInt32(box.SkinID); if (mode2.Add(mode) != 0) { num8 = 1; } } } if (num8 == 1) { num8 = 0; num5++; } } } if (num5 > 0) { MessageBox.ShowAndBack(this, "已成功导入 " + num5.ToString() + " 个商品!"); } else { MessageBox.ShowFailTip(this, "导入失败!"); } } } else { MessageBox.ShowFailTip(this, "请选择上传文件!"); } } catch (Exception exception) { MessageBox.ShowFailTip(this, exception.Message); } }