/// <summary>
/// (基础成员)删除实体集合(事务中)
/// </summary>
/// <param name='dic'></param>
/// <param name="ts">事务</param>
/// <returns></returns>
public int DelEntityObjects(Dictionary <string, object> dic, Transaction ts)
{
try
{
DeleteCriteria dc = GetDeleteCriteria(dic);
return(dc.Execute(ts));
}
catch (PersistenceLayerException exp)
{
throw new Exception(exp.ErrorMessage);
}
}
private void DelNotes(string id)
{
DeleteCriteria dcnote = new DeleteCriteria(typeof(XiHuan_GuestBookEntity));
Condition cnote = dcnote.GetNewCondition();
cnote.AddEqualTo(XiHuan_GuestBookEntity.__ID, id);
if (dcnote.Perform() > 0)
{
Alert("恭喜：留言已成功删除！");
BindNotes(0);
}
}
/// <summary>
/// (基础成员)删除实体集合
/// </summary>
/// <returns></returns>
public int DelEntityObjects()
{
try
{
DeleteCriteria dc = GetDeleteCriteria();
return(dc.Execute());
}
catch (PersistenceLayerException exp)
{
ErrorLog.Write(exp, exp.ErrorMessage);
throw new Exception(exp.ErrorMessage);
}
}
/// <summary>
/// (私有方法)字段删除
/// </summary>
/// <param name='dic'></param>
/// <returns></returns>
private DeleteCriteria GetDeleteCriteria(Dictionary <string, object> dic)
{
DeleteCriteria dc = new DeleteCriteria(typeof(r_Log));
if (dic != null && dic.Count > 0)
{
IFilter filter = dc.GetFilter();
object dicObject;
if (dic.TryGetValue(r_Log.F_LOGID, out dicObject))
{
filter.AddEqualTo(r_Log.F_LOGID, dicObject.ToString());
}
if (dic.TryGetValue(r_Log.F_INSERTDATETIME, out dicObject))
{
filter.AddEqualTo(r_Log.F_INSERTDATETIME, dicObject.ToString());
}
if (dic.TryGetValue(r_Log.F_DATACOUNT, out dicObject))
{
filter.AddEqualTo(r_Log.F_DATACOUNT, dicObject.ToString());
}
if (dic.TryGetValue(r_Log.F_QUERYTIMESTAMP, out dicObject))
{
filter.AddEqualTo(r_Log.F_QUERYTIMESTAMP, dicObject.ToString());
}
if (dic.TryGetValue(r_Log.F_INGESTTIMESTAMP, out dicObject))
{
filter.AddEqualTo(r_Log.F_INGESTTIMESTAMP, dicObject.ToString());
}
if (dic.TryGetValue(r_Log.F_USERID, out dicObject))
{
filter.AddEqualTo(r_Log.F_USERID, dicObject.ToString());
}
if (dic.TryGetValue(r_Log.F_STATUS, out dicObject))
{
filter.AddEqualTo(r_Log.F_STATUS, dicObject.ToString());
}
if (dic.TryGetValue(r_Log.F_REMARK, out dicObject))
{
filter.AddEqualTo(r_Log.F_REMARK, dicObject.ToString());
}
if (dic.TryGetValue(r_Log.F_ACTIVITYDATE, out dicObject))
{
filter.AddEqualTo(r_Log.F_ACTIVITYDATE, dicObject.ToString());
}
}
return(dc);
}
protected void lnkDelMessage_Click(object sender, EventArgs e)
{
DeleteCriteria dcmessage = new DeleteCriteria(typeof(XiHuan_MessageEntity));
Condition cmessage = dcmessage.GetNewCondition();
cmessage.AddEqualTo(XiHuan_MessageEntity.__ID, hidId.Value);
if (dcmessage.Perform() > 0)
{
Alert("恭喜：短消息已成功删除！");
if (CommonMethod.FinalString(Request["type"]) == "receive")
{
BindReceive();
}
else
{
BindSend();
}
}
}
protected void lnkDelMultiMessage_Click(object sender, EventArgs e)
{
string[] mid = hidId.Value.Trim().TrimEnd(',').Split(',');
if (mid.Length > 0)
{
DeleteCriteria dcnotes = new DeleteCriteria(typeof(XiHuan_MessageEntity));
Condition cnotes = dcnotes.GetNewCondition();
cnotes.AddIn(XiHuan_MessageEntity.__ID, mid);
if (dcnotes.Perform() > 0)
{
Alert("恭喜：选中的短消息已成功删除！");
if (CommonMethod.FinalString(Request["type"]) == "receive")
{
BindReceive();
}
else
{
BindSend();
}
}
}
}
public void DeleteLoadTest() {
DeleteCriteria del_crit = new DeleteCriteria((new TestObject()).Type, "( Name = '" + m_obj_name + "')");
del_crit.Perform();
}
public void CtorWithParamsTest()
{
var item = new DeleteCriteria(1);
Assert.AreEqual(1, item.Id);
}
private void cmdDelete()
{
string sWhere = "";
Console.WriteLine( "Enter SQL Where condition ex.:(Name = 'test')" );
sWhere = Console.ReadLine();
if ( string.IsNullOrEmpty( sWhere ) ) {
sWhere = "(Name like '%')";
}
if( m_trans == null ) {
DeleteCriteria crit = new DeleteCriteria( (new TestObject()).Type, sWhere );
crit.Perform();
Console.WriteLine( "{0} : Delete request completed = {1}",DateTime.Now.ToLongTimeString(), crit.Count );
} else {
RetrieveCriteria rt = new RetrieveCriteria((new TestObject()).Type, sWhere );
rt.Perform();
m_trans.Add( rt, PersistentTransaction.ACTION.Delete );
Console.WriteLine( "{0} : added to delete transaction = {1}", DateTime.Now.ToLongTimeString(), rt.Count );
}
}
public void DeleteTest()
{
//RetrieveCriteria ret_crit = new RetrieveCriteria(
// (new TestObject()).Type,
// "( name LIKE '" + m_obj_name + "%' )" );
//ret_crit.Perform();
//Assert.IsFalse( ret_crit.CountFound == 0,
// "Search for delete returned no objects" );
DeleteCriteria del_crit = new DeleteCriteria(
(new TestObject()).Type,
"( name LIKE '" + m_obj_name + "%' )" );
del_crit.Perform();
//ret_crit = new RetrieveCriteria(
// (new TestObject()).Type,
// "( name LIKE '" + m_obj_name + "%' )" );
//ret_crit.AsProxies = true;
//ret_crit.Perform();
//Assert.IsFalse( ret_crit.CountFound > 0, "Not all objects was deleted!" );
}
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();
}
}
}
}
private void DelGoods(string id)
{
int gid = CommonMethod.ConvertToInt(id, 0);
Transaction t = new Transaction();
if (gid > 0)
{
XiHuan_UserGoodsEntity del = XiHuan_UserGoodsEntityAction.RetrieveAXiHuan_UserGoodsEntity(gid);
if (del != null)
{
t.AddDeleteObject(del);
#region 除换品信息的详细页面
if (File.Exists(Server.MapPath("../" + del.DetailUrl)))
{
File.Delete(Server.MapPath("../" + del.DetailUrl));
}
#endregion
#region 换品删除时，同时删除其图片信息,浏览信息
string imgphysicalsrc = string.Empty;
string imgname = string.Empty;
string thumphysicalsrc = string.Empty;
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_GoodsImageEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_GoodsImageEntity.__GOODSID, gid);
EntityContainer imagecontainer = rc.AsEntityContainer();
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("恭喜：换品删除成功！");
BindGoods();
}
}
}
