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_Item(Jia_Item jia_item)
{
string sql = "update Jia_Item set TplId=@TplId,UpdateDate=@UpdateDate,PropertyText=@PropertyText,CharText=@CharText where Nick=@Nick and ItemId=@ItemId";
SqlParameter[] param = CreateParameter(jia_item);
return(DBHelper.ExecuteNonQuery(sql, param));
}
public int AddJia_Item(Jia_Item jia_item)
{
string sql = "insert Jia_Item(Nick,ItemId,TplId,UpdateDate,PropertyText,CharText) values(@Nick,@ItemId,@TplId,@UpdateDate,@PropertyText,@CharText)";
SqlParameter[] param = CreateParameter(jia_item);
return(DBHelper.ExecuteNonQuery(sql, param));
}
private SqlParameter[] CreateParameter(Jia_Item jia_item)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@Nick", jia_item.Nick),
new SqlParameter("@ItemId", jia_item.ItemId),
new SqlParameter("@TplId", jia_item.TplId),
new SqlParameter("@UpdateDate", jia_item.UpdateDate),
new SqlParameter("@PropertyText", jia_item.PropertyText),
new SqlParameter("@CharText", jia_item.CharText)
};
return(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 Jia_Item CreateItemInfo()
{
Jia_Item item = new Jia_Item();
if (id == "0")
{
id = nick;
}
item.ItemId = id;
item.Nick = nick;
item.PropertyText = CreateProperty();
item.CharText = CreateChar();
item.TplId = tplid;
item.UpdateDate = DateTime.Now;
return(item);
}
private IList <Jia_Item> Jia_ItemPropertity(string sql, params SqlParameter[] param)
{
DataTable dt = DBHelper.ExecuteDataTable(sql, param);
IList <Jia_Item> list = new List <Jia_Item>();
foreach (DataRow dr in dt.Rows)
{
Jia_Item jia_item = new Jia_Item();
jia_item.Nick = Convert.ToString(dr["Nick"]);
jia_item.ItemId = Convert.ToString(dr["ItemId"]);
jia_item.TplId = Convert.ToString(dr["TplId"]);
jia_item.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
jia_item.PropertyText = Convert.ToString(dr["PropertyText"]);
jia_item.CharText = Convert.ToString(dr["CharText"]);
list.Add(jia_item);
}
return(list);
}
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 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);
}
