//初始化 private void GetInit() { M_CommonData dtinfo = cbll.GetCommonData(sid); DataTable dt = cbll.GetContent(sid); this.Namelabel.Text = dtinfo.Title; this.Label1.Text = dtinfo.Inputer; string tablename = dtinfo.TableName; B_ModelField mfll = new B_ModelField(); SafeSC.CheckDataEx(tablename); DataTable tableinfo = mfll.SelectTableName("ZL_Model", "tablename = '" + tablename + "'"); B_Model mll = new B_Model(); if (tableinfo.Rows.Count > 0) { this.Label6.Text = mbll.GetModelById(DataConverter.CLng(dt.Rows[0]["StoreModelID"].ToString())).ModelName; } else { this.Label6.Text = "查询错误!请核实此模型是否存在"; } //string tophtml = "<tr><td width=\"20%\"></td><td width = \"80%\"></td>"; //string endhtml = "</tr>"; //this.ModelHtml.Text = tophtml + this.mfbll.GetUpdateHtmlUser(int.Parse(dt.Rows[0]["StoreModelID"].ToString()), 0, dt) + endhtml; //this.ModelHtml.Text = this.mfbll.GetUpdateHtmlUser(int.Parse(dt.Rows[0]["StoreModelID"].ToString()), 0, dt); }
protected void SetTemplate(object sender, EventArgs e) { B_Model bll1 = new B_Model(); int ModelID = DataConverter.CLng(this.ViewState["ModelID"].ToString()); bll1.UpdateTemplate(this.TxtTemplate.Text, ModelID); }
/// <summary> /// 通过ModelID ,itemID查找图片路径 /// </summary> /// <param name="modelID"></param> /// <param name="itemID"></param> /// <returns></returns> private string GetPicPathByModelID(int modelID, int itemID) { B_Model bm = new B_Model(); M_ModelInfo modelinfo = bm.GetModelById(modelID); B_ModelField bmf = new B_ModelField(); M_ModelField mf = bmf.GetFieldNameByMID(modelID); string fieldName = ""; if (mf != null && mf.ModelID > 0) { fieldName = mf.FieldName; } if (modelinfo != null && modelinfo.ModelID > 0) { //DataSet ds = cll.PRoContentChilds(modelinfo.TableName, itemID); //if (ds != null && ds.Tables[0].Rows.Count > 0) //{ // DataRow dr = ds.Tables[0].Rows[0]; // foreach (DataColumn item in ds.Tables[0].Columns) // { // if (item.ToString().Trim().Equals(fieldName)) // { // return dr[item].ToString(); // } // } //} } return(""); }
protected void SetTemplate(object sender, EventArgs e) { B_Model bll1 = new B_Model(); int ModelID = DataConverter.CLng(this.ViewState["ModelID"].ToString()); bll1.UpdateTemplate(this.TxtTemplate.Text, ModelID); function.WriteSuccessMsg("设定模板成功", "UserModelField.aspx?ModelID=" + ModelID.ToString()); }
protected void Repeater1_ItemCommand(object sender, RepeaterCommandEventArgs e) { if (e.CommandName == "UpMove") { int Id = DataConverter.CLng(e.CommandArgument); M_ModelField Fieldinfo = this.bll.GetModelByID(Id); if (Fieldinfo.OrderID != this.bll.GetMinOrder(Fieldinfo.ModelID)) { M_ModelField FieldPre = this.bll.GetPreField(Fieldinfo.ModelID, Fieldinfo.OrderID); int CurrOrder = Fieldinfo.OrderID; Fieldinfo.OrderID = FieldPre.OrderID; FieldPre.OrderID = CurrOrder; this.bll.UpdateOrder(Fieldinfo); this.bll.UpdateOrder(FieldPre); } } if (e.CommandName == "DownMove") { int Id = DataConverter.CLng(e.CommandArgument); M_ModelField Fieldinfo = this.bll.GetModelByID(Id); if (Fieldinfo.OrderID != this.bll.GetMaxOrder(Fieldinfo.ModelID)) { M_ModelField FieldPre = this.bll.GetNextField(Fieldinfo.ModelID, Fieldinfo.OrderID); int CurrOrder = Fieldinfo.OrderID; Fieldinfo.OrderID = FieldPre.OrderID; FieldPre.OrderID = CurrOrder; this.bll.UpdateOrder(Fieldinfo); this.bll.UpdateOrder(FieldPre); } } if (e.CommandName == "Delete") { int Id = DataConverter.CLng(e.CommandArgument); int ModelID; ModelID = DataConverter.CLng(this.ViewState["ModelID"].ToString()); B_Model bll1 = new B_Model(); string tablename = bll1.GetModelById(ModelID).TableName; M_ModelField fieldinfo = this.bll.GetModelByID(Id); if (fieldinfo.FieldType == "PicType" || fieldinfo.FieldType == "FileType") { string[] Setting = fieldinfo.Content.Split(new char[] { ',' }); bool chk = DataConverter.CBool(Setting[0].Split(new char[] { '=' })[1]); string fieldname = Setting[1].Split(new char[] { '=' })[1]; if (chk && fieldname != "") { this.bll.DelSubField(tablename, fieldname); } } this.bll.Del(Id, tablename); } DataBindList(); }
public void DataBindList() { B_Model bll1 = new B_Model(); int ModelID = DataConverter.CLng(this.ViewState["ModelID"].ToString()); M_ModelInfo modeli = bll1.GetModelById(ModelID); this.LModelName.Text = modeli.ModelName; this.TxtTemplate.Text = modeli.ContentModule; this.RepSystemModel.DataSource = bll.GetSysUserField(); this.RepSystemModel.DataBind(); this.RepModelField.DataSource = bll.GetModelFieldList(ModelID); this.RepModelField.DataBind(); }
//取出节点绑定模型的图标,需要优化,能否一起取出 private string GetIconPath(string ContentModel) { B_Model bmod = new B_Model(); string ItemIcon = "fa fa-globe"; if (!string.IsNullOrEmpty(ContentModel)) { try { int ModelID = Convert.ToInt32(ContentModel.Split(',')[0]); ItemIcon = bmod.GetWhere("ItemIcon", " And ModelID=" + ModelID, "").Rows[0][0].ToString(); //ZL_Model } catch { } } return(ItemIcon); }
private static void BeginCollContent() { B_Model modBll = new B_Model(); B_ModelField fdBll = new B_ModelField(); B_CollectionItem itemBll = new B_CollectionItem(); foreach (M_CollectionItem item in workList) { if (B_Coll_Worker.work_switcher == false) { break; } if (string.IsNullOrEmpty(item.LinkList)) { WriteLog("项目[" + item.ItemName + "]取消,原因:未指定需要采集的列表URL,LinkList"); continue; } if (string.IsNullOrEmpty(item.InfoPageSettings)) { WriteLog("项目[" + item.ItemName + "]取消,原因:未指定字段采集规则"); continue; } if (string.IsNullOrEmpty(item.CollUrl)) { WriteLog("项目[" + item.ItemName + "]取消,原因:未指定采集来源网址CollUrl"); continue; } M_ModelInfo modMod = modBll.SelReturnModel(item.ModeID); DataTable fieldDT = fdBll.SelByModelID(item.ModeID); foreach (string url in item.LinkList.Split('\n')) { if (B_Coll_Worker.work_switcher == false) { WriteLog("采集项目[" + item.ItemName + "]已停止", ERROR); break; } if (string.IsNullOrEmpty(url)) { continue; } WriteLog("正在采集[" + item.ItemName + "]的目标网址[" + url + "]"); CollectByUrl(url, item, modMod, fieldDT); } DBCenter.UpdateSQL(item.TbName, "Switch=2", "CItem_ID=" + item.CItem_ID); } WriteLog("采集完成,共采集到[" + work_count + "]篇内容", 99); work_switcher = false; work_count = 0; workList.Clear(); }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(base.Request.QueryString["ItemID"])) { int ItemID = DataConverter.CLng(base.Request.QueryString["ItemID"]); B_Content bcontent = new B_Content(); B_Model bmode = new B_Model(); B_Node bnode = new B_Node(); M_CommonData ItemInfo = bcontent.GetCommonData(ItemID); if (ItemInfo.IsNull) { Response.Write("[产生错误的可能原因:您访问的内容信息不存在!]"); } M_ModelInfo modelinfo = bmode.GetModelById(ItemInfo.ModelID); string TempNode = bnode.GetModelTemplate(ItemInfo.NodeID, ItemInfo.ModelID); string TempContent = ItemInfo.Template; string TemplateDir = modelinfo.ContentModule; if (!string.IsNullOrEmpty(TempContent)) { TemplateDir = TempContent; } else { if (!string.IsNullOrEmpty(TempNode)) { TemplateDir = TempNode; } } if (string.IsNullOrEmpty(TemplateDir)) { Response.Write("[产生错误的可能原因:该内容所属模型未指定模板!]"); } else { TemplateDir = base.Request.PhysicalApplicationPath + SiteConfig.SiteOption.TemplateDir + TemplateDir; TemplateDir = TemplateDir.Replace("/", @"\"); string ContentHtml = this.bll.CreateHtml(FileSystemObject.ReadFile(TemplateDir), 0, ItemID); Response.Write(ContentHtml); } } else { Response.Write("[产生错误的可能原因:您访问的内容信息不存在!]"); } }
protected void Save_Btn_Click(object sender, EventArgs e) { M_UserInfo mu = buser.GetLogin(); M_Store_Info storeMod = storeBll.SelReturnModel(mu.SiteID); M_WX_APPID appMod = appBll.SelModelByStoreId(storeMod.ID); if (appMod == null) { appMod = new M_WX_APPID(); } appMod.IsDefault = storeMod.ID; appMod.Alias = storeMod.Title; appMod.APPID = AppID_T.Text.Trim(); if (QCode_UP.HasFile) { QCode_UP.SaveFile(); appMod.QRCode = QCode_UP.FileUrl.Replace("/UploadFiles/", "");; } appMod.WxNo = WXNo_T.Text.Trim(); appMod.Secret = Secret_T.Text.Trim(); appMod.OrginID = OrginID.Text.Trim(); appMod.Pay_AccountID = Pay_Account.Text.Trim(); if (appMod.ID > 0) { appBll.UpdateByID(appMod); } else { appMod.ID = appBll.Insert(appMod); M_ModelInfo modInfo = new B_Model().SelReturnModel(50); B_Content conBll = new B_Content(); M_CommonData conMod = new M_CommonData(); conMod.NodeID = 5; conMod.ModelID = modInfo.ModelID; conMod.Title = appMod.Alias; conMod.Inputer = mu.UserName; conMod.ItemID = appMod.ID; conMod.TableName = modInfo.TableName; conBll.insert(conMod); } function.WriteSuccessMsg("操作成功"); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null && !(Request.QueryString["id"].Equals(""))) { int productId = DataConverter.CLng(Request.QueryString["id"]); if (productId == 0) { function.WriteErrMsg("参数错误"); } else { bll = new B_Product(); node = new B_Node(); pinfo = bll.GetproductByid(productId); if (pinfo != null) { int nodeId = pinfo.Nodeid; M_Node m_node = node.GetNodeXML(nodeId); NodeName.Text = m_node.NodeName; AddUser_L.Text = pinfo.AddUser; shopState.Text = pinfo.Sales == 1 ? "销售中" : "停售状态"; codes.Text = pinfo.ProClass == 1 ? "正常销售" : "特价处理"; codes.Text += pinfo.Isnew == 1 ? "|新品" : ""; codes.Text += pinfo.Ishot == 1 ? "|热销" : ""; codes.Text += pinfo.Isbest == 1 ? "|精品" : ""; ProID_L.Text = pinfo.ID.ToString(); title_T.Text = pinfo.Proname; lblCountHits.Text = pinfo.AllClickNum.ToString(); ckPrice.Text = pinfo.ShiPrice.ToString(); nowPrice.Text = pinfo.LinPrice.ToString(); B_Model m_model = new B_Model(); M_ModelInfo MM = m_model.GetModelById(pinfo.Nodeid); string bar = " <span><a href=\"ProductManage.aspx?NodeID=" + nodeId + "\">" + node.GetNodeXML(nodeId).NodeName + "</a></span>"; Call.SetBreadCrumb(Master, "<li>商城管理</li><li><a href='ProductManage.aspx'>商品管理</a></li><li>" + bar + "</li>" + "<div class='pull-right hidden-xs'><span onclick=\"opentitle('../Content/EditNode.aspx?NodeID=" + nodeId + "','配置本节点');\" class='fa fa-cog' title='配置本节点' style='cursor:pointer;margin-left:5px;'></span></div>"); } } } }
//互动模型需要扩展 public void RestoreByName(string name) { B_Model modelBll = new B_Model(); B_ModelField fieldBll = new B_ModelField(); B_Pub pubBll = new B_Pub(); string ppath = SafeSC.PathDeal(pdir + name); if (!File.Exists(ppath)) { function.WriteErrMsg("备份文件[" + name + "]不存在"); } //清空数据 modelBll.DeleteAll(); foreach (string tbname in tbnames) { SqlHelper.ExecuteSql("TRUNCATE TABLE " + tbname); } SqlHelper.ExecuteSql("TRUNCATE TABLE ZL_CommonModel"); //开始恢复 DataSet ds = new DataSet(); ds.ReadXml(ppath); //批量导入部分数据 SqlHelper.Insert_Bat(ds.Tables["ZL_Node"], SqlHelper.ConnectionString); if (ds.Tables["ZL_Pub"] != null) { SqlHelper.Insert_Bat(ds.Tables["ZL_Pub"], SqlHelper.ConnectionString); } if (ds.Tables["ZL_Node_ModelTemplate"] != null) { SqlHelper.Insert_Bat(ds.Tables["ZL_Node_ModelTemplate"], SqlHelper.ConnectionString); } if (ds.Tables["ZL_UserPromotions"] != null) { SqlHelper.Insert_Bat(ds.Tables["ZL_UserPromotions"], SqlHelper.ConnectionString); } if (ds.Tables["ZL_NodeRole"] != null) { SqlHelper.Insert_Bat(ds.Tables["ZL_NodeRole"], SqlHelper.ConnectionString); } //恢复模型数据与其对应的表 DataTable modelDT = ds.Tables["ZL_Model"]; DataTable fieldDT = ds.Tables["ZL_ModelField"]; DataTable pubDT = ds.Tables["ZL_Pub"]; foreach (DataRow dr in modelDT.Rows) { M_ModelInfo modelMod = new M_ModelInfo().GetModelFromReader(dr); ZoomLa.SQLDAL.DBHelper.Table_Del(modelMod.TableName); switch (modelMod.ModelType.ToString()) { case "3": //用户模型和黄页申请模型 modelBll.AddUserModel(modelMod); break; case "6": //店铺申请模型 modelBll.AddStoreModel(modelMod); break; case "7": //互动模型 if (pubDT == null) { break; } M_Pub pubmodel = new M_Pub(); pubmodel.PubName = modelMod.ModelName; pubmodel.PubTableName = modelMod.TableName; DataRow[] drs = pubDT.Select("PubModelID=" + modelMod.ModelID); pubmodel.PubType = drs.Length > 0 ? DataConvert.CLng(drs[0]["PubType"]) : 0; pubBll.CreateModelInfo(pubmodel); break; case "8": //功能模型 modelBll.AddFunModel(modelMod); break; default: //内容模型、商城模型、黄页内容模型、店铺商品模型 modelBll.AddModel(modelMod); break; } } //恢复字段 if (fieldDT != null && fieldDT.Rows.Count > 0) { fieldDT.DefaultView.RowFilter = "sys_type ='false'"; foreach (DataRow dr in fieldDT.DefaultView.ToTable().Rows) { int modelID = DataConvert.CLng(dr["ModelID"]); if (modelID < 1) { continue; } DataRow[] drs = modelDT.Select("ModelID='" + modelID + "'"); //OA不处理,未找到不处理 if (drs.Length < 1 || drs[0]["ModelType"].ToString().Equals("12")) { continue; } M_ModelInfo modelMod = new M_ModelInfo().GetModelFromReader(drs[0]); M_ModelField fieldMod = new M_ModelField().GetModelFromReader(dr); //Pub表会报重复 if (fieldBll.IsExists(modelMod.ModelID, fieldMod.FieldName)) { continue; } if (DBCenter.DB.Table_Exist(modelMod.TableName)) //互动表可能未创建,忽略 { fieldBll.AddModelField(modelMod, fieldMod); } } SqlHelper.ExecuteSql("TRUNCATE TABLE ZL_ModelField"); SqlHelper.Insert_Bat(fieldDT, SqlHelper.ConnectionString); } }
public void PageContent() { if (ItemID < 1) { RepToClient("[产生错误的可能原因:您访问的内容信息不存在!访问规则:PageContent?ItemID=信息ID]"); return; } B_Model bmode = new B_Model(); B_Node bnode = new B_Node(); M_CommonData ItemInfo = conBll.GetCommonData(ItemID); if (ItemInfo.IsNull) { RepToClient("[产生错误的可能原因:内容信息不存在或未开放!]"); return; } M_ModelInfo modelinfo = bmode.GetModelById(ItemInfo.ModelID); M_Templata Nodeinfo = tll.Getbyid(ItemInfo.NodeID); string TemplateDir = GetTempPath(ItemInfo, Nodeinfo, pageID); if (string.IsNullOrEmpty(TemplateDir)) { RepToClient("[产生错误的可能原因:该内容所属模型未指定模板!]"); return; } else { int Cpage = 1; if (string.IsNullOrEmpty(base.Request.QueryString["p"])) { Cpage = 1; } else { Cpage = DataConverter.CLng(base.Request.QueryString["p"]); } string ContentHtml = ""; try { ContentHtml = FileSystemObject.ReadFile(TemplateDir); } catch { RepToClient("[产生错误的可能原因:该内容所属模型未指定模板!]"); return; } ContentHtml = this.createBll.CreateHtml(ContentHtml, Cpage, ItemID, 0); /* --------------------判断是否分页 并做处理------------------------------------------------*/ if (!string.IsNullOrEmpty(ContentHtml)) { string infoContent = ""; //进行处理的内容字段 string pagelabel = ""; string infotmp = ""; #region 分页符分页 string pattern = @"{\#PageCode}([\s\S])*?{\/\#PageCode}"; //查找要分页的内容 if (Regex.IsMatch(ContentHtml, pattern, RegexOptions.IgnoreCase)) { infoContent = Regex.Match(ContentHtml, pattern, RegexOptions.IgnoreCase).Value; infotmp = infoContent; infoContent = infoContent.Replace("{#PageCode}", "").Replace("{/#PageCode}", ""); //查找分页标签 //bool flag = false; bool isPage = false; string pattern1 = @"{ZL\.Page([\s\S])*?\/}"; if (Regex.IsMatch(ContentHtml, pattern1, RegexOptions.IgnoreCase)) { pagelabel = Regex.Match(ContentHtml, pattern1, RegexOptions.IgnoreCase).Value; isPage = true; } if (isPage) { if (string.IsNullOrEmpty(infoContent)) //没有设定要分页的字段内容 { ContentHtml = ContentHtml.Replace(pagelabel, ""); } else //进行内容分页处理 { //取分页标签处理结果 返回字符串数组 根据数组元素个数生成几页 string ilbl = pagelabel.Replace("{ZL.Page ", "").Replace("/}", "").Replace(" ", ","); string lblContent = ""; IList <string> ContentArr = new List <string>(); if (string.IsNullOrEmpty(ilbl)) { lblContent = "{loop}<a href=\"{$pageurl/}\">{$pageid/}</a>$$$<b>[{$pageid/}]</b>{/loop}"; //默认格式的分页导航 ContentArr = this.createBll.GetContentPage(infoContent); } else { string[] paArr = ilbl.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (paArr.Length == 0) { lblContent = "{loop}<a href=\"{$pageurl/}\">{$pageid/}</a>$$$<b>[{$pageid/}]</b>{/loop}"; //默认格式的分页导航 ContentArr = this.createBll.GetContentPage(infoContent); } else { string lblname = paArr[0].Split(new char[] { '=' })[1].Replace("\"", ""); B_Label blbl = new B_Label(); lblContent = blbl.GetLabelXML(lblname).Content; if (string.IsNullOrEmpty(lblContent)) { lblContent = "{loop}<a href=\"{$pageurl/}\">{$pageid/}</a>$$$<b>[{$pageid/}]</b>{/loop}"; //默认格式的分页导航 } ContentArr = this.createBll.GetContentPage(infoContent); } } if (ContentArr.Count > 0) //存在分页数据 { ContentHtml = ContentHtml.Replace(infotmp, ContentArr[CPage - 1]); ContentHtml = ContentHtml.Replace(pagelabel, this.createBll.GetPage(lblContent, ItemID, CPage, ContentArr.Count, ContentArr.Count)); } else { ContentHtml = ContentHtml.Replace(infotmp, infoContent); ContentHtml = ContentHtml.Replace(pagelabel, ""); } } } else //没有分页标签 { //如果设定了分页内容字段 将该字段内容的分页标志清除 if (!string.IsNullOrEmpty(infoContent)) { ContentHtml = ContentHtml.Replace(infotmp, infoContent); } } } #endregion pattern = @"{\#Content}([\s\S])*?{\/\#Content}"; //查找要分页的内容 if (Regex.IsMatch(ContentHtml, pattern, RegexOptions.IgnoreCase)) { infoContent = Regex.Match(ContentHtml, pattern, RegexOptions.IgnoreCase).Value; infotmp = infoContent; infoContent = infoContent.Replace("{#Content}", "").Replace("{/#Content}", ""); //查找分页标签 //bool flag = false; bool isPage = false; string pattern1 = @"{ZL\.Page([\s\S])*?\/}"; if (Regex.IsMatch(ContentHtml, pattern1, RegexOptions.IgnoreCase)) { pagelabel = Regex.Match(ContentHtml, pattern1, RegexOptions.IgnoreCase).Value; isPage = true; } if (isPage) { if (string.IsNullOrEmpty(infoContent)) //没有设定要分页的字段内容 { ContentHtml = ContentHtml.Replace(pagelabel, ""); } else //进行内容分页处理 { //取分页标签处理结果 返回字符串数组 根据数组元素个数生成几页 string ilbl = pagelabel.Replace("{ZL.Page ", "").Replace("/}", "").Replace(" ", ","); string lblContent = ""; int NumPerPage = 500; IList <string> ContentArr = new List <string>(); if (string.IsNullOrEmpty(ilbl)) { lblContent = "{loop}<a href=\"{$pageurl/}\">{$pageid/}</a>$$$<b>[{$pageid/}]</b>{/loop}"; //默认格式的分页导航 ContentArr = this.createBll.GetContentPage(infoContent, NumPerPage); } else { string[] paArr = ilbl.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (paArr.Length == 0) { lblContent = "{loop}<a href=\"{$pageurl/}\">{$pageid/}</a>$$$<b>[{$pageid/}]</b>{/loop}"; //默认格式的分页导航 ContentArr = this.createBll.GetContentPage(infoContent, NumPerPage); } else { string lblname = paArr[0].Split(new char[] { '=' })[1].Replace("\"", ""); if (paArr.Length > 1) { NumPerPage = DataConverter.CLng(paArr[1].Split(new char[] { '=' })[1].Replace("\"", "")); } B_Label blbl = new B_Label(); lblContent = blbl.GetLabelXML(lblname).Content; if (string.IsNullOrEmpty(lblContent)) { lblContent = "{loop}<a href=\"{$pageurl/}\">{$pageid/}</a>$$$<b>[{$pageid/}]</b>{/loop}"; //默认格式的分页导航 } ContentArr = this.createBll.GetContentPage(infoContent, NumPerPage); } } if (ContentArr.Count > 0) //存在分页数据 { ContentHtml = ContentHtml.Replace(infotmp, ContentArr[Cpage - 1]); ContentHtml = ContentHtml.Replace(pagelabel, this.createBll.GetPage(lblContent, ItemID, CPage, ContentArr.Count, NumPerPage)); } else { ContentHtml = ContentHtml.Replace(infotmp, infoContent); ContentHtml = ContentHtml.Replace(pagelabel, ""); } } } else //没有分页标签 { //如果设定了分页内容字段 将该字段内容的分页标志清除 if (!string.IsNullOrEmpty(infoContent)) { ContentHtml = ContentHtml.Replace(infotmp, infoContent); } } } } string patterns = @"{ZL\.Page([\s\S])*?\/}"; string pagelabels = Regex.Match(ContentHtml, patterns, RegexOptions.IgnoreCase).Value; if (pagelabels != "") { ContentHtml = ContentHtml.Replace(pagelabels, ""); } /*--------------------- 分页内容处理结束-------------------------------------------------------------------------*/ Response.Write(ContentHtml); } }
//数据导入 public bool ImportProducts(DataTable dt, int ModelID, int NodeID) { B_ModelField b_ModelField = new B_ModelField(); DataTable dtModelField = b_ModelField.GetModelFieldList(ModelID); //建立从表存放当前信息 DataTable table = new DataTable(); table.Columns.Add(new DataColumn("FieldName", typeof(string))); table.Columns.Add(new DataColumn("FieldType", typeof(string))); table.Columns.Add(new DataColumn("FieldValue", typeof(string))); table.Columns.Add(new DataColumn("ShopmodelID", typeof(string))); table.Columns.Add(new DataColumn("FieldAlias", typeof(string))); for (int i = 0; i < dt.Rows.Count; i++) { if (dtModelField != null && dtModelField.Rows.Count > 0) { foreach (DataRow dr in dtModelField.Rows) { DataRow row = table.NewRow(); row[0] = dr["FieldName"].ToString(); row[1] = dr["FieldType"].ToString(); row[4] = dr["FieldAlias"].ToString(); try { row[2] = dt.Rows[i][row[4].ToString()]; } catch { return(false); } table.Rows.Add(row); } } //基础表内容 B_Model modBll = new B_Model(); M_ModelInfo modMod = modBll.SelReturnModel(ModelID); //主表内容 M_Product m_Product = new M_Product(); m_Product.ModelID = ModelID; m_Product.Nodeid = NodeID; m_Product.TableName = modMod.TableName; m_Product.ProCode = dt.Rows[i]["商品编号"].ToString(); m_Product.BarCode = dt.Rows[i]["条形码"].ToString(); m_Product.Proname = dt.Rows[i]["商品名称"].ToString(); m_Product.Kayword = dt.Rows[i]["关键字"].ToString(); m_Product.ProUnit = dt.Rows[i]["商品单位"].ToString(); try { m_Product.Weight = Convert.ToInt32(dt.Rows[i]["商品重量"].ToString() == "" ? 0 : dt.Rows[i]["商品重量"]); } catch { throw new Exception("第" + (i + 1) + "行,字段[商品重量]格式不正确"); } m_Product.ProClass = 1; m_Product.Sales = Convert.ToInt32(dt.Rows[i]["销售状态(1)"].ToString() == "1" ? 1 : 0); m_Product.Istrue = Convert.ToInt32(dt.Rows[i]["属性设置(1)"].ToString() == "1" ? 1 : 0); try { m_Product.AllClickNum = Convert.ToInt32(dt.Rows[i]["点击数"].ToString() == "" ? 0 : dt.Rows[i]["点击数"]); } catch { throw new Exception("第" + (i + 1) + "行,字段[点击数]格式不正确"); } try { m_Product.UpdateTime = Convert.ToDateTime(dt.Rows[i]["更新时间"]); } catch { throw new Exception("第" + (i + 1) + "行,字段[更新时间]格式不正确"); } m_Product.ModeTemplate = ""; ///22222222222222222222 m_Product.Proinfo = dt.Rows[i]["商品简介"].ToString(); m_Product.Procontent = dt.Rows[i]["详细介绍"].ToString(); m_Product.Clearimg = dt.Rows[i]["商品清晰图"].ToString(); m_Product.Thumbnails = dt.Rows[i]["商品缩略图"].ToString(); ///33333333333333333333 m_Product.Producer = dt.Rows[i]["生产商"].ToString(); m_Product.Brand = dt.Rows[i]["品牌/商标"].ToString(); m_Product.Allowed = Convert.ToInt32(dt.Rows[i]["缺货时允许购买(0)"].ToString() == "0" ? 0 : 1); try { m_Product.Quota = Convert.ToInt32(dt.Rows[i]["限购数量"].ToString() == "" ? 0 : dt.Rows[i]["限购数量"]); } catch { throw new Exception("第" + (i + 1) + "行,字段[限购数量]格式不正确"); } try { m_Product.DownQuota = Convert.ToInt32(dt.Rows[i]["最低购买数量"].ToString() == "" ? 0 : dt.Rows[i]["最低购买数量"]); } catch { throw new Exception("第" + (i + 1) + "行,字段[最低购买数量]格式不正确"); } m_Product.Stock = 0;//库存数量 try { m_Product.ShiPrice = Convert.ToDouble(dt.Rows[i]["市场参考价"].ToString() == "" ? 0 : dt.Rows[i]["市场参考价"]); } catch { throw new Exception("第" + (i + 1) + "行,字段[市场参考价]格式不正确"); } try { m_Product.LinPrice = Convert.ToDouble(dt.Rows[i]["当前零售价"].ToString() == "" ? 0 : dt.Rows[i]["当前零售价"]); } catch { throw new Exception("第" + (i + 1) + "行,字段[当前零售价]格式不正确"); } try { m_Product.AddTime = DateTime.Parse(dt.Rows[i]["创建时间"].ToString()); } catch (Exception) { throw new Exception("第" + (i + 1) + "行,字段[创建时间]格式不正确"); } try { m_Product.StockDown = 0; } catch { throw new Exception("第" + (i + 1) + "行,字段[库存报警下限]格式不正确"); } try { m_Product.Rateset = 1; } catch { throw new Exception("第" + (i + 1) + "行,字段[税率设置]格式不正确"); } try { m_Product.Rate = 0; } catch { throw new Exception("第" + (i + 1) + "行,字段[商品税率]格式不正确"); } try { m_Product.Dengji = 3; } catch { throw new Exception("第" + (i + 1) + "行,字段[商品推荐等级]格式不正确"); } try { m_Product.ShiPrice = Convert.ToDouble(dt.Rows[i]["市场参考价"].ToString() == "" ? 0 : dt.Rows[i]["市场参考价"]); } catch { throw new Exception("第" + (i + 1) + "行,字段[市场参考价]格式不正确"); } try { m_Product.LinPrice = Convert.ToDouble(dt.Rows[i]["当前零售价"].ToString() == "" ? 0 : dt.Rows[i]["当前零售价"]); } catch { throw new Exception("第" + (i + 1) + "行,字段[当前零售价]格式不正确"); } //m_Product.UserPrice = dt.Rows[i]["会员组价格"].ToString(); m_Product.UserPrice = "0"; try { m_Product.Recommend = 0; } catch { throw new Exception("第" + (i + 1) + "行,字段[打折优惠率]格式不正确"); } try { m_Product.PointVal = 0; } catch { throw new Exception("第" + (i + 1) + "行,字段[积分价格]格式不正确"); } m_Product.Wholesales = 0;//允许批发 try { m_Product.Wholesaleone = 1; } catch { throw new Exception("第" + (i + 1) + "行,字段[允许单独销售]格式不正确"); } try { m_Product.Largess = 0; } catch { throw new Exception("第" + (i + 1) + "行,字段[设置为礼品]格式不正确"); } ///55555555555555555555 try { m_Product.IntegralNum = 0; } catch { throw new Exception("第" + (i + 1) + "行,字段[购物积分]格式不正确"); } Add(table, m_Product); table.Rows.Clear();//清除子表中的数据 } return(true); }