private void RptBind(string _strWhere) { this.txtKeywords.Text = this.keywords; BLL.user_groups bll = new BLL.user_groups(); this.rptList.DataSource = bll.GetList(0, _strWhere, "grade asc,id asc"); this.rptList.DataBind(); }
private void RptBind(string _strWhere) { this.txtKeywords.Text = this.keywords; BLL.user_groups bll = new BLL.user_groups(); this.rptList.DataSource = bll.GetList(0, _strWhere, "grade asc,id asc"); this.rptList.DataBind(); }
private void TreeBind(string strWhere) { BLL.user_groups bll = new BLL.user_groups(); DataTable dt = bll.GetList(0, strWhere, "grade asc,id asc").Tables[0]; this.cblGroupId.Items.Clear(); foreach (DataRow dr in dt.Rows) { this.cblGroupId.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } }
private void GroupBind(string strWhere) { BLL.user_groups bll = new BLL.user_groups(); DataSet ds = bll.GetList(0, strWhere, "grade asc,id desc"); if (ds.Tables[0].Rows.Count > 0) { //this.rptPrice.DataSource = ds; //this.rptPrice.DataBind(); } }
private void TreeBind(string strWhere) { BLL.user_groups bll = new BLL.user_groups(); DataTable dt = bll.GetList(0, strWhere, "grade asc,id asc").Tables[0]; this.cblGroupId.Items.Clear(); foreach (DataRow dr in dt.Rows) { this.cblGroupId.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } }
private void TreeBind(string strWhere) { BLL.user_groups bll = new BLL.user_groups(); DataTable dt = bll.GetList(0, strWhere, "id desc").Tables[0]; this.ddlGroupId.Items.Clear(); this.ddlGroupId.Items.Add(new ListItem("所有会员组", "")); //this.ddlGroupId.Items.Add(new ListItem("新用户", "0")); foreach (DataRow dr in dt.Rows) { this.ddlGroupId.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } }
private void GroupBind(string strWhere) { //检查网站是否开启会员功能 if (siteConfig.memberstatus == 0) { return; } //检查该频道是否开启会员组价格 Model.channel model = new BLL.channel().GetModel(this.channel_id); if (model == null || model.is_group_price == 0) { return; } BLL.user_groups bll = new BLL.user_groups(); DataSet ds = bll.GetList(0, strWhere, "grade asc,id desc"); }
private void GroupBind(string strWhere) { //检查网站是否开启会员功能 if (sysConfig.memberstatus == 0) { return; } //检查该频道是否开启会员组价格 if (channelModel.is_spec == 0) { return; } BLL.user_groups bll = new BLL.user_groups(); DataSet ds = bll.GetList(0, strWhere, "grade asc,id desc"); if (ds.Tables[0].Rows.Count > 0) { this.rptPrice.DataSource = ds; this.rptPrice.DataBind(); } }
private void GroupBind(string strWhere) { //檢查網站是否開啟會員功能 if (siteConfig.memberstatus == 0) { return; } //檢查該頻道是否開啟會員組價格 Model.channel model = new BLL.channel().GetModel(this.channel_id); if (model == null || model.is_spec == 0) { return; } BLL.user_groups bll = new BLL.user_groups(); DataSet ds = bll.GetList(0, strWhere, "grade asc,id desc"); if (ds.Tables[0].Rows.Count > 0) { this.rptPrice.DataSource = ds; this.rptPrice.DataBind(); } }
private void RptBind(string _strWhere, string _orderby) { BLL.user_groups bll = new BLL.user_groups(); this.rptList.DataSource = bll.GetList(0, _strWhere, _orderby); this.rptList.DataBind(); }
private void GroupBind(string strWhere) { //检查网站是否开启会员功能 if (siteConfig.memberstatus == 0) { return; } //检查该频道是否开启会员组价格 Model.channel model = new BLL.channel().GetModel(this.channel_id); if (model == null || model.is_group_price == 0) { return; } BLL.user_groups bll = new BLL.user_groups(); DataSet ds = bll.GetList(0, strWhere, "grade asc,id desc"); if (ds.Tables[0].Rows.Count > 0) { this.rptPrice.DataSource = ds; this.rptPrice.DataBind(); } }
private void GroupBind(string strWhere) { BLL.user_groups bll = new BLL.user_groups(); DataSet ds = bll.GetList(0, strWhere, "grade asc,id desc"); if (ds.Tables[0].Rows.Count > 0) { this.rptPrice.DataSource = ds; this.rptPrice.DataBind(); } }
private bool DoEdit(int _id) { bool result = false; BLL.article bll = new BLL.article(); Model.article model = bll.GetModel(_id); decimal sell_price = 0; decimal standard_price = 0; decimal standard_group_price = 0; decimal action_price = 0; model.channel_id = this.channel_id; model.category_id = Utils.StrToInt(ddlCategoryId.SelectedValue, 0); model.call_index = txtCallIndex.Text.Trim(); model.title = txtTitle.Text.Trim(); model.link_url = txtLinkUrl.Text.Trim(); model.img_url = txtImgUrl.Text; model.seo_title = txtSeoTitle.Text.Trim(); model.seo_keywords = txtSeoKeywords.Text.Trim(); model.seo_description = txtSeoDescription.Text.Trim(); //内容摘要提取内容前255个字符 if (string.IsNullOrEmpty(txtZhaiyao.Text.Trim())) { model.zhaiyao = Utils.DropHTML(txtContent.Value, 255); } else { model.zhaiyao = Utils.DropHTML(txtZhaiyao.Text, 255); } model.content = txtContent.Value; model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99); model.click = int.Parse(txtClick.Text.Trim()); model.status = Utils.StrToInt(rblStatus.SelectedValue, 0); model.is_msg = 0; model.is_top = 0; model.is_red = 0; model.is_hot = 0; model.is_slide = 0; model.is_put = 1; if (isPut.Items[0].Selected) { model.is_put = 0; } if (cblItem.Items[0].Selected == true) { model.is_msg = 1; } if (cblItem.Items[1].Selected == true) { model.is_top = 1; } if (cblItem.Items[2].Selected == true) { model.is_red = 1; } if (cblItem.Items[3].Selected == true) { model.is_hot = 1; } if (cblItem.Items[4].Selected == true) { model.is_slide = 1; } model.add_time = Utils.StrToDateTime(txtAddTime.Text.Trim()); model.update_time = DateTime.Now; model.fields = SetFieldValues(this.channel_id); //扩展字段赋值 sell_price = Convert.ToDecimal(model.fields["sell_price"]); #region 保存相册==================== //检查是否有自定义图片 if (txtImgUrl.Text.Trim() == "") { model.img_url = hidFocusPhoto.Value; } if (model.albums != null) { model.albums.Clear(); } string[] albumArr = Request.Form.GetValues("hid_photo_name"); string[] remarkArr = Request.Form.GetValues("hid_photo_remark"); if (albumArr != null) { List<Model.article_albums> ls = new List<Model.article_albums>(); for (int i = 0; i < albumArr.Length; i++) { string[] imgArr = albumArr[i].Split('|'); int img_id = Utils.StrToInt(imgArr[0], 0); if (imgArr.Length == 3) { if (!string.IsNullOrEmpty(remarkArr[i])) { ls.Add(new Model.article_albums { id = img_id, article_id = _id, original_path = imgArr[1], thumb_path = imgArr[2], remark = remarkArr[i] }); } else { ls.Add(new Model.article_albums { id = img_id, article_id = _id, original_path = imgArr[1], thumb_path = imgArr[2] }); } } } model.albums = ls; } #endregion #region 保存附件==================== if (model.attach != null) { model.attach.Clear(); } string[] attachIdArr = Request.Form.GetValues("hid_attach_id"); string[] attachFileNameArr = Request.Form.GetValues("hid_attach_filename"); string[] attachFilePathArr = Request.Form.GetValues("hid_attach_filepath"); string[] attachFileSizeArr = Request.Form.GetValues("hid_attach_filesize"); string[] attachPointArr = Request.Form.GetValues("txt_attach_point"); if (attachIdArr != null && attachFileNameArr != null && attachFilePathArr != null && attachFileSizeArr != null && attachPointArr != null && attachIdArr.Length > 0 && attachFileNameArr.Length > 0 && attachFilePathArr.Length > 0 && attachFileSizeArr.Length > 0 && attachPointArr.Length > 0) { List<Model.article_attach> ls = new List<Model.article_attach>(); for (int i = 0; i < attachFileNameArr.Length; i++) { int attachId = Utils.StrToInt(attachIdArr[i], 0); int fileSize = Utils.StrToInt(attachFileSizeArr[i], 0); string fileExt = Utils.GetFileExt(attachFilePathArr[i]); int _point = Utils.StrToInt(attachPointArr[i], 0); ls.Add(new Model.article_attach { id = attachId, article_id = _id, file_name = attachFileNameArr[i], file_path = attachFilePathArr[i], file_size = fileSize, file_ext = fileExt, point = _point, }); } model.attach = ls; } #endregion #region 保存会员组价格============== List<Model.user_group_price> priceList = new List<Model.user_group_price>(); for (int i = 0; i < rptPrice.Items.Count; i++) { int hidPriceId = 0; if (!string.IsNullOrEmpty(((HiddenField)rptPrice.Items[i].FindControl("hidePriceId")).Value)) { hidPriceId = Convert.ToInt32(((HiddenField)rptPrice.Items[i].FindControl("hidePriceId")).Value); } int hidGroupId = Convert.ToInt32(((HiddenField)rptPrice.Items[i].FindControl("hideGroupId")).Value); decimal _price = Convert.ToDecimal(((TextBox)rptPrice.Items[i].FindControl("txtGroupPrice")).Text.Trim()); priceList.Add(new Model.user_group_price { id = hidPriceId, article_id = _id, group_id = hidGroupId, price = _price }); } model.group_price = priceList; #endregion if (bll.Update(model)) { #region 商品相关 if (channel_name == "goods") { //规格价格 BLL.standard_price bll_price = new BLL.standard_price(); DataTable dt = bll_price.GetList(0, "good_id=" + _id, "id asc").Tables[0]; if (dt != null && dt.Rows.Count > 0) { if (!bll_price.Delete("good_id=" + _id)) { JscriptMsg("价格信息清除失败!", "", "Error"); return false; } } string standard_ids = DTRequest.GetFormString("ck_standard"); string standard_value_ids = DTRequest.GetFormString("ck_standard_value"); string str_standards = ""; BLL.standard bll_standard = new BLL.standard(); string[] str_standard_arr = standard_ids.Split(','); foreach (string str in str_standard_arr) { if (!string.IsNullOrEmpty(str)) { Model.standard model_standard = bll_standard.GetModel(Convert.ToInt32(str)); if (model_standard != null) { str_standards += model_standard.title + ","; } } } BLL.standard_value bll_value = new BLL.standard_value(); string[] str_standard_value_arr = standard_value_ids.Split(','); BLL.standard_group_price bll_standard_group_price = new BLL.standard_group_price(); DataTable dt_standard_group_price = bll_standard_group_price.GetList("good_id=" + _id).Tables[0]; if (dt_standard_group_price != null && dt_standard_group_price.Rows.Count > 0) { if (!bll_standard_group_price.Delete(_id)) { JscriptMsg("清除商品规格会员价格失败!", "", "Error"); return false; } } foreach (string str in str_standard_value_arr) { if (!string.IsNullOrEmpty(str)) { string str_title = ""; string[] str_arr = str.Split('_'); foreach (string s in str_arr) { if (!string.IsNullOrEmpty(s)) { Model.standard_value model_value = bll_value.GetModel(Convert.ToInt32(s)); if (model_value != null) { str_title += model_value.value + ","; } } } Model.standard_price model_price = new Model.standard_price(); model_price.good_id = _id; model_price.standard_ids = standard_ids; model_price.good_no = DTRequest.GetFormString("good_no_" + str); model_price.standards = str_standards.Substring(0, str_standards.Length - 1); model_price.standard_value_ids = str.Replace('_', ','); model_price.standard_values = str_title.Substring(0, str_title.Length - 1); model_price.stock_quantity = DTRequest.GetFormInt("stock_quantity_" + str, 0); model_price.market_price = DTRequest.GetFormDecimal("market_price_" + str, 0); model_price.sell_price=sell_price=standard_price = DTRequest.GetFormDecimal("sell_price_" + str, 0); model_price.action_price=action_price = DTRequest.GetFormDecimal("action_price_" + str, 0); model_price.user_price = DTRequest.GetFormDecimal("user_price_" + str, 0); model_price.add_time = DateTime.Now; decimal _standard_price_id = bll_price.Add(model_price); if (_standard_price_id <= 0) { JscriptMsg("更新价格信息失败!", "", "Error"); return false; } //规格会员组价格 BLL.user_groups bll_user_group = new BLL.user_groups(); DataTable dt_user_group = bll_user_group.GetList(0, "", "grade asc,id desc").Tables[0]; foreach (DataRow dr_user_group in dt_user_group.Rows) { Model.standard_group_price model_standard_group_price = new Model.standard_group_price(); model_standard_group_price.good_id = _id; model_standard_group_price.group_id = Convert.ToInt32(dr_user_group["id"]); model_standard_group_price.standard_price_id = _standard_price_id; model_standard_group_price.group_price=standard_group_price = DTRequest.GetFormDecimal("user_price_" + dr_user_group["id"] + "_" + str, 0); model_standard_group_price.add_time = DateTime.Now; if (bll_standard_group_price.Add(model_standard_group_price) <= 0) { JscriptMsg("规格会员价格更新失败!", "", "Error"); return false; } } } } //BLL.meal_good bll_meal_good = new BLL.meal_good(); //if (!bll_meal_good.UpdateMealGoodPrice(_id, sell_price, standard_price, standard_group_price, action_price)) //{ // JscriptMsg("套餐商品价格更新失败!", "", "Error"); // return false; //} //单位 BLL.unit bll_unit = new BLL.unit(); bll_unit.Delete(_id); string str_unit = DTRequest.GetFormString("ck_unit"); if (!string.IsNullOrEmpty(str_unit)) { string[] arr_unit = str_unit.Split(','); foreach (string s_unit in arr_unit) { if (!string.IsNullOrEmpty(s_unit)) { string[] unit = s_unit.Split('_'); Model.unit model_unit = new Model.unit(); model_unit.good_id = _id; model_unit.title = unit[0]; model_unit.quantity = Convert.ToInt32(unit[1]); model_unit.rate = Convert.ToDecimal(unit[2]); model_unit.content = unit[3]; model_unit.add_time = DateTime.Now; if (bll_unit.Add(model_unit) <= 0) { JscriptMsg("更新单位失败!", "", "Error"); return false; } } } } //别名 BLL.alias_good bll_alias_good = new BLL.alias_good(); //删除 bll_alias_good.Delete(_id); for (int i = 0; i < ck_alias.Items.Count; i++) { if (ck_alias.Items[i].Selected) { Model.alias_good model_alias_good = new Model.alias_good(); model_alias_good.alias_id = Convert.ToInt32(ck_alias.Items[i].Value); model_alias_good.good_id = _id; bll_alias_good.Add(model_alias_good); } } //属性 BLL.property_value bll_property_value = new BLL.property_value(); BLL.property_good bll_property_good = new BLL.property_good(); bll_property_good.Delete(_id); string str_property_value = DTRequest.GetFormString("ck_property_value"); if (!string.IsNullOrEmpty(str_property_value)) { string[] arr_property_value = str_property_value.Split(','); foreach (string str_1 in arr_property_value) { Model.property_good model_property_good = new Model.property_good(); model_property_good.good_id = _id; model_property_good.property_value_id = Convert.ToInt32(str_1); Model.property_value model_property_value = bll_property_value.GetModel(Convert.ToInt32(str_1)); if (model_property_value != null) { model_property_good.property_id = model_property_value.property_id; } bll_property_good.Add(model_property_good); } } //标签 BLL.tag_good bll_tag_good = new BLL.tag_good(); bll_tag_good.Delete(_id); for (int i = 0; i < ck_tag.Items.Count; i++) { if (ck_tag.Items[i].Selected) { Model.tag_good model_tag_good = new Model.tag_good(); model_tag_good.tag_id = Convert.ToInt32(ck_tag.Items[i].Value); model_tag_good.good_id = _id; bll_tag_good.Add(model_tag_good); } } } #endregion AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改" + this.channel_name + "频道内容:" + model.title); //记录日志 result = true; } return result; }
private void ShowInfo(int _id) { BLL.article bll = new BLL.article(); Model.article model = bll.GetModel(_id); ddlCategoryId.SelectedValue = model.category_id.ToString(); txtCallIndex.Text = model.call_index; txtTitle.Text = model.title; txtLinkUrl.Text = model.link_url; //不是相册图片就绑定 string filename = model.img_url.Substring(model.img_url.LastIndexOf("/") + 1); if (!filename.StartsWith("thumb_")) { txtImgUrl.Text = model.img_url; } txtSeoTitle.Text = model.seo_title; txtSeoKeywords.Text = model.seo_keywords; txtSeoDescription.Text = model.seo_description; txtZhaiyao.Text = model.zhaiyao; txtContent.Value = model.content; txtSortId.Text = model.sort_id.ToString(); txtClick.Text = model.click.ToString(); rblStatus.SelectedValue = model.status.ToString(); txtAddTime.Text = model.add_time.ToString("yyyy-MM-dd HH:mm:ss"); if (model.is_msg == 1) { cblItem.Items[0].Selected = true; } if (model.is_top == 1) { cblItem.Items[1].Selected = true; } if (model.is_red == 1) { cblItem.Items[2].Selected = true; } if (model.is_hot == 1) { cblItem.Items[3].Selected = true; } if (model.is_slide == 1) { cblItem.Items[4].Selected = true; } if (model.is_put == 1) { isPut.Items[0].Selected = false; isPut.Items[1].Selected = true; } else { isPut.Items[1].Selected = false; isPut.Items[0].Selected = true; } //扩展字段赋值 List<Model.article_attribute_field> ls1 = new BLL.article_attribute_field().GetModelList(this.channel_id, ""); foreach (Model.article_attribute_field modelt1 in ls1) { switch (modelt1.control_type) { case "single-text": //单行文本 TextBox txtControl = FindControl("field_control_" + modelt1.name) as TextBox; if (txtControl != null && model.fields.ContainsKey(modelt1.name)) { if (modelt1.is_password == 1) { txtControl.Attributes.Add("value", model.fields[modelt1.name]); } else { txtControl.Text = model.fields[modelt1.name]; } } break; case "multi-text": //多行文本 goto case "single-text"; case "editor": //编辑器 HtmlTextArea txtAreaControl = FindControl("field_control_" + modelt1.name) as HtmlTextArea; if (txtAreaControl != null && model.fields.ContainsKey(modelt1.name)) { txtAreaControl.Value = model.fields[modelt1.name]; } break; case "images": //图片上传 goto case "single-text"; case "number": //数字 goto case "single-text"; case "checkbox": //复选框 CheckBox cbControl = FindControl("field_control_" + modelt1.name) as CheckBox; if (cbControl != null && model.fields.ContainsKey(modelt1.name)) { if (model.fields[modelt1.name] == "1") { cbControl.Checked = true; } else { cbControl.Checked = false; } } break; case "multi-radio": //多项单选 RadioButtonList rblControl = FindControl("field_control_" + modelt1.name) as RadioButtonList; if (rblControl != null && model.fields.ContainsKey(modelt1.name)) { rblControl.SelectedValue = model.fields[modelt1.name]; } break; case "multi-checkbox": //多项多选 CheckBoxList cblControl = FindControl("field_control_" + modelt1.name) as CheckBoxList; if (cblControl != null && model.fields.ContainsKey(modelt1.name)) { string[] valArr = model.fields[modelt1.name].Split(','); for (int i = 0; i < cblControl.Items.Count; i++) { cblControl.Items[i].Selected = false; //先取消默认的选中 foreach (string str in valArr) { if (cblControl.Items[i].Value == str) { cblControl.Items[i].Selected = true; } } } } break; } } //绑定图片相册 if (filename.StartsWith("thumb_")) { hidFocusPhoto.Value = model.img_url; //封面图片 } rptAlbumList.DataSource = model.albums; rptAlbumList.DataBind(); //绑定内容附件 rptAttachList.DataSource = model.attach; rptAttachList.DataBind(); //赋值用户组价格 if (model.group_price != null) { for (int i = 0; i < this.rptPrice.Items.Count; i++) { int hideId = Convert.ToInt32(((HiddenField)this.rptPrice.Items[i].FindControl("hideGroupId")).Value); foreach (Model.user_group_price modelt in model.group_price) { if (hideId == modelt.group_id) { ((HiddenField)this.rptPrice.Items[i].FindControl("hidePriceId")).Value = modelt.id.ToString(); ((TextBox)this.rptPrice.Items[i].FindControl("txtGroupPrice")).Text = modelt.price.ToString(); } } } } #region 商品相关 if (channel_name == "goods") { //规格价格 BLL.standard bll_standard = new BLL.standard(); BLL.standard_price bll_price = new BLL.standard_price(); Model.article_category model_category = new BLL.article_category().GetModel(model.category_id); string str1 = ""; if (model_category != null) { DataTable dt = bll_standard.GetList(0, "'" + model_category.class_list + "' like '%,'+convert(varchar(50),category_id)+',%'", "id asc").Tables[0]; if (dt != null) { foreach (DataRow dr in dt.Rows) { string is_checked = ""; DataTable dt_price1 = bll_price.GetList(0, "good_id=" + _id, "id asc").Tables[0]; if (dt_price1 != null && dt_price1.Rows.Count > 0) { foreach (DataRow dr1 in dt_price1.Rows) { string[] standard_ids = dr1["standard_ids"].ToString().Trim().Split(','); foreach (string str in standard_ids) { if (!string.IsNullOrEmpty(str)) { if (Convert.ToInt32(dr["id"]) == Convert.ToInt32(str)) { is_checked = " checked=\"checked\" "; } } } } } str1 += "<label><input type=\"checkbox\" value=\"" + dr["id"].ToString() + "\" name=\"ck_standard\" " + is_checked + " onclick=\"change_standard('ck_standard')\" />" + dr["title"].ToString() + "</label> "; } dd_standard_title.InnerHtml = str1; } } DataTable dt_price = bll_price.GetList(0, "good_id=" + _id, "id asc").Tables[0]; if (dt_price != null && dt_price.Rows.Count > 0) { //规格 //string str_standard = ""; //string[] str_standardid_arr = dt_price.Rows[0]["standard_ids"].ToString().Split(','); string[] str_standardtitle_arr = dt_price.Rows[0]["standards"].ToString().Split(','); //for (int i = 0; i < str_standardid_arr.Length; i++) //{ // str_standard += "<label><input type=\"checkbox\" checked=\"checked\" value=\"" + str_standardid_arr[i].ToString() + "\" name=\"ck_standard\" onclick=\"change_standard('ck_standard')\" />" + str_standardtitle_arr[i].ToString() + "</label> "; //} //dd_standard_title.InnerHtml = str_standard; //规格值 规格价格 //头部 //会员组 BLL.user_groups bll_groups = new BLL.user_groups(); DataTable dt_groups = bll_groups.GetList(0, "", "grade asc,id desc").Tables[0]; string str_groups_header = ""; if (dt_groups != null && dt_groups.Rows.Count > 0) { for (int i = 0; i < dt_groups.Rows.Count; i++) { str_groups_header += "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>" + dt_groups.Rows[i]["title"].ToString() + "</td>"; } } string rest_header = ""; rest_header += "<tr><td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>商品编号</td>"; for (int i = 0; i < str_standardtitle_arr.Length; i++) { rest_header += "<td style='font-weight:bold;color:#33B5E5; padding-right:10px;'>" + str_standardtitle_arr[i] + "</td>"; } rest_header += "<td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>库存</td>" + "<td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>市场价</td>" + "<td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>销售价</td>" + "<td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>活动价</td>" + str_groups_header + "</tr>"; string rest_body = ""; foreach (DataRow dr in dt_price.Rows) { string[] str_arr_value = dr["standard_values"].ToString().Split(','); rest_body += "<tr><td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;width: 100px;' type='text' class='input normal small' name='good_no_" + dr["standard_value_ids"].ToString().Replace(',', '_') + "' value='" + dr["good_no"].ToString() + "'/></td>"; foreach (string str in str_arr_value) { rest_body += "<td style='padding-right: 20px;'>" + str + "</td>"; } rest_body += "<td style='padding-right: 20px;'><input type='checkbox' value='" + dr["standard_value_ids"].ToString().Replace(',', '_') + "' name='ck_standard_value' checked='checked' style='display:none;'/>"; rest_body += "<input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='stock_quantity_" + dr["standard_value_ids"].ToString().Replace(',', '_') + "' value='" + dr["stock_quantity"].ToString() + "'/></td>"; rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='market_price_" + dr["standard_value_ids"].ToString().Replace(',', '_') + "' value='" + dr["market_price"].ToString() + "'/></td>"; rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='sell_price_" + dr["standard_value_ids"].ToString().Replace(',', '_') + "' value='" + dr["sell_price"].ToString() + "'/></td>"; rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='action_price_" + dr["standard_value_ids"].ToString().Replace(',', '_') + "' value='" + dr["action_price"].ToString() + "'/></td>"; for (int i = 0; i < dt_groups.Rows.Count; i++) { BLL.standard_group_price bll_standard_group_price = new BLL.standard_group_price(); Model.standard_group_price model_standard_group_price = bll_standard_group_price.GetModel(_id, Convert.ToInt32(dt_groups.Rows[i]["id"]), Convert.ToDecimal(dr["id"])); if (model_standard_group_price != null) { rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='user_price_" + dt_groups.Rows[i]["id"].ToString() + "_" + dr["standard_value_ids"].ToString().Replace(',', '_') + "' value='" + model_standard_group_price.group_price + "'/></td>"; } else { foreach (Model.user_group_price modelt in model.group_price) { if (Convert.ToInt32(dt_groups.Rows[i]["id"]) == modelt.group_id) { rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='user_price_" + dt_groups.Rows[i]["id"].ToString() + "_" + dr["standard_value_ids"].ToString().Replace(',', '_') + "' value='" + modelt.price + "'/></td>"; } } } } rest_body += "</tr>"; } dd_standard_value.InnerHtml = "<table>" + rest_header + rest_body + "</table>"; } //单位 BLL.unit bll_unit = new BLL.unit(); DataTable dt_unit = bll_unit.GetList("good_id=" + _id).Tables[0]; string str_unit = ""; if (dt_unit != null && dt_unit.Rows.Count > 0) { foreach (DataRow dr in dt_unit.Rows) { string unit = dr["title"].ToString() + "_" + Convert.ToInt32(dr["quantity"]) + "_" + Convert.ToDecimal(dr["rate"]) + "_" + dr["content"].ToString(); str_unit += "<tr>"; str_unit += "<td style='padding-right: 20px;'>" + dr["title"].ToString() + "<input type=\"checkbox\" name=\"ck_unit\" value=\"" + unit + "\" checked=\"checked\" style=\"display:none;\">" + "</td>"; str_unit += "<td style='padding-right: 20px;'>" + Convert.ToInt32(dr["quantity"]) + "</td>"; str_unit += "<td style='padding-right: 20px;'>" + Convert.ToDecimal(dr["rate"]) + "</td>"; str_unit += "<td style='padding-right: 20px;'>" + dr["content"].ToString() + "</td>"; str_unit += "<td style='padding-right: 20px;'><a href=\"javascript:;\" onclick=\"del_unit(this)\">删除</a></td>"; str_unit += "</tr>"; } } tb_unit_value.InnerHtml = str_unit; //别名 BLL.alias bll_alias = new BLL.alias(); DataTable dt_alias = bll_alias.GetList(" category_id in(select id from dt_article_category where (select class_list from dt_article_category where id=" + model.category_id + ") like '%,'+CONVERT(varchar(20),id)+',%')").Tables[0]; if (dt_alias != null && dt_alias.Rows.Count > 0) { foreach (DataRow dr in dt_alias.Rows) { ck_alias.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } } BLL.alias_good bll_alias_good = new BLL.alias_good(); for (int i = 0; i < ck_alias.Items.Count; i++) { DataTable dt_have = bll_alias_good.GetList("alias_id=" + ck_alias.Items[i].Value + " and good_id=" + _id).Tables[0]; if (dt_have != null && dt_have.Rows.Count > 0) { ck_alias.Items[i].Selected = true; } } //属性 BLL.property bll_property = new BLL.property(); DataTable dt_property = bll_property.GetList(" category_id in(select id from dt_article_category where (select class_list from dt_article_category where id=" + model.category_id + ") like '%,'+CONVERT(varchar(20),id)+',%')").Tables[0]; string str_result = ""; foreach (DataRow dr in dt_property.Rows) { str_result += "<dl>"; str_result += "<dt>" + dr["title"].ToString() + ":</dt>"; BLL.property_value bll_value = new BLL.property_value(); DataTable dt_property_value = bll_value.GetList("property_id=" + dr["id"].ToString()).Tables[0]; str_result += "<dd>"; if (dt_property_value != null && dt_property_value.Rows.Count > 0) { foreach (DataRow dr1 in dt_property_value.Rows) { BLL.property_good bll_property_good = new BLL.property_good(); DataTable dt_property_good = bll_property_good.GetList("good_id=" + model.id + " and property_value_id=" + dr1["id"].ToString()).Tables[0]; if (dt_property_good != null && dt_property_good.Rows.Count > 0) { str_result += "<label><input type=\"checkbox\" name=\"ck_property_value\" checked=\"checked\" value=\"" + dr1["id"].ToString() + "\" />" + dr1["value"].ToString() + "</label> "; } else { str_result += "<label><input type=\"checkbox\" name=\"ck_property_value\" value=\"" + dr1["id"].ToString() + "\" />" + dr1["value"].ToString() + "</label> "; } } } str_result += "</dd>"; str_result += "</dl>"; } div_property.InnerHtml = str_result; //标签 BLL.tag bll_tag = new BLL.tag(); DataTable dt_tag = bll_tag.GetList(" category_id in(select id from dt_article_category where (select class_list from dt_article_category where id=" + model.category_id + ") like '%,'+CONVERT(varchar(20),id)+',%')").Tables[0]; if (dt_tag != null && dt_tag.Rows.Count > 0) { foreach (DataRow dr in dt_tag.Rows) { ck_tag.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } } BLL.tag_good bll_tag_good = new BLL.tag_good(); for (int i = 0; i < ck_tag.Items.Count; i++) { DataTable dt_have = bll_tag_good.GetList("tag_id=" + ck_tag.Items[i].Value + " and good_id=" + _id).Tables[0]; if (dt_have != null && dt_have.Rows.Count > 0) { ck_tag.Items[i].Selected = true; } } } #endregion }
private void get_good_info(HttpContext context) { int good_id = DTRequest.GetQueryInt("good_id"); BLL.article bll_article = new BLL.article(); Model.article model_article = bll_article.GetModel(good_id); if (model_article == null) { context.Response.Write("NotFind"); return; } string str_header = ""; string str_body = ""; //会员组 BLL.user_groups bll_groups = new BLL.user_groups(); DataTable dt_groups = bll_groups.GetList(0, "", "grade asc,id desc").Tables[0]; string str_groups_header = ""; string str_groups_body = ""; BLL.standard_price bll_standard_price = new BLL.standard_price(); DataTable dt_standard_price = bll_standard_price.GetList("good_id=" + good_id).Tables[0]; if (dt_standard_price != null && dt_standard_price.Rows.Count > 0) { //有规格价格 foreach (DataRow dr in dt_standard_price.Rows) { decimal sell_price = Convert.ToDecimal(model_article.fields["sell_price"]); string str_standard = ""; string str_standard_value = ""; sell_price = Convert.ToDecimal(dr["sell_price"]); if (dr["standards"] != null && !string.IsNullOrEmpty(dr["standards"].ToString())) { string[] standard_arr = dr["standards"].ToString().Split(',');//规格名 string[] standard_value_arr = dr["standard_values"].ToString().Split(',');//规格值 string[] standard_value_id_arr = dr["standard_value_ids"].ToString().Split(',');//规格值ID for (int i = 0; i < standard_arr.Length; i++) { str_standard += "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>" + standard_arr[i] + "</td>"; if (i < standard_value_arr.Length) { str_standard_value += "<td style='padding-right: 20px;'>" + standard_value_arr[i] + "</td>"; foreach (DataRow dr_group in dt_groups.Rows) { BLL.standard_group_price bll_standard_group_price = new BLL.standard_group_price(); DataTable dt_standard_group_price = bll_standard_group_price.GetList("good_id=" + model_article.id + " and group_id=" + Convert.ToInt32(dr_group["id"]) + " and standard_price_id=" + standard_value_id_arr[i]).Tables[0]; if (dt_standard_group_price != null && dt_standard_group_price.Rows.Count > 0) { str_groups_body += "<td style='padding-right: 20px;'>" + Convert.ToDecimal(dt_standard_group_price.Rows[0]["group_price"]) + "</td>"; } } } else { str_standard_value += "<td style='padding-right: 20px;'> </td>"; } } } str_header = "<table>" + "<thead><tr>" + "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>名称</td>" + "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>售价</td>" + str_standard + str_groups_header + "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>数量</td>" + "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>操作</td>" + "</tr></thead>"; str_body += "<tbody><tr>" + "<td style='padding-right: 20px;'>" + model_article.title + "</td>" + "<td style='padding-right: 20px;'>" + sell_price + "</td>" + str_groups_body + str_standard_value + "<td style='padding-right: 20px;'><input type='text' class='input small' id='quantity_" + model_article.id + "_" + dr["id"].ToString() + "'></td>" + "<td style='padding-right: 20px;'><a href='javascript:;' onclick='into_meal(" + model_article.id + "," + dr["id"].ToString() + ",this)'>选择</a></td>" + "</tr></tbody>" + "<table>"; } } else { //无规格价格 if (dt_groups != null && dt_groups.Rows.Count > 0) { for (int i = 0; i < dt_groups.Rows.Count; i++) { str_groups_header += "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>" + dt_groups.Rows[i]["title"].ToString() + "</td>"; str_groups_body += "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>" + bll_article.GetGroupPrice(model_article.id, Convert.ToInt32(dt_groups.Rows[i]["id"])) + "</td>"; } } str_header = "<table>" + "<thead><tr>" + "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>名称</td>" + "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>售价</td>" + str_groups_header + "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>数量</td>" + "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>操作</td>" + "</tr></thead>"; str_body += "<tbody><tr>" + "<td style='padding-right: 20px;'>" + model_article.title + "</td>" + "<td style='padding-right: 20px;'>" + model_article.fields["sell_price"] + "</td>" + str_groups_body + "<td style='padding-right: 20px;'><input type='text' class='input small' id='quantity_" + model_article.id + "_0'></td>" + "<td style='padding-right: 20px;'><a href='javascript:;' onclick='into_meal(" + model_article.id + ",0,this)'>选择</a></td>" + "</tr></tbody>" + "<table>"; } context.Response.Write(str_header + str_body); return; }
private void change_standard(HttpContext context) { string standard_ids = DTRequest.GetQueryString("standard_ids"); int quntity = DTRequest.GetQueryInt("quntity"); decimal market_price = DTRequest.GetQueryDecimal("market_price", 0); decimal sell_price = DTRequest.GetQueryDecimal("sell_price", 0); string groups_price = DTRequest.GetQueryString("groups_price"); BLL.standard bll = new BLL.standard(); BLL.standard_price bll_standard_price = new BLL.standard_price(); string rest_header = ""; string rest_body = ""; string strSql = ""; string strorder = ""; //会员组 BLL.user_groups bll_groups = new BLL.user_groups(); DataTable dt_groups = bll_groups.GetList(0, "", "grade asc,id desc").Tables[0]; string str_groups_header = ""; if (dt_groups != null && dt_groups.Rows.Count > 0) { for (int i = 0; i < dt_groups.Rows.Count; i++) { str_groups_header += "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>" + dt_groups.Rows[i]["title"].ToString() + "</td>"; } } string[] arr_group_price = groups_price.Split(',');//前台会员等级价格 //表头部分 DataTable dt = bll.GetList(0, "id in (" + standard_ids + ")", "id asc").Tables[0]; if (dt != null && dt.Rows.Count > 0) { rest_header += "<tr><td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>商品编号</td>"; for (int i = 0; i < dt.Rows.Count; i++) { rest_header += "<td style='font-weight:bold;color:#33B5E5;padding-right:10px;'>" + dt.Rows[i]["title"].ToString() + "</td>"; //规格值列表 strSql += "(select id as id_" + dt.Rows[i]["id"].ToString() + ",value as value_" + dt.Rows[i]["id"].ToString() + " from td_standard_value where standard_id=" + dt.Rows[i]["id"].ToString() + ") as t_" + dt.Rows[i]["id"].ToString() + ","; if (i == 0) { strorder = "id_" + dt.Rows[i]["id"].ToString() + " asc"; } } rest_header += "<td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>库存</td>" + "<td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>市场价</td>" + "<td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>销售价</td>" + "<td style='font-weight:bold;color:#33B5E5;text-align:left;padding-right:10px;'>活动价</td>" + str_groups_header + "</tr>"; DataTable dt_price = bll_standard_price.get_dcer_list(strSql.Substring(0, strSql.Length - 1), strorder).Tables[0]; rest_body += "<tr>"; foreach (DataRow dr in dt_price.Rows) { string str = ""; rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;width: 100px;' type='text' class='input normal small' name='good_no_" + str.Substring(0, str.Length - 1) + "' value=''/></td>"; for (int i = 0; i < dr.ItemArray.Length; i += 2) { rest_body += "<td style='padding-right: 20px;'>" + dr[i + 1].ToString() + "</td>"; str += dr[i].ToString() + "_"; } rest_body += "<td style='padding-right: 20px;'><input type='checkbox' value='" + str.Substring(0, str.Length - 1) + "' name='ck_standard_value' checked='checked' style='display:none;'/>"; rest_body += "<input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='stock_quantity_" + str.Substring(0, str.Length - 1) + "' value='" + quntity + "'/></td>"; rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='market_price_" + str.Substring(0, str.Length - 1) + "' value='" + market_price + "'/></td>"; rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='sell_price_" + str.Substring(0, str.Length - 1) + "' value='" + sell_price + "'/></td>"; rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='action_price_" + str.Substring(0, str.Length - 1) + "' value='" + sell_price + "'/></td>"; for (int j = 0; j < dt_groups.Rows.Count; j++) { if (j < arr_group_price.Length) { //会员价格文本框NAME=user_price_用户组id_规格值 rest_body += "<td style='padding-right: 20px;'><input style='border: 1px solid #d8d8d8;margin: 10px 18px 12px 0;' type='text' class='input normal small' name='user_price_" + dt_groups.Rows[j]["id"].ToString() + "_" + str.Substring(0, str.Length - 1) + "' value='" + arr_group_price[j] + "'/></td>"; } } rest_body += "</tr>"; } } context.Response.Write("{\"status\":\"y\",\"info\":\"" + "<table>" + rest_header + rest_body + "</table>" + "\"}"); return; ////DataTable dt = bll.GetList("standard_id=" + item.Value).Tables[0]; ////dt.TableName = "dt_" + item.Value; //strSql += "(select id as id_" + item.Value + ",value as value_" + item.Value + " from td_standard_value where standard_id=" + item.Value + ") as t_" + item.Value + ","; //if (sel_count == 0) //{ // strorder = "id_" + item.Value+" asc"; //} }