private string GetRealItemInfo()
{
//如果是编辑则调用宝贝ID，如果是添加则生成随机数
if (id == "0")
{
id = nick;
}
//创建宝贝
string sql = "SELECT COUNT(*) FROM Jia_Item WHERE itemid = '" + id + "'";
string count = DBHelper.ExecuteDataTable(sql).Rows[0][0].ToString();
Jia_Item item = CreateItemInfo();
if (count == "0")
{
Jia_ItemService jiaService = new Jia_ItemService();
jiaService.AddJia_Item(item);
}
else
{
Jia_ItemService jiaService = new Jia_ItemService();
jiaService.ModifyJia_Item(item);
}
//创建宝贝图片
//获取模板信息
Jia_Template temp = tempDal.GetJia_TemplateById(item.TplId);
string content = MethodGroup.GetRealItemInfo(item, temp, "1");
return(content);
}
public int ModifyJia_Template(Jia_Template jia_template)
{
string sql = "update Jia_Template set Tplname=@Tplname,OrderIid=@OrderIid,Count=@Count,TplImg=@TplImg,TplShort=@TplShort,TplHtml=@TplHtml,CateId=@CateId,UglyTplHtml=@UglyTplHtml where TplId=@TplId";
SqlParameter[] param = CreateParameter(jia_template);
return(DBHelper.ExecuteNonQuery(sql, param));
}
public int AddJia_Template(Jia_Template jia_template)
{
string sql = "insert Jia_Template(TplId,Tplname,OrderIid,Count,TplImg,TplShort,TplHtml,CateId,UglyTplHtml) values(@TplId,@Tplname,@OrderIid,@Count,@TplImg,@TplShort,@TplHtml,@CateId,@UglyTplHtml)";
SqlParameter[] param = CreateParameter(jia_template);
return(DBHelper.ExecuteNonQuery(sql, param));
}
protected void Page_Load(object sender, EventArgs e)
{
id = Request.QueryString["id"] == null ? "0" : Request.QueryString["id"].ToString();
nick = Request.QueryString["nick"] == null ? "0" : Request.QueryString["nick"].ToString();
tplid = Request.QueryString["tplid"] == null ? "0" : Request.QueryString["tplid"].ToString();
//创建宝贝
Jia_ItemService jiaService = new Jia_ItemService();
Jia_Item item = jiaService.GetJia_ItemById(id);
//获取模板信息
Jia_Template temp = tempDal.GetJia_TemplateById(item.TplId);
newhtml = MethodGroup.GetRealItemInfo(item, temp, "1");
newhtml = newhtml.Replace("\"", "\\\"");
}
private SqlParameter[] CreateParameter(Jia_Template jia_template)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@TplId", jia_template.TplId),
new SqlParameter("@Tplname", jia_template.Tplname),
new SqlParameter("@OrderIid", jia_template.OrderIid),
new SqlParameter("@Count", jia_template.Count),
new SqlParameter("@TplImg", jia_template.TplImg),
new SqlParameter("@TplShort", jia_template.TplShort),
new SqlParameter("@TplHtml", jia_template.TplHtml),
new SqlParameter("@CateId", jia_template.CateId),
new SqlParameter("@UglyTplHtml", jia_template.UglyTplHtml)
};
return(param);
}
public string updategoods(string goodsId, string tempType, string dataType)
{
Jia_Item item = itemDal.GetJia_ItemById(goodsId);
ResponseMsg pmsg = new ResponseMsg();
msg msg = new msg();
if (item == null)
{
pmsg.result = "fail";
msg.content = "该商品未使用模板";
}
else
{
pmsg.result = "success";
Jia_Template temp = tempDal.GetJia_TemplateById(item.TplId);
if (temp == null)
{
pmsg.result = "fail";
msg.content = "未找到模板";
}
else
{
pmsg.result = "success";
msg.content = GetRealItemInfo(item, temp, tempType);
}
}
List <msg> list = new List <msg>();
list.Add(msg);
if (dataType == "json")
{
return(GetJsonStr(list, pmsg));
}
ResponseXMLMsg xmlmsg = new ResponseXMLMsg();
xmlmsg.result = pmsg.result;
return(GetXMLStr(list, xmlmsg));
}
private IList <Jia_Template> Jia_TemplatePropertity(string sql, params SqlParameter[] param)
{
DataTable dt = DBHelper.ExecuteDataTable(sql, param);
IList <Jia_Template> list = new List <Jia_Template>();
foreach (DataRow dr in dt.Rows)
{
Jia_Template jia_template = new Jia_Template();
jia_template.TplId = Convert.ToString(dr["TplId"]);
jia_template.Tplname = Convert.ToString(dr["Tplname"]);
jia_template.OrderIid = Convert.ToInt32(dr["OrderIid"]);
jia_template.Count = Convert.ToInt32(dr["Count"]);
jia_template.TplImg = Convert.ToString(dr["TplImg"]);
jia_template.TplShort = Convert.ToString(dr["TplShort"]);
jia_template.TplHtml = Convert.ToString(dr["TplHtml"]);
jia_template.CateId = Convert.ToString(dr["CateId"]);
jia_template.UglyTplHtml = Convert.ToString(dr["UglyTplHtml"]);
list.Add(jia_template);
}
return(list);
}
private static string GetRealItemInfo(Jia_Item item, Jia_Template temp, string type)
{
Jia_ImgService imgDal = new Jia_ImgService();
Jia_ImgCustomerService cimgDal = new Jia_ImgCustomerService();
string tempHtml = "";
if (type == "1")
{
tempHtml = temp.TplHtml;
}
if (type == "0")
{
tempHtml = temp.UglyTplHtml;
}
IList <Jia_Img> imgList = imgDal.GetAllJia_Img(temp.TplId);
IList <Jia_ImgCustomer> cimgList = cimgDal.GetAllJia_ImgCustomer(item.ItemId);
//替换图片
foreach (Jia_Img jimg in imgList)
{
tempHtml = tempHtml.Replace(jimg.Tag, jimg.JiaImg);
}
foreach (Jia_ImgCustomer jcimg in cimgList)
{
tempHtml = tempHtml.Replace(jcimg.Tag, jcimg.JiaImg);
}
//替换chartext
string chartext = item.CharText.Substring(1, item.CharText.Length - 2); //剔除{}
Dictionary <string, string> dic = new Dictionary <string, string>();
string[] chars = Regex.Split(chartext, "{,}");
foreach (string s in chars)
{
dic.Add(s.Substring(0, s.IndexOf(':')), s.Substring(s.IndexOf(':') + 1, s.Length - s.IndexOf(':') - 1));
}
foreach (KeyValuePair <string, string> kvp in dic)
{
tempHtml = tempHtml.Replace("{" + kvp.Key + "}", kvp.Value);
}
//替换PropertyText
string propertyText = item.PropertyText.Substring(1, item.PropertyText.Length - 2); //剔除{}
string loop = tempHtml.Substring(tempHtml.IndexOf("{loop}") + 6, tempHtml.IndexOf("{/loop}") - tempHtml.IndexOf("{loop}") - 6);
chars = Regex.Split(propertyText, "{,}");
string realpropertyText = "";
foreach (string s in chars)
{
realpropertyText += loop.Replace("{left}", s.Substring(0, s.IndexOf(':'))).Replace("{right}", s.Substring(s.IndexOf(':') + 1, s.Length - s.IndexOf(':') - 1));
}
Regex regex = new Regex("{loop}.*?{/loop}");
tempHtml = regex.Replace(tempHtml, realpropertyText);
return(tempHtml);
}
