/// <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(); } } }