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("幻灯片成功更新！");
}
private void GetDetail()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__USERNAME, txtUserName.Text.Trim());
rc.AddSelect(XiHuan_UserInfoEntity.__ID);
rc.AddSelect(XiHuan_UserInfoEntity.__ORIGNALPWD);
rc.AddSelect(XiHuan_UserInfoEntity.__ISLOCKED);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
if (user != null)
{
if (user.IsLocked == 0)
{
lblResult.Text = string.Format("密码为：<span class=\"highlight\">{0}</span>，<a href=\"###\" onclick=\"LockUser({1});\">锁定此账号</a>", user.OrignalPwd, user.ID);
}
if (user.IsLocked == 1)
{
lblResult.Text = string.Format("密码为：<span class=\"highlight\">{0}</span>，<a href=\"###\" onclick=\"UnLockUser({1});\">撤消锁定此账号</a>", user.OrignalPwd, user.ID);
}
}
else
{
lblResult.Text = "<span class=\"highlight\">没有找到此会员的信息！</span>";
}
}
private FNRETRIEVAL_STEntity GetRetrievalStation(string retrieval_station)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNRETRIEVAL_STEntity));
rc.GetNewCondition().AddEqualTo(FNRETRIEVAL_STEntity.__RETRIEVAL_STATION, retrieval_station);
return((FNRETRIEVAL_STEntity)rc.AsEntity());
}
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;
}
private void AddFavorite(string id, string name)
{
if (!IsUserAlreadyLogin)
{
CommonMethod.ResponseAjaxContent(this.Page, "needlogin");
return;
}
else
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserFavorateEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserFavorateEntity.__USERID, CurrentUserId);
c.AddEqualTo(XiHuan_UserFavorateEntity.__GOODSID, id);
rc.AddSelect(XiHuan_UserFavorateEntity.__ID);
DataTable dt = rc.AsDataTable();
if (dt != null && dt.Rows.Count > 0)
{
CommonMethod.ResponseAjaxContent(this.Page, "already");
return;
}
else
{
XiHuan_UserFavorateEntity newfavorite = new XiHuan_UserFavorateEntity();
newfavorite.UserId = CurrentUserId;
newfavorite.GoodsId = CommonMethod.ConvertToInt(id, 0);
newfavorite.GoodsName = GlobalObject.unescape(CommonMethod.FinalString(name));
newfavorite.FacRemark = "";
newfavorite.FavDate = DateTime.Now;
newfavorite.Save();
CommonMethod.ResponseAjaxContent(this.Page, "ok");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int id = CommonMethod.ConvertToInt(Request["id"], 0);
if (id > 0)
{
RetrieveCriteria rcgoodimage = new RetrieveCriteria(typeof(XiHuan_GoodsImageEntity));
Condition c = rcgoodimage.GetNewCondition();
c.AddEqualTo(XiHuan_GoodsImageEntity.__GOODSID, id);
rcgoodimage.AddSelect(XiHuan_GoodsImageEntity.__IMGSRC);
rcgoodimage.AddSelect(XiHuan_GoodsImageEntity.__IMGDESC);
rcgoodimage.OrderBy(XiHuan_GoodsImageEntity.__CREATEDATE, false);
DataTable dt = rcgoodimage.AsDataTable();
StringBuilder sbImage = new StringBuilder();
StringBuilder sbDesc = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
sbImage.AppendFormat("\"{0}\",", dt.Rows[i][XiHuan_GoodsImageEntity.__IMGSRC]);
sbDesc.AppendFormat("\"{0}\",", dt.Rows[i][XiHuan_GoodsImageEntity.__IMGDESC]);
}
ExecStartupScript(string.Format("imageArray=new Array({0});", sbImage.ToString().TrimEnd(',')));
ExecStartupScript(string.Format("imageDesc=new Array({0});", sbDesc.ToString().TrimEnd(',')));
ExecStartupScript("getnext();$('#loadingimage').hide(); $('#saint').show();");
}
}
}
private void InitPage()
{
int uid = CommonMethod.ConvertToInt(Request["Id"], 0);
if (uid > 0)
{
#region 浏览过该换品的人
#region 浏览历史
int gid = GoodDetail.ID;
if (IsUserAlreadyLogin)
{
RetrieveCriteria rcview = new RetrieveCriteria(typeof(XiHuan_GoodsViewUserEntity));
Condition cview = rcview.GetNewCondition();
cview.AddEqualTo(XiHuan_GoodsViewUserEntity.__GOODSID, gid);
cview.AddEqualTo(XiHuan_GoodsViewUserEntity.__VISITORID, CurrentUserId);
cview.AddEqualTo(XiHuan_GoodsViewUserEntity._TYPE, 1);
XiHuan_GoodsViewUserEntity newview = rcview.AsEntity() as XiHuan_GoodsViewUserEntity;
if (CurrentUserId != gid)
{
if (newview == null)
{
newview = new XiHuan_GoodsViewUserEntity();
newview.GoodsId = gid;
newview.VisitorId = CurrentUserId;
newview.VisitorName = CurrentUserName;
newview.Type = 1;
}
newview.VisitorHeadImage = CurrentUser.HeadImage;
newview.VisitDate = DateTime.Now;
newview.Save();
}
}
#endregion
#endregion
StringBuilder sbSql = new StringBuilder("select top 18 Id,Name,DefaultPhoto,ViewCount,DetailUrl from XiHuan_UserGoods with(nolock) where OwnerId={0} and IsChecked=1 order by CreateDate desc, ViewCount desc ;");
sbSql.Append("select * from XiHuan_UserGoodsChangeRequire with(nolock) where OwnerId={0} order by RequireDate desc; ");
sbSql.Append("select * from XiHuan_UserGoodsChangeRequire with(nolock) where SenderId={0} order by RequireDate desc; ");
sbSql.Append("select * from XiHuan_GuestBook with(nolock) where ToId={0} order by CreateDate desc; ");
sbSql.Append("select FriendId,FriendName from XiHuan_UserFriends with(nolock) where OwnerId={0} order by AddDate desc; ");
sbSql.Append("select top 10 VisitorId,VisitorName,VisitorHeadImage,VisitDate from XiHuan_GoodsViewUser with(nolock) where Type=1 and GoodsId=" + gid + " order by VisitDate desc;");
DataSet ds = Query.ProcessMultiSql(string.Format(sbSql.ToString(), uid), GlobalVar.DataBase_Name);
dlsHotGoods.DataSource = ds.Tables[0];
dlsHotGoods.DataBind();
rptSend.DataSource = ds.Tables[1];
rptSend.DataBind();
rptRequire.DataSource = ds.Tables[2];
rptRequire.DataBind();
rptUserNotes.DataSource = ds.Tables[3];
rptUserNotes.DataBind();
rptGoodFriends.DataSource = ds.Tables[4];
rptGoodFriends.DataBind();
rptVisitor.DataSource = ds.Tables[5];
rptVisitor.DataBind();
}
}
private bool IsBucketExist(string bucketNo)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNZAIKOEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNZAIKOEntity.__BUCKET_NO, bucketNo);
return(rc.AsEntity() != null);
}
public static FNRANGEEntity GetRange(string termNo)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNRANGEEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNRANGEEntity.__TERMNO, termNo);
return(rc.AsEntity() as FNRANGEEntity);
}
public static FNLOCATEntity GetLocationBySystemid(string systemid)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNLOCATEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNLOCATEntity.__SYSTEMID, systemid);
return(rc.AsEntity() as FNLOCATEntity);
}
public static FNHANSOEntity GetHansoByBucketNo(string bucketNo)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNHANSOEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNHANSOEntity.__BUCKET_NO, bucketNo);
return(rc.AsEntity() as FNHANSOEntity);
}
public static FNHANSOEntity GetTransData(string mcKey)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNHANSOEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNHANSOEntity.__MCKEY, mcKey);
return(rc.AsEntity() as FNHANSOEntity);
}
public static USERATTRIBUTEEntity GetUserAttributeByUserId(string userId)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(USERATTRIBUTEEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(USERATTRIBUTEEntity.__USERID, userId);
return(rc.AsEntity() as USERATTRIBUTEEntity);
}
public string GetSessionKey(string nick)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(tb_UserEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(tb_UserEntity.__NICK, nick);
tb_UserEntity user = (tb_UserEntity)rc.AsEntity();
return user.SessionKey;
}
public static TERMINALEntity GetTermByIP(string ipAddress)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(TERMINALEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(TERMINALEntity.__IPADDRESS, ipAddress);
return(rc.AsEntity() as TERMINALEntity);
}
public static FNSTATIONEntity GetStation(string stNo)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNSTATIONEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNSTATIONEntity.__STNO, stNo);
return(rc.AsEntity() as FNSTATIONEntity);
}
public static FNZAIKOEntity GetZaiKoByTicketNo(string ticketNo)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNZAIKOEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNZAIKOEntity.__TICKET_NO, ticketNo);
return(rc.AsEntity() as FNZAIKOEntity);
}
private void LoadDetail()
{
#region 浏览过该换品的人
#region 浏览历史
int gid = CommonMethod.ConvertToInt(Request["gid"], 0);
if (gid > 0)
{
if (IsUserAlreadyLogin)
{
RetrieveCriteria rcview = new RetrieveCriteria(typeof(XiHuan_GoodsViewUserEntity));
Condition cview = rcview.GetNewCondition();
cview.AddEqualTo(XiHuan_GoodsViewUserEntity.__GOODSID, gid);
cview.AddEqualTo(XiHuan_GoodsViewUserEntity.__VISITORID, CurrentUserId);
cview.AddEqualTo(XiHuan_GoodsViewUserEntity._TYPE, 0);
XiHuan_GoodsViewUserEntity newview = rcview.AsEntity() as XiHuan_GoodsViewUserEntity;
if (newview == null)
{
newview = new XiHuan_GoodsViewUserEntity();
newview.GoodsId = gid;
newview.VisitorId = CurrentUserId;
newview.VisitorName = CurrentUserName;
newview.Type = 0;
}
newview.VisitorHeadImage = CurrentUser.HeadImage;
newview.VisitDate = DateTime.Now;
newview.Save();
}
#endregion
string sql = @"select top 10 VisitorId,VisitorName,VisitorHeadImage,VisitDate from XiHuan_GoodsViewUser with(nolock) where Type=0 and GoodsId={0} order by VisitDate desc;
declare @vcount int;
update xihuan_usergoods set viewcount=viewcount+1,@vcount=viewcount+1 where id= {0};
select @vcount;";
DataSet ds = Query.ProcessMultiSql(string.Format(sql, gid), GlobalVar.DataBase_Name);
DataTable dt = ds.Tables[0];
DataTable dt2 = ds.Tables[1];
int viewcount = (dt2 != null && dt2.Rows.Count > 0 ? CommonMethod.ConvertToInt(dt2.Rows[0][0], 0) : 0);
StringBuilder sbViewContent = new StringBuilder();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
sbViewContent.AppendFormat("<li style=\"width: 170px; text-align: left;\"><a title=\"浏览时间{0}\" href=\"{1}\" target=\"_blank\"><img style=\"border: 0px; vertical-align: middle;\" title=\"{2}\" src=\"{3}\" width=\"50\" height=\"40\" /> {4}</a></li>",
dr["VisitDate"], SrcRootPath + "xh.aspx?id=" + dr["VisitorId"], dr["VisitorName"], SrcRootPath + dr["VisitorHeadImage"], dr["VisitorName"]);
}
}
else
{
CommonMethod.ResponseAjaxContent(this.Page, "尚无登录用户浏览过...$" + viewcount);
return;
}
CommonMethod.ResponseAjaxContent(this.Page, "<ul>" + sbViewContent + "</ul>$" + viewcount);
}
#endregion
}
public static FNZAIKOEntity GetZaiKoInFlatWarehouseByBucketNo(string bucketNo)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNZAIKOEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNZAIKOEntity.__BUCKET_NO, bucketNo);
c.AddEqualTo(FNZAIKOEntity.__STORAGE_PLACE_FLAG, "1");//平库
return(rc.AsEntity() as FNZAIKOEntity);
}
public static FNTOUCYAKUEntity GetArrivalReport(string stationNo)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNTOUCYAKUEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNTOUCYAKUEntity.__STNO, stationNo);
c.AddEqualTo(FNTOUCYAKUEntity.__SYORIFLG, "1");
return(rc.AsEntity() as FNTOUCYAKUEntity);
}
public static bool IsSystemOnline()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNAREAEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNAREAEntity.__ARCNO, "1");
c.AddEqualTo(FNAREAEntity.__SYSTEMFLG, "1");
return(rc.AsEntity() != null);
}
private void CheckeNotes()
{
Transaction t = new Transaction();
DataTable dt = Query.ProcessSql(@"SELECT Id,Content,ReplyContent FROM XiHuan_GuestBook WITH(nolock) WHERE IsChecked=0 ", GlobalVar.DataBase_Name);
string content = string.Empty;
string replycontent = string.Empty;
int nid = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
nid = CommonMethod.ConvertToInt(dr["Id"], 0);
content = CommonMethod.FinalString(dr["Content"]);
replycontent = CommonMethod.FinalString(dr["ReplyContent"]);
if (CommonMethodFacade.ValidFFZF(content).Length == 0 && CommonMethodFacade.ValidFFZF(replycontent).Length == 0)
{
XiHuan_GuestBookEntity notesinfo = new XiHuan_GuestBookEntity();
notesinfo.Id = nid;
notesinfo.Retrieve();
if (notesinfo.IsPersistent)
{
notesinfo.IsChecked = 1;
t.AddSaveObject(notesinfo);
XiHuan_MessageEntity notechecknoticemessage = new XiHuan_MessageEntity();
notechecknoticemessage.FromId = 1;
notechecknoticemessage.FromName = "喜换网";
notechecknoticemessage.ToId = notesinfo.FromId;
notechecknoticemessage.ToName = notesinfo.FromName;
notechecknoticemessage.Content = string.Format("尊敬的喜换网会员<strong>{0}</strong>,您好：<br/>您给\"{1}\"的留言\"{2}\",已经通过审核，请注意查看!",
notesinfo.FromName, notesinfo.ToName, notesinfo.Content);
notechecknoticemessage.Flag = byte.Parse(XiHuan_MessageFacade.MessageState.未读.ToString("d"));
notechecknoticemessage.CreateDate = DateTime.Now;
t.AddSaveObject(notechecknoticemessage);
if (t.Process())
{
#region 如果是对换品页面的留言，重新生成换品页
if (CommonMethod.ConvertToInt(nid, 0) > 0)
{
RetrieveCriteria rcgoods = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
rcgoods.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
Condition cgoods = rcgoods.GetNewCondition();
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ID, notesinfo.GoodsId);
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
XiHuan_UserGoodsEntity goods = rcgoods.AsEntity() as XiHuan_UserGoodsEntity;
if (goods != null)
{
CommonMethod.readAspxAndWriteHtmlSoruce("../showdetail.aspx?id=" + notesinfo.GoodsId, "../" + goods.DetailUrl);
}
}
#endregion
}
}
}
}
}
}
public static FNRANGEEntity GetRange(string section, string line)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNRANGEEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FNRANGEEntity.__MADE_SECTION, section);
c.AddEqualTo(FNRANGEEntity.__MADE_LINE, line);
return(rc.AsEntity() as FNRANGEEntity);
}
public static FMZKEYEntity GetUnmanagedZKey(string zaikey)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FMZKEYEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(FMZKEYEntity.__ZAIKEY, zaikey);
c.AddEqualTo(FMZKEYEntity.__MANAGE_ITEM_FLAG, '1');
return(rc.AsEntity() as FMZKEYEntity);
}
public static LOGINUSEREntity GetUser(string userId, string password)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(LOGINUSEREntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(LOGINUSEREntity.__USERID, userId);
c.AddEqualTo(LOGINUSEREntity.__PASSWORD, password);
return(rc.AsEntity() as LOGINUSEREntity);
}
/// <summary>
/// 返回某个系统选项的值
/// </summary>
/// <param name="setupKey">关键字</param>
/// <returns></returns>
public string GetAppSetupValue(string setupKey)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(Entity系统选项表));
Condition c = rc.GetNewCondition();
c.AddEqualTo(Entity系统选项表.__关键字, setupKey);
Entity系统选项表 ex = (Entity系统选项表)rc.AsEntity();
return(ex.值);
}
/// <summary>
/// 读取所有系统设置选项并保存到静态哈希表
/// </summary>
public void GetAppSetup()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(Entity系统选项表));
DataTable dt = rc.AsDataTable();
foreach (DataRow row in dt.Rows)
{
Main.staticAppSetup.Add(row["关键字"].ToString(), row["值"].ToString());
}
}
public static LedMessage getLedMessageByLedNo(string ledNo, bool justStart)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(LedMessage));
Condition c = rc.GetNewCondition();
c.AddEqualTo(LedMessage.__LEDNO, ledNo);
if (!justStart)
{
c.AddEqualTo(LedMessage.__PROCESSED, '0');
}
return(rc.AsEntity() as LedMessage);
}
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 void CheckNotes(string id, string gid)
{
#region 留言通过审核,给留言人发送提醒短消息，提醒留言已通过审核
Transaction t = new Transaction();
XiHuan_GuestBookEntity notesinfo = new XiHuan_GuestBookEntity();
notesinfo.Id = CommonMethod.ConvertToInt(id, 0);
notesinfo.Retrieve();
if (notesinfo.IsPersistent)
{
notesinfo.IsChecked = 1;
t.AddSaveObject(notesinfo);
XiHuan_MessageEntity notechecknoticemessage = new XiHuan_MessageEntity();
notechecknoticemessage.FromId = 1;
notechecknoticemessage.FromName = "喜换网";
notechecknoticemessage.ToId = notesinfo.FromId;
notechecknoticemessage.ToName = notesinfo.FromName;
notechecknoticemessage.Content = string.Format("尊敬的喜换网会员<strong>{0}</strong>,您好：<br/>您给\"{1}\"的留言\"{2}\",已经通过审核，请注意查看!",
notesinfo.FromName, notesinfo.ToName, notesinfo.Content);
notechecknoticemessage.Flag = byte.Parse(XiHuan_MessageFacade.MessageState.未读.ToString("d"));
notechecknoticemessage.CreateDate = DateTime.Now;
t.AddSaveObject(notechecknoticemessage);
}
#endregion
if (t.Process())
{
#region 如果是对换品页面的留言，重新生成换品页
if (CommonMethod.ConvertToInt(gid, 0) > 0)
{
RetrieveCriteria rcgoods = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
rcgoods.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
Condition cgoods = rcgoods.GetNewCondition();
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ID, gid);
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
XiHuan_UserGoodsEntity goods = rcgoods.AsEntity() as XiHuan_UserGoodsEntity;
if (goods != null)
{
CommonMethod.readAspxAndWriteHtmlSoruce("../showdetail.aspx?id=" + gid, "../" + goods.DetailUrl);
}
}
#endregion
Alert("恭喜：留言审核成功！");
BindNotes(0);
}
else
{
t.RollBack();
}
}
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);
}
public int GetUserIdByNick(string nick)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(tb_UserEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(tb_UserEntity.__NICK,nick);
tb_UserEntity ue = (tb_UserEntity)rc.AsEntity();
if (ue != null)
{
return ue.id;
}
else
{
return 0;
}
}
public bool CheckIsOverTime(string nick)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(tb_UserEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(tb_UserEntity.__NICK,nick);
tb_UserEntity ue=(tb_UserEntity)rc.AsEntity();
//体验版或者过期
if (ue.syslevel == ((int)Util.Enum.UserSysLevel.Experience).ToString() || ue.authEndTime < DateTime.Now)
{
return false;
}
else
{
return true;
}
}
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 );
}
}
private void cmdSearch()
{
string sWhere = string.Empty;
string sOrderBy = string.Empty;
int sCount = 100;
int sBottom = 0;
bool sProxy = true;
RetrieveCriteria crit;
Console.WriteLine( "Enter SQL Where condition ex.:(Name = 'test')" );
sWhere = Console.ReadLine();
if ( string.IsNullOrEmpty( sWhere ) ) {
sWhere = "(1 = 1)";
Console.WriteLine( "Search Condition assumed as:" + sWhere );
}
// get Order request from user input
Console.WriteLine( "Enter Order By clause:" );
sOrderBy = Console.ReadLine();
if ( string.IsNullOrEmpty( sOrderBy ) )
Console.WriteLine( "No order condition" );
// get search count from user input
Console.WriteLine( "Search count:" );
try {
sCount = Convert.ToInt32( Console.ReadLine() );
} catch { } finally {
Console.WriteLine( "Count limit is: " + sCount );
}
// get bottom count from user input
Console.WriteLine( "Bottom count:" );
try {
sBottom = Convert.ToInt32( Console.ReadLine() );
} catch { } finally {
Console.WriteLine( "Bottom is: {0}", sBottom );
}
// do retrive proxy or not objects
Console.WriteLine( "Retrive proxy objects? (Y/N)" );
if ( string.Compare( Console.ReadLine(), "Y", true ) != 0 ) {
sProxy = false;
Console.WriteLine( "\tProxy switch is: {0}", sProxy );
}
crit =
new RetrieveCriteria( (new TestObject()).Type,
sWhere,
sOrderBy );
crit.CountLimit = sCount;
crit.BottomLimit = sBottom;
crit.AsProxies = sProxy;
Console.WriteLine( DateTime.Now.ToLongTimeString() +
": Search request begin" );
crit.Perform();
Console.WriteLine( DateTime.Now.ToLongTimeString() +
": Search request completed" );
Console.WriteLine( "Was found: " + crit.Count );
if ( crit.Count > 0 ) {
Console.WriteLine( "Count to list:" );
try {
int count = Convert.ToInt32( Console.ReadLine() );
for ( int i = 0; i < count; i++ ) {
Console.WriteLine( crit[i].ID + "\t" + crit[i].Name + "\t" + crit[i].Stamp.ToString() );
}
} catch {
Console.WriteLine( crit[0].ID + "\t" + crit[0].Name + "\t" + crit[0].Stamp.ToString() );
}
}
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_RecommendResultEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_RecommendResultEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_RecommendResultEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_RecommendResultEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_GoldTimeslotSchemeDetailsEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_GoldTimeslotSchemeDetailsEntity));
return rc.AsDataTable();
}
public void Search_1LoadTest() {
RetrieveCriteria ret_crit = new RetrieveCriteria((new TestObject()).Type, "( Name = '" + m_obj_name + "')");
ret_crit.AsProxies = true;
ret_crit.Perform();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_User_SwitchEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_User_SwitchEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_TraderateContextEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_TraderateContextEntity));
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 DataTable Gettb_ScheduleRecommendQueueEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_ScheduleRecommendQueueEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_MessageQueueEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_MessageQueueEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_MessageQueueEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_MessageQueueEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_GoldTimeslotSchemeDetailsEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_GoldTimeslotSchemeDetailsEntity));
return rc.AsEntityContainer();
}
private void cmdAddError()
{
RetrieveCriteria rc = new RetrieveCriteria( (new TestObject()).Type, " (fail :)");
if( m_trans == null ) {
rc.Perform();
} else {
TestObject obj = new TestObject();
obj.FailOn = TestObject.FAIL.Save;
m_trans.Add( obj, PersistentTransaction.ACTION.Save );
}
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_LdleTimeslotEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_LdleTimeslotEntity));
return rc.AsEntityContainer();
}
public void SaveRetriveSearchTransTest()
{
PersistentTransaction trans;
RetrieveCriteria ret_crit;
// common variables
TestObject obj;
int _id_expected;
string _name_expected;
DateTime _stamp_expected;
string _string_expected;
int? _int_expected;
bool? _boolean_expected;
double? _double_expected;
DateTime? _datetime_expected;
obj = new TestObject();
_name_expected = obj.Name = m_obj_name + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
_int_expected = obj._int = 1234567890;
_boolean_expected = obj._bool = true;
_string_expected = obj._string =
@"Test строка (ї,ё) 1@№" + DateTime.Now.ToString();
obj._datetime = DateTime.Now;
_double_expected = obj._double = (double) 1 / 33;
obj.Save();
_id_expected = obj.ID;
_stamp_expected = obj.Stamp;
_datetime_expected = obj._datetime;
#region check props after save
Assert.AreEqual( _name_expected, obj.Name );
Assert.AreEqual( _int_expected, obj._int );
Assert.AreEqual( _boolean_expected, obj._bool );
Assert.AreEqual( _string_expected, obj._string );
Assert.IsTrue( DateTime.Equals(_datetime_expected, obj._datetime ));
Assert.IsTrue( DateTime.Equals( _stamp_expected, obj.Stamp ) );
Assert.AreEqual( _double_expected, obj._double );
#endregion
// check property update in transaction
_name_expected = obj.Name = m_obj_name + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
_int_expected = obj._int = int.MaxValue;
_boolean_expected = obj._bool = !obj._bool;
_string_expected = obj._string = obj.Name;
_datetime_expected = obj._datetime = DateTime.Now;
_double_expected = obj._double = (double) 2 / 33;
trans = new PersistentTransaction(obj, PersistentTransaction.ACTION.Save );
trans.Process();
_stamp_expected = obj.Stamp;
_datetime_expected = obj._datetime;
ret_crit = new RetrieveCriteria( obj.Type, "(ID = " + obj.ID );
ret_crit.Perform();
if( ret_crit.Count != 1 ) {
Assert.Fail( "Update object in transaction failed!" );
} else {
#region check props
Assert.AreEqual( _name_expected, ((TestObject)ret_crit[0]).Name );
Assert.AreEqual( _int_expected, ((TestObject) ret_crit[0])._int );
Assert.AreEqual( _boolean_expected, ((TestObject) ret_crit[0])._bool );
Assert.AreEqual( _string_expected, ((TestObject) ret_crit[0])._string );
Assert.IsTrue( DateTime.Equals( _datetime_expected,
((TestObject) ret_crit[0])._datetime ) );
Assert.IsTrue( DateTime.Equals( _stamp_expected,
((TestObject) ret_crit[0]).Stamp ) );
Assert.AreEqual( _double_expected,
((TestObject) ret_crit[0])._double );
#endregion
}
// check property update in failed transaction
_name_expected= obj.Name = m_obj_name + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
_int_expected = obj._int = int.MaxValue;
_boolean_expected = obj._bool = !obj._bool;
_string_expected = obj._string = obj.Name;
_datetime_expected = obj._datetime = DateTime.Now;
_double_expected = obj._double = (double) 3 / 33;
trans = new PersistentTransaction( obj, PersistentTransaction.ACTION.Save );
TestObject fObj = new TestObject();
fObj.FailOn = TestObject.FAIL.Save;
trans.Add( fObj, PersistentTransaction.ACTION.Save );
// run transaction
try {
trans.Process();
Assert.Fail( "Exception wasn't raised" );
} catch {/*catch exception that will be*/}
// retrive object to check that nothing was changed
ret_crit = new RetrieveCriteria( obj.Type, "(ID = " + obj.ID + ")" );
ret_crit.Perform();
if( ret_crit.Count != 1 ) {
Assert.Fail( "Update object in transaction failed!" );
} else {
#region check props
Assert.IsTrue( DateTime.Equals( _stamp_expected,
((TestObject) ret_crit[0]).Stamp ) );
Assert.AreEqual( _name_expected, ((TestObject) ret_crit[0]).Name );
Assert.AreEqual( _int_expected, ((TestObject) ret_crit[0])._int );
Assert.AreEqual( _boolean_expected, ((TestObject) ret_crit[0])._bool );
Assert.AreEqual( _string_expected, ((TestObject) ret_crit[0])._string );
Assert.IsTrue( DateTime.Equals( _datetime_expected,
((TestObject) ret_crit[0])._datetime ) );
Assert.AreEqual( _double_expected, ((TestObject) ret_crit[0])._double );
#endregion
}
#region delete + failed
trans = new PersistentTransaction();
trans.Add( ret_crit[0], PersistentTransaction.ACTION.Delete );
fObj = new TestObject();
fObj.FailOn = TestObject.FAIL.Save;
trans.Add( fObj, PersistentTransaction.ACTION.Save );
try {
trans.Process();
Assert.Fail( "Exception wasn't raised" );
} catch {/*catch exception that will be*/}
ret_crit.Perform();
// object must exist
Assert.IsTrue( (ret_crit.CountFound == 1),
"rollbacked transaction didn't recover deleted object" );
#endregion
#region delete
trans = new PersistentTransaction();
trans.Add( ret_crit[0], PersistentTransaction.ACTION.Delete );
trans.Process();
ret_crit.Perform();
// object must not exist
Assert.IsTrue( (ret_crit.CountFound == 0),
"transaction didn't delete object" );
#endregion
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_User_SwitchEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_User_SwitchEntity));
return rc.AsEntityContainer();
}
public void SaveRetriveSearchTest()
{
// common variables
TestObject obj;
RetrieveCriteria ret_crit;
int _id_expected;
string _name_expected;
DateTime _stamp_expected;
string _string_expected;
int? _int_expected;
bool? _boolean_expected;
double? _double_expected;
DateTime? _datetime_expected;
obj = new TestObject();
_name_expected = obj.Name = m_obj_name + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
_int_expected = obj._int = 1234567890;
_boolean_expected = obj._bool = true;
_string_expected = obj._string =
@"Test строка (ї,ё) 1@№" + DateTime.Now.ToString();
obj._datetime = DateTime.Now;
_double_expected = obj._double = (double) 1 / 33;
// create parent object
TestObject parent = new TestObject();
parent.Name = _name_expected;
parent._int = _int_expected;
//end
obj.Parents.Add( parent );
obj.Save(); //save object
// save data here because of change that can be during conversion to sql pressision
_datetime_expected = obj._datetime;
_id_expected = obj.ID;
_stamp_expected = obj.Stamp;
#region check props after save
Assert.AreEqual( _name_expected, obj.Name );
Assert.AreEqual( _int_expected, obj._int );
Assert.AreEqual( _boolean_expected, obj._bool );
Assert.AreEqual( _string_expected, obj._string);
Assert.IsTrue( DateTime.Equals( _stamp_expected, obj.Stamp ));
Assert.AreEqual( _double_expected, obj._double );
// parent check
foreach (PersistentObject link_obj in obj.Parents ) {
Assert.AreEqual(_name_expected, link_obj.Name );
}
#endregion
// by string equality
ret_crit =
new RetrieveCriteria(
(new TestObject()).Type,
"(_string = '" + _string_expected +"')" );
ret_crit.Perform();
Assert.IsTrue( ( ret_crit.CountFound == 1 ), "Search by _string failed");
Assert.AreEqual( _id_expected, ret_crit[0].ID );
// check properties
Assert.AreEqual( _name_expected, ((TestObject)ret_crit[0]).Name );
Assert.AreEqual( _int_expected, ((TestObject)ret_crit[0])._int );
Assert.AreEqual( _boolean_expected, ((TestObject)ret_crit[0])._bool );
Assert.AreEqual( _string_expected, ((TestObject)ret_crit[0])._string );
Assert.AreEqual( _stamp_expected, ((TestObject)ret_crit[0]).Stamp );
Assert.AreEqual( _datetime_expected, ((TestObject)ret_crit[0])._datetime );
Assert.AreEqual( _double_expected, ((TestObject)ret_crit[0])._double );
// by LIKE
ret_crit =
new RetrieveCriteria(
(new TestObject()).Type,
"( _string LIKE '%" +
_string_expected.Substring( 2, _string_expected.Length - 2 ) +
"%')" );
ret_crit.Perform();
Assert.IsTrue( ( ret_crit.CountFound == 1 ), "Search by 'Like' failed");
Assert.AreEqual( _id_expected, ret_crit[0].ID );
// by string NOT LIKE
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( _string NOT LIKE '%" +
_string_expected.Substring( 2, _string_expected.Length - 2 ) +
"%')" );
ret_crit.Perform();
bool found = false;
int i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsFalse( found, "Search by 'NOT LIKE' failed" );
// by ID
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( ID = " + _id_expected + ")" );
ret_crit.Perform();
Assert.IsTrue( ( ret_crit.CountFound == 1 ), "Search by id failed");
Assert.AreEqual( _id_expected, ret_crit[0].ID );
// by NOT ID
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( ID <> " + _id_expected + ")" );
ret_crit.Perform();
found = false;
i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsFalse( found, "search by '<> ID' condition failed" );
// by bit
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( _bool = CAST(" + ((bool)_boolean_expected ? 1 : 0) + " as bit))" );
ret_crit.Perform();
found = false;
i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsTrue( found, "search by _bool failed" );
// by <> bit
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( _bool <> CAST(" + ((bool)_boolean_expected ? 1 : 0) + " as bit))" );
ret_crit.Perform();
found = false;
i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsFalse( found, "search by '<> _bool' failed" );
#region
// by int
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( _int = " + _int_expected + ")" );
ret_crit.Perform();
found = false;
i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsTrue( found, "search by _int failed" );
// by <> int
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( _int <> " + _int_expected + ")" );
ret_crit.Perform();
found = false;
i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsFalse( found, "search by '<> _int' condition failed" );
#endregion
// by datetime
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( _datetime = CAST('" +
_datetime_expected.Value.ToString( "yyyy-MM-dd HH:mm:ss.fff" ) +
"' as datetime))" );
ret_crit.Perform();
found = false;
i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsTrue( found, "Search by _datetime failed" );
// by <> datetime
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( _datetime <> CAST('" +
_datetime_expected.Value.ToString( "yyyy-MM-dd HH:mm:ss.fff" ) +
"' as datetime))" );
ret_crit.Perform();
found = false;
i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsFalse( found, "Search by '<> _datetime' failed" );
// by double
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( _double = CAST(" + _double_expected.Value.ToString( "R" )
.Replace( ",", "." ) +
" as float ))" );
ret_crit.Perform();
found = false;
i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsTrue( found, "Search by _double failed" );
// by NOT double
ret_crit = new RetrieveCriteria(
(new TestObject()).Type,
"( _double <> CAST(" + _double_expected.Value.ToString( "R" )
.Replace(",",".") +
" as float ))" );
ret_crit.Perform();
found = false;
i = 0;
while ( i < ret_crit.CountFound && !found ) {
if ( ret_crit[i].ID == _id_expected ) {
found = true;
break;
}
i++;
}
Assert.IsFalse( found, "Search by '<> _double' failed" );
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_LdleTimeslotEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_LdleTimeslotEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_RelistReslutEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_RelistReslutEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_TraderateContextEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_TraderateContextEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_InGoldTimeItemsEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_InGoldTimeItemsEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_InGoldTimeItemsEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_InGoldTimeItemsEntity));
return rc.AsEntityContainer();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static EntityContainer Retrievetb_RelistReslutEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_RelistReslutEntity));
return rc.AsEntityContainer();
}
