protected void btnUpDatePic_Click(object sender, EventArgs e)
{
RetrieveCriteria rcGoodsPics = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DEFAULTPHOTO);
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__NAME);
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
Condition c = rcGoodsPics.GetNewCondition();
c.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
c.AddNotEqualTo(XiHuan_UserGoodsEntity.__DEFAULTPHOTO, "images/none.jpg");
rcGoodsPics.OrderBy(XiHuan_UserGoodsEntity.__CREATEDATE, false);
rcGoodsPics.Top = 6;
EntityContainer ecGoods = rcGoodsPics.AsEntityContainer();
string pics = "var pics=\"";
string links = "var links=\"";
string texts = "var texts=\"";
foreach (XiHuan_UserGoodsEntity goods in ecGoods)
{
pics += goods.DefaultPhoto.Replace(GlobalVar.DefaultPhotoSize, GlobalVar.BigPhotoSize) + "|";
links += goods.DetailUrl + "|";
texts += ValidatorHelper.SafeSql(goods.Name) + "|";
}
pics = pics.TrimEnd('|') + "\";";
links = links.TrimEnd('|') + "\";";
texts = texts.TrimEnd('|') + "\";";
Query.ProcessSqlNonQuery(string.Format("update xihuan_systemconfig set configvalue='{0}' where configkey='HomeRounPics'", pics + links + texts), GlobalVar.DataBase_Name);
SystemConfigFacade.Refresh();
Alert("幻灯片成功更新！");
}
public IList<ScheduleEntity> GetCanExecute()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(tb_ScheduleRelistQueueEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(tb_ScheduleRelistQueueEntity.__STATE, false);
c.AddLessThanOrEqualTo(tb_ScheduleRelistQueueEntity.__SCHEDULE, DateTime.Now);
EntityContainer ec=rc.AsEntityContainer();
IList<ScheduleEntity> list = new List<ScheduleEntity>();
if (ec.Count > 0)
{
foreach (EntityObject srq in ec)
{
ScheduleEntity sre = new ScheduleEntity();
sre.Id = ((tb_ScheduleRelistQueueEntity)srq).id;
sre.Nick = userAction.GetUserNick(((tb_ScheduleRelistQueueEntity)srq).user_id);
sre.Num_iid = ((tb_ScheduleRelistQueueEntity)srq).num_iid;
if (sre.Nick != "")
{
list.Add(sre);
}
}
}
return list;
}
public void PrintSubdivided(List <FNLABELEntity> labels)
{
LabelSubdivided ls = new LabelSubdivided();
ls.TicketNo = labels[0].TICKET_NO;
ls.BucketNo = labels[0].BUCKET_NO;
ls.Section = labels[0].SECTION;
ls.Line = labels[0].LINE;
ls.PrNo = labels[0].PR_NO;
ls.ItemCode = labels[0].ZAIKEY;
ls.ItemName = GetItemName(ls.ItemCode);
ls.ColorCode = labels[0].COLOR_CODE;
decimal count = 0, weight = 0;
foreach (FNLABELEntity label in labels)
{
count += label.RETRIEVAL_QTY;
weight += label.RETRIEVAL_WEIGHT;
}
ls.Count = count.ToString("F0");
ls.Weight = weight.ToString();
ls.Unit = (labels[0].MASTER_UNIT_WEIGHT * 1000).ToString("F4");
ls.RetrievalNo = labels[0].RETRIEVAL_NO.Trim();
ls.NecessaryQty = labels[0].NECESSARY_QTY.ToString("F0");
ls.UserName = labels[0].USERNAME;
if (labels[0].OPTION_FLAG.Equals("1"))
{
ls.OptionFlag = "(直行)";
}
ls.StartDate = (labels[0].START_DATE.Length == 8 ? labels[0].START_DATE.Insert(4, "/").Insert(7, "/") : labels[0].START_DATE) + (labels[0].START_TIMING_FLAG == "1" ? "AM" : labels[0].START_TIMING_FLAG == "2" ? "PM" : "");
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNLABELEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNLABELEntity.__LABEL_TYPE, '5');
c.AddEqualTo(FNLABELEntity.__RETRIEVAL_NO, labels[0].RETRIEVAL_NO);
c.AddEqualTo(FNLABELEntity.__SERIAL_NO, labels[0].SERIAL_NO);
c.AddEqualTo(FNLABELEntity.__PRINTING_FLAG, "3");
int currentPage = rc.AsEntityContainer().Count + 1;
rc = new RetrieveCriteria(typeof(FNLABELEntity));
c = rc.GetNewCondition();
c.AddEqualTo(FNLABELEntity.__LABEL_TYPE, '5');
c.AddEqualTo(FNLABELEntity.__RETRIEVAL_NO, labels[0].RETRIEVAL_NO);
c.AddEqualTo(FNLABELEntity.__SERIAL_NO, labels[0].SERIAL_NO);
int totalPage = rc.AsEntityContainer().Count;
ls.Page = string.Format("{0}/{1}", currentPage, totalPage);
pc.DoPrint(GetPrintName(labels[0].PRINTER_NO), ls);
}
private List <FNLABELEntity> GetNextLabel()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNLABELEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNLABELEntity.__PRINTING_FLAG, "1");
OrGroup og = c.GetNewOrGroup();
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "11");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "12");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "13");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "14");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "15");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "16");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "17");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "18");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "19");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "20");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "21");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "22");
og.AddEqualTo(FNLABELEntity.__PRINTER_NO, "31");
rc.OrderBy(FNLABELEntity.__BUCKET_NO);
rc.OrderBy(FNLABELEntity.__PRINTER_NO);
rc.OrderBy(FNLABELEntity.__RETRIEVAL_STATION);
rc.OrderBy(FNLABELEntity.__LINE);
EntityContainer ec = rc.AsEntityContainer();
if (ec.Count > 0)
{
List <FNLABELEntity> labels = new List <FNLABELEntity>();
for (int i = 0; i < ec.Count; i++)
{
FNLABELEntity label = ec[i] as FNLABELEntity;
if (i > 0)
{
if (label.BUCKET_NO != labels[i - 1].BUCKET_NO || label.PRINTER_NO != labels[i - 1].PRINTER_NO)
{
break; //不同的箱号或打印机
}
}
labels.Add(label);
}
return(labels);
}
else
{
return(null);
}
}
public static List <FNSIJIEntity> GetSiJis(string mckey)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNSIJIEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNSIJIEntity.__MCKEY, mckey);
EntityContainer ec = rc.AsEntityContainer();
List <FNSIJIEntity> sijis = new List <FNSIJIEntity>();
for (int i = 0; i < ec.Count; i++)
{
sijis.Add(ec[i] as FNSIJIEntity);
}
return(sijis);
}
protected void Button1_Click(object sender, EventArgs e)
{
//图片表还需要处理，不是默认图片的，需要将图片复制到新的路径，更新路径到数据库
RetrieveCriteria rcgimages = new RetrieveCriteria(typeof(XiHuan_GoodsImageEntity));
Condition c = rcgimages.GetNewCondition();
if (txtGoodsId.Text.Trim().Length > 0)
{
c.AddEqualTo(XiHuan_GoodsImageEntity.__GOODSID, txtGoodsId.Text);
}
rcgimages.AddSelect(XiHuan_GoodsImageEntity.__ID);
rcgimages.AddSelect(XiHuan_GoodsImageEntity.__CREATEDATE);
rcgimages.AddSelect(XiHuan_GoodsImageEntity.__IMGSRC);
EntityContainer imagecontainer = rcgimages.AsEntityContainer();
string opath = string.Empty;
string filename = string.Empty;
string extention = string.Empty;
string despath = string.Empty;
string filepath = string.Empty;
string fixpath = "images/userupload/goodsimage/";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (XiHuan_GoodsImageEntity goodsimage in imagecontainer)
{
opath = Server.MapPath(goodsimage.ImgSrc);
filename = Path.GetFileNameWithoutExtension(opath);
extention = Path.GetExtension(opath);
if (File.Exists(opath))
{
filepath = fixpath + goodsimage.CreateDate.Year + "/" + goodsimage.CreateDate.Month + "/" + goodsimage.CreateDate.Day + "/";
despath = Server.MapPath(filepath + filename + extention);
if (!Directory.Exists(Server.MapPath(filepath)))
{
Directory.CreateDirectory(Server.MapPath(filepath));
}
if (!File.Exists(despath))
{
File.Copy(opath, despath, true);//复制原来的图片到新的路径
//File.Delete(opath);
}
sb.Append("Update XiHuan_GoodsImage set ImgSrc='" + filepath + filename + extention + "' WHERE Id=" + goodsimage.Id + ";");
}
}
if (sb.ToString().Length > 0)
{
Query.ProcessSqlNonQuery(sb.ToString(), GlobalVar.DataBase_Name);
}
}
private List <FNPRINTBODYEntity> GetBodys(string listKey)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNPRINTBODYEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNPRINTBODYEntity.__LISTKEY, listKey);
EntityContainer ec = rc.AsEntityContainer();
List <FNPRINTBODYEntity> bodys = new List <FNPRINTBODYEntity>();
for (int i = 0; i < ec.Count; i++)
{
FNPRINTBODYEntity body = ec[i] as FNPRINTBODYEntity;
bodys.Add(body);
}
return(bodys);
}
public void CheckReportTask()
{
try
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNPRINTHEADEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNPRINTHEADEntity.__PROC_FLAG, "0");
EntityContainer ec = rc.AsEntityContainer();
for (int i = 0; i < ec.Count; i++)
{
FNPRINTHEADEntity head = ec[i] as FNPRINTHEADEntity;
head.PROC_FLAG = "1";
head.Save();
Print(head);
}
}
catch (Exception ex)
{
WriteLog(ex.Message);
}
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveFUNCTIONEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FUNCTIONEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveFNFORBIDRETRIEVALEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNFORBIDRETRIEVALEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_TraderateContextEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_TraderateContextEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveT_BLINDMEMBEREntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_BLINDMEMBEREntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_User_SwitchEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_User_SwitchEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveT_DOCTORINFOEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_DOCTORINFOEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveT_SECHOUSEPICEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_SECHOUSEPICEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_ScheduleRecommendQueueEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_ScheduleRecommendQueueEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveprovinceEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(provinceEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_RelistReslutEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_RelistReslutEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveEntity系统选项表()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(Entity系统选项表));
return(rc.AsEntityContainer());
}
protected void btnSendMaiil_Click(object sender, EventArgs e)
{
string mailcontent = " <table style=\"width:98%;border: #ccc 1px solid;padding-right: 10px;padding-left: 10px;padding-bottom: 10px;padding-top: 10px;background-color: #f7f7f7; font-size:14px; color:black;\">";
RetrieveCriteria rcGoodsPics = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DEFAULTPHOTO);
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__NAME);
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
Condition c = rcGoodsPics.GetNewCondition();
c.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
c.AddNotEqualTo(XiHuan_UserGoodsEntity.__DEFAULTPHOTO, "images/none.jpg");
rcGoodsPics.OrderBy(XiHuan_UserGoodsEntity.__CREATEDATE, false);
rcGoodsPics.Top = 70;
EntityContainer ecGoods = rcGoodsPics.AsEntityContainer();
for (int i = 0; i < ecGoods.Count; i++)
{
int rem;
XiHuan_UserGoodsEntity goods = ecGoods[i] as XiHuan_UserGoodsEntity;
Math.DivRem(i, 7, out rem);
if (rem == 0)
{
mailcontent += "<tr>";
}
else
{
mailcontent += string.Format("<td style=\"border: solid 1px #CCCCCC;height: 30px;text-align:center;padding: 2px 5px;\"> <a title=\"{0}\" href=\"{1}\" target=\"_blank\"><img style=\"width: 85px;height: 85px;border: solid 1px #CCCCCC;\" title=\"{0}\" src=\"{2}\" /><br/><br/>{3}</a></td>", goods.Name, "http://www.tsc8.com/" + goods.DetailUrl + "?from=email", "http://www.tsc8.com/" + goods.DefaultPhoto, CommonMethod.GetSubString(goods.Name, 6, "..."));
}
if (rem == 0)
{
mailcontent += "</tr>";
}
}
mailcontent += "</table>";
DataTable dt = PersistenceLayer.Query.ProcessSql("select Id,UserName,Email,QQ,Msn from XiHuan_UserInfo with(nolock) where LastLoginTime<='" + DateTime.Now.AddDays(-Math.Abs(Convert.ToDouble(txtDays.Text))).ToString("yyyy-MM-dd") + "' and (Email>'' or QQ >'' or Msn >'')", GlobalVar.DataBase_Name);
string strMailAdd = string.Empty;
string email = string.Empty;
string qq = string.Empty;
string msn = string.Empty;
foreach (DataRow dr in dt.Rows)
{
strMailAdd = string.Empty;
email = CommonMethod.FinalString(dr[XiHuan_UserInfoEntity.__EMAIL]).ToLower();
qq = GetFinalQQ(CommonMethod.FinalString(dr[XiHuan_UserInfoEntity.__QQ]));
msn = CommonMethod.FinalString(dr[XiHuan_UserInfoEntity.__MSN]);
if (IsEmail(email))
{
strMailAdd += email + ",";
}
if (IsInt(qq))
{
strMailAdd += qq + "@qq.com,";
}
if (IsEmail(msn))
{
strMailAdd += msn + ",";
}
if (strMailAdd.Length > 0)
{
SendMailFacade.sendEmail(strMailAdd.TrimEnd(','), "喜换网-物品交换，节约，时尚，好玩，精彩不容错过！", "<span style=\"color:blue;font-weight:bold;\">尊敬的换友<a href=\"http://www.tsc8.com/xh.aspx?id=" + dr[XiHuan_UserInfoEntity.__ID] + "&from=email\" target=\"_blank\" style=\"color:red;\">" + dr[XiHuan_UserInfoEntity.__USERNAME] + "</a>，我们注意到你有段时间没来<a href=\"http://www.tsc8.com/?from=eamil&id=" + dr[XiHuan_UserInfoEntity.__ID] + "\" target=\"_blank\" style=\"color:red;\">喜换网</a>逛逛了啊，<br/><br/>你不在的这段时间里好多朋友发布了很多好玩的换品：</span><br/><br/>" + mailcontent + "<br/><br/>现在快<a href=\"http://www.tsc8.com/?from=eamil\" target=\"_blank\">去看看</a>吧！");
}
}
Alert("恭喜：邮件已经成功发送！");
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveMAINMENUEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(MAINMENUEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveT_TRANSACTIONBACKEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_TRANSACTIONBACKEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveT_ADVERTISMENTEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_ADVERTISMENTEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveT_SERVICETRACINGEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_SERVICETRACINGEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveXiHuan_UserFriendsEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserFriendsEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveFNTERMONAREAEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNTERMONAREAEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_RecommendResultEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_RecommendResultEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveFHDIFFERENCESTOCKEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FHDIFFERENCESTOCKEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveST_PROTYPEEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(ST_PROTYPEEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_InGoldTimeItemsEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_InGoldTimeItemsEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveT_SURVEYANSWEREntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_SURVEYANSWEREntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_GoldTimeslotSchemeDetailsEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_GoldTimeslotSchemeDetailsEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_LdleTimeslotEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_LdleTimeslotEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_MessageQueueEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_MessageQueueEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveFHSTORAGEINFOEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FHSTORAGEINFOEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveSYS_BASE_USERSEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(SYS_BASE_USERSEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveT_NEWSBASEEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_NEWSBASEEntity));
return(rc.AsEntityContainer());
}
protected void lnkDel_Click(object sender, EventArgs e)
{
int gid = CommonMethod.ConvertToInt(hidGoodId.Value.Trim(), 0);
Transaction t = new Transaction();
if (gid > 0)
{
XiHuan_UserGoodsEntity del = XiHuan_UserGoodsEntityAction.RetrieveAXiHuan_UserGoodsEntity(gid);
if (del != null)
{
if (del.GoodState == (byte)XiHuan_UserGoodsFacade.GoodsState.交换中)
{
Alert("此换品正处于交换中的状态不能删除！");
return;
}
else
{
t.AddDeleteObject(del);
#region 除换品信息的详细页面
if (File.Exists(Server.MapPath(del.DetailUrl)))
{
File.Delete(Server.MapPath(del.DetailUrl));
}
#endregion
#region 换品删除时，同时删除其图片信息,浏览信息
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_GoodsImageEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_GoodsImageEntity.__GOODSID, gid);
EntityContainer imagecontainer = rc.AsEntityContainer();
string imgphysicalsrc = string.Empty;
string imgname = string.Empty;
string thumphysicalsrc = string.Empty;
foreach (XiHuan_GoodsImageEntity goodimage in imagecontainer)
{
imgphysicalsrc = Server.MapPath(goodimage.ImgSrc);
if (File.Exists(imgphysicalsrc))
{
File.Delete(imgphysicalsrc);
}
imgname = Path.GetFileNameWithoutExtension(imgphysicalsrc);
thumphysicalsrc = imgphysicalsrc.Replace(imgname, imgname + GlobalVar.DefaultPhotoSize);
if (File.Exists(thumphysicalsrc))
{
File.Delete(thumphysicalsrc);
}
thumphysicalsrc = imgphysicalsrc.Replace(imgname, imgname + GlobalVar.BigPhotoSize);
if (File.Exists(thumphysicalsrc))
{
File.Delete(thumphysicalsrc);
}
t.AddDeleteObject(goodimage);
}
DeleteCriteria delhistory = new DeleteCriteria(typeof(XiHuan_GoodsViewUserEntity));
Condition chis = delhistory.GetNewCondition();
chis.AddEqualTo(XiHuan_GoodsViewUserEntity.__GOODSID, gid);
chis.AddEqualTo(XiHuan_GoodsViewUserEntity._TYPE, 0);
t.AddDeleteCriteria(delhistory);
#endregion
#region 更新用户换品数量
t.AddSqlString("update XiHuan_UserInfo set GoodsNumber=GoodsNumber-1 where Id=" + del.OwnerId, GlobalVar.DataBase_Name);
#endregion
t.Process();
Alert("恭喜：换品删除成功！");
BindData();
}
}
}
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveFNPRINTBODYEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNPRINTBODYEntity));
return(rc.AsEntityContainer());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer RetrieveUSERTERMINALEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(USERTERMINALEntity));
return(rc.AsEntityContainer());
}
