public string GetUserPassword(string userID)
{
object pwd = null;
using (TransactionScope scope = this.transactionScopeFactory.NewTransactionScope())
{
IOrmAccesser <GGUser> accesser = scope.NewOrmAccesser <GGUser>();
pwd = accesser.GetColumnValue(userID, GGUser._PasswordMD5);
scope.Commit();
}
if (pwd == null)
{
return(null);
}
return(pwd.ToString());
}
public void Run0(bool isHash)
{
IList <ELDB2.Storages> list = null;
IList <ELDB2.Storages> list1 = null;
using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false))
{
System.Console.WriteLine(System.DateTime.Now.Second + "：" + System.DateTime.Now.Millisecond);
ELDB2.HashSelectHandle hashTable = null;
Hashtable hashTable1 = null;
IOrmAccesser <ELDB2.Storages> storages = ELDB2.DBFactory.NewOrmAccesser <ELDB2.Storages>(scope);
Filter filter = new Filter(ELDB2.Storages._Sign, 0, ComparisonOperators.Equal);
list1 = storages.GetMuch(filter);
if (isHash)
{
IRelationAccesser r = scope.NewRelationAccesser();
DataTable tb = r.DoQuery("select * from storages order by Address").Tables[0];
hashTable = new ELDB2.HashSelectHandle(tb);
}
else
{
list = storages.GetAll();
}
for (int mm = 0; mm < 1; mm++)
{
if (list1 != null)
{
foreach (ELDB2.Storages storage1 in list1)
{
if (isHash)
{
//hashTable1 = hashTable.Select(ELDB2.Storages._Address, storage1.Address);
list = hashTable.Select <ELDB2.Storages, string>(ELDB2.Storages._Address, storage1.Address);
IEnumerable <ELDB2.Storages> storages1 = from storage in list
where storage.Address == storage1.Address
orderby storage.Address
select storage;
foreach (ELDB2.Storages item in storages1)
{
item.Act = "10";
hashTable.Update <ELDB2.Storages, string>(item);
}
}
else
{
IEnumerable <String> Address = from storage in list
where storage.Address == storage1.Address
orderby storage.Address
select storage.Address;
foreach (string item in Address)
{
System.Console.WriteLine(item);
}
}
}
}
}
System.Console.WriteLine(System.DateTime.Now.Second + "：" + System.DateTime.Now.Millisecond);
// =========================
scope.Commit();
}
}
public static void getdata()
{
IList <ELDB2.Sy_ShowInfo> list = null;
IList <ELDB2.Storages> list1 = null;
using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false))
{
IOrmAccesser <ELDB2.Sy_ShowInfo> ShowInfo = ELDB2.DBFactory.NewOrmAccesser <ELDB2.Sy_ShowInfo>(scope);
Filter filter = new Filter(ELDB2.Sy_ShowInfo._ReadState, 0, ComparisonOperators.Equal);
list = ShowInfo.GetMuch(filter);
foreach (ELDB2.Sy_ShowInfo showinfo in list)
{
IOrmAccesser <ELDB2.Storages> storages = ELDB2.DBFactory.NewOrmAccesser <ELDB2.Storages>(scope);
Filter filter1 = new Filter(ELDB2.Storages._StorageID, showinfo.StorageID, ComparisonOperators.Equal);
foreach (ELDB2.Storages storage in list1)
{
if (storage.Sign == 0)
{
switch (showinfo.OperateType)
{
case 1:
storage.Act = "入库";
break;
case 2:
storage.Act = "出库";
break;
case 3:
storage.Act = "库存";
break;
case 4:
storage.Act = "移入";
break;
case 5:
storage.Act = "移出";
break;
case 6:
storage.Act = "移库";
break;
default:
break;
}
storage.ProductName = showinfo.TobaccoName;
storage.Contents = (showinfo.OperatePiece > 0 ? showinfo.OperatePiece.ToString() + "件" : "") + (showinfo.OperateItem > 0 ? showinfo.OperateItem + "条" : "");
storage.Sign = 1;
showinfo.ReadState = 1;
storages.Update(storage);
ShowInfo.Update(showinfo);
}
}
}
scope.Commit();
}
}
public void Run1()
{
IList <ELDB2.Storages> list = null;
using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false))
{
IOrmAccesser <ELDB2.Storages> storages = ELDB2.DBFactory.NewOrmAccesser <ELDB2.Storages>(scope);
Filter filter = new Filter(ELDB2.Storages._Sign, 1, ComparisonOperators.Equal);
ELDB2.Storages storage1 = storages.GetOne(filter);
if (storage1 != null)
{
Filter filter1 = new Filter(ELDB2.Storages._Address, storage1.Address, ComparisonOperators.Equal);
list = storages.GetMuch(filter1);
string[] data = new string[5];
for (int i = 0; i < 5; i++)
{
data[i] = "";
}
foreach (ELDB2.Storages storage in list)
{
string s1, s2, s3, s4;
switch ("mode1")
{
case "mode1":
s1 = storage.StorageName.Trim() + " " + storage.Act.Trim() + " " + storage.Contents.Trim() + storage.ProductName.Trim() + "".PadRight(56, " "[0]);
s1 = StrHandle.GetStringWith(s1, 56);
if (storage.Row == "3")
{
data[0] = s1;
}
if (storage.Row == "2")
{
data[1] = s1;
}
if (storage.Row == "1")
{
data[2] = s1;
}
break;
case "mode2":
s1 = "储位：" + storage.StorageName.Trim();
s1 = StrHandle.GetStringWith(s1, 24);
s2 = "操作：" + storage.Act.Trim();
s2 = StrHandle.GetStringWith(s2, 24);
s3 = "品牌：" + storage.ProductName.Trim();
s3 = StrHandle.GetStringWith(s3, 24);
s4 = "数量：" + storage.Contents.Trim();
s4 = StrHandle.GetStringWith(s4, 20);
data[0] = s1;
data[0] = data[0] + s2;
data[0] = data[0] + s3;
data[0] = data[0] + s4;
break;
default:
break;
}
storage.Sign = 2;
storages.Update(storage);
IRelationAccesser ra = scope.NewRelationAccesser();
ra.DoCommand("Update [Sy_ShowInfo] set [HardwareReadState] = 1 where ReadState =1 and [StorageID] = '" + storage.StorageID + "'");
}
//this.elOpertor.SendData(int.Parse(storage1.Address.Substring(storage1.Address.Length - 2, 2)), data);
}
scope.Commit();
}
}
public void Run(bool isHash)
{
IList <ELDB2.Storages> list = null;
IList <ELDB2.Storages> list1 = null;
using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false))
{
System.Console.WriteLine(System.DateTime.Now.Second + "：" + System.DateTime.Now.Millisecond);
ELDB2.HashSelectHandle hashTable = null;
if (isHash)
{
IRelationAccesser r = scope.NewRelationAccesser();
DataTable tb = r.DoQuery("select * from storages order by Address").Tables[0];
hashTable = new ELDB2.HashSelectHandle(tb);
}
for (int mm = 0; mm < 5; mm++)
{
IOrmAccesser <ELDB2.Storages> storages = ELDB2.DBFactory.NewOrmAccesser <ELDB2.Storages>(scope);
Filter filter = new Filter(ELDB2.Storages._Sign, 0, ComparisonOperators.Equal);
list1 = storages.GetMuch(filter);
if (list1 != null)
{
foreach (ELDB2.Storages storage1 in list1)
{
if (isHash)
{
list = hashTable.Select <ELDB2.Storages, string>(ELDB2.Storages._Address, storage1.Address);
}
else
{
Filter filter1 = new Filter(ELDB2.Storages._Address, storage1.Address, ComparisonOperators.Equal);
list = storages.GetMuch(filter1);
}
string[] data = new string[5];
for (int i = 0; i < 5; i++)
{
data[i] = "";
}
foreach (ELDB2.Storages storage in list)
{
string s1, s2, s3, s4;
switch ("mode1")
{
case "mode1":
s1 = storage.StorageName.Trim() + " " + storage.Act.Trim() + " " + storage.Contents.Trim() + storage.ProductName.Trim() + "".PadRight(56, " "[0]);
s1 = StrHandle.GetStringWith(s1, 56);
if (storage.Row == "3")
{
data[0] = s1;
}
if (storage.Row == "2")
{
data[1] = s1;
}
if (storage.Row == "1")
{
data[2] = s1;
}
break;
case "mode2":
s1 = "储位：" + storage.StorageName.Trim();
s1 = StrHandle.GetStringWith(s1, 24);
s2 = "操作：" + storage.Act.Trim();
s2 = StrHandle.GetStringWith(s2, 24);
s3 = "品牌：" + storage.ProductName.Trim();
s3 = StrHandle.GetStringWith(s3, 24);
s4 = "数量：" + storage.Contents.Trim();
s4 = StrHandle.GetStringWith(s4, 20);
data[0] = s1;
data[0] = data[0] + s2;
data[0] = data[0] + s3;
data[0] = data[0] + s4;
break;
default:
break;
}
storage.Sign = 0;
//storages.Update(storage);
IRelationAccesser ra = scope.NewRelationAccesser();
//ra.DoCommand("Update [Sy_ShowInfo] set [HardwareReadState] = 1 where ReadState =1 and [StorageID] = '" + storage.StorageID + "'");
}
//this.elOpertor.SendData(int.Parse(storage1.Address.Substring(storage1.Address.Length - 2, 2)), data);
}
}
}
System.Console.WriteLine(System.DateTime.Now.Second + "：" + System.DateTime.Now.Millisecond);
// =========================
scope.Commit();
}
}
/// <summary>
/// 获取一页与好友的聊天记录。
/// </summary>
/// <param name="myID">自己的UserID</param>
/// <param name="friendID">好友的ID</param>
/// <param name="pageSize">页大小</param>
/// <param name="pageIndex">页索引</param>
/// <returns>聊天记录页</returns>
public ChatRecordPage GetChatRecordPage(ChatRecordTimeScope chatRecordTimeScope, string myID, string friendID, int pageSize, int pageIndex)
{
if (this.transactionScopeFactory == null)
{
return(new ChatRecordPage(0, 0, new List <ChatMessageRecord>()));
}
DateTimeScope timeScope = null;
DateTime now = DateTime.Now;
if (chatRecordTimeScope == ChatRecordTimeScope.RecentWeek) //一周
{
timeScope = new DateTimeScope(now.AddDays(-7), now);
}
else if (chatRecordTimeScope == ChatRecordTimeScope.RecentMonth)//一月
{
timeScope = new DateTimeScope(now.AddDays(-31), now);
}
else if (chatRecordTimeScope == ChatRecordTimeScope.Recent3Month)//三月
{
timeScope = new DateTimeScope(now.AddDays(-91), now);
}
else //全部
{
}
IFilterTree tree1 = new SimpleFilterTree(new Filter(ChatMessageRecord._SpeakerID, myID), new Filter(ChatMessageRecord._AudienceID, friendID));
IFilterTree tree2 = new SimpleFilterTree(new Filter(ChatMessageRecord._SpeakerID, friendID), new Filter(ChatMessageRecord._AudienceID, myID));
IFilterTree tree = new ComplexFilterTree(LogicType.Or, tree1, tree2);
if (timeScope != null)
{
tree = new ComplexFilterTree(LogicType.And, tree, new Filter(ChatMessageRecord._OccureTime, new DateTime[] { timeScope.StartDate, timeScope.EndDate }, ComparisonOperators.BetweenAnd));
}
//最后一页
if (pageIndex == int.MaxValue)
{
int total = 0;
using (TransactionScope scope = this.transactionScopeFactory.NewTransactionScope())
{
IOrmAccesser <ChatMessageRecord> accesser = scope.NewOrmAccesser <ChatMessageRecord>();
total = (int)accesser.GetCount(tree);
scope.Commit();
}
int pageCount = total / pageSize;
if (total % pageSize > 0)
{
pageCount += 1;
}
pageIndex = pageCount - 1;
}
int totalCount = 0;
ChatMessageRecord[] page = null;
using (TransactionScope scope = this.transactionScopeFactory.NewTransactionScope())
{
IOrmAccesser <ChatMessageRecord> accesser = scope.NewOrmAccesser <ChatMessageRecord>();
page = accesser.GetPage(tree, pageSize, pageIndex, ChatMessageRecord._AutoID, true, out totalCount);
scope.Commit();
}
return(new ChatRecordPage(totalCount, pageIndex, new List <ChatMessageRecord>(page)));
}
public static IOrmAccesser <TEntity> NewOrmAccesser <TEntity>(TransactionScope scope)
{
IOrmAccesser <TEntity> accesser = scope.NewOrmAccesser <TEntity>();
return(accesser);
}
public static IOrmAccesser <TEntity> NewOrmAccesser <TEntity>()
{
IOrmAccesser <TEntity> accesser = NewTransactionScope(false).NewOrmAccesser <TEntity>();
return(accesser);
}
