/// <summary>
/// 添加ApplicationDetail数据
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int SubmitApplicationDetail(DataTable dt, double douTotalPrice, string strUID, int intFlag)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
foreach (DataRow dr in dt.Rows)
{
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Insert into [ApplicationDetail]");
insertSql.Append(" ([CodeID],[TransNo],[ItemID],[Detail],[Price],[MoneyUnit],[Count],[IsDelete],[SelforGift],[ApprovalCount],[ApprovalDiscount],[FinalPrice],[Recipient],[Relationship],[Reason],[IsSuccess],[PhoneNum]) ");
insertSql.Append("values");
insertSql.AppendFormat(" ('{0}','{1}','{2}','{3}',{4},{5},{6},{7},{8},{9},{10},{11},'{12}','{13}','{14}',{15},'{16}')", dr["CodeID"], dr["TransNo"], dr["ItemID"], dr["Detail"], dr["Price"], dr["MoneyUnit"], dr["Count"], dr["IsDelete"], dr["SelforGift"], dr["ApprovalCount"], dr["ApprovalDiscount"], dr["FinalPrice"], dr["Recipient"], dr["Relationship"], dr["Reason"], dr["IsSuccess"], dr["PhoneNum"]);
sq.InsertQuery(insertSql.ToString(), "Cache" + strUID, dr["TransNo"].ToString(), douTotalPrice, intFlag);
}
sq.Close();
return(1);
}
catch (Exception)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 添加商品表数据Items
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int InsertItems(DataTable dt)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
foreach (DataRow dr in dt.Rows)
{
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Insert into [Items]");
insertSql.Append(" ([ItemID],[Price],[Price2],[Price3],[Price4],[Price5],[Price6],[Price7],[Price8],[Price9],[Price10],[Detail],[IsDelete],[IsSpecial],[ItemName]) ");
insertSql.Append("values");
insertSql.AppendFormat(" ('{0}',{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},'{11}',{12},{13},'{14}')", dr["ItemID"], dr["Price"], dr["Price2"], dr["Price3"], dr["Price4"], dr["Price5"], dr["Price6"], dr["Price7"], dr["Price8"], dr["Price9"], dr["Price10"], dr["Detail"], dr["IsDelete"], dr["IsSpecial"], dr["ItemName"]);
sq.InsertQuery(insertSql.ToString(), "", "", 0, 0);
}
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
}
/// <summary>
/// 添加店面信息表StoreInfo
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int InsertStoreInfo(DataTable dt)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
foreach (DataRow dr in dt.Rows)
{
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Insert into [StoreInfo]");
insertSql.Append(" ([StoreName],[Address],[Contact],[Tel],[IsDelete]) ");
insertSql.Append("values");
insertSql.AppendFormat(" ('{0}','{1}','{2}','{3}',{4})", dr["StoreName"], dr["Address"], dr["Contact"], dr["Tel"], dr["IsDelete"]);
sq.InsertQuery(insertSql.ToString(), "", "", 0, 0);
}
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
}
/// <summary>
/// 修改店面信息表StoreInfo
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int UpdateStoreInfo(DataTable dt)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
foreach (DataRow dr in dt.Rows)
{
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Update [StoreInfo] set ");
insertSql.AppendFormat(" [StoreName]='{0}',", dr["StoreName"]);
insertSql.AppendFormat(" [Address]='{0}',", dr["Address"]);
insertSql.AppendFormat(" [Contact]='{0}',", dr["Contact"]);
insertSql.AppendFormat(" [Tel]='{0}',", dr["Tel"]);
insertSql.AppendFormat(" [IsDelete]={0}", dr["IsDelete"]);
insertSql.AppendFormat(" where [ID]={0}", dr["ID"]);
sq.InsertQuery(insertSql.ToString(), "", "", 0, 0);
}
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 添加用户Users
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int InsertUser(Users user)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Insert into [Users]");
insertSql.Append(" ([UID],[EmployeeID],[UserName],[UserPwd],[Tel],[Email],[Position],[Department],[Detail],[IsAdmin],[Character],[IsDelete],[TotalAmount],[UsedAmount],[RestAmount],[MoneyUnit],[ManagerID],[IsAble],[Store],[EmpDate]) ");
insertSql.Append("values");
insertSql.AppendFormat(" ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',{9},{10},{11},{12},{13},{14},{15},'{16}',{17},'{18}',#{19}#)", user.UID, user.EmployeeID, user.UserName, user.UserPwd, user.Tel, user.Email, user.Position, user.Department, user.Detail, user.IsAdmin, user.Character, user.IsDelete, user.TotalAmount, user.UsedAmount, user.RestAmount, user.MoneyUnit, user.ManagerID, user.IsAble, user.Store, user.EmpDate);
sq.InsertQuery(insertSql.ToString(), "", "", 0, 0);
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
}
/// <summary>
/// 将提交的申请表Info插入数据库ApplicationInfo，添加申请表数据
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int SubmitApplicationInfo(DataTable dt, double douTotalPrice, string strUID, int intFlag)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
foreach (DataRow dr in dt.Rows)
{
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Insert into [ApplicationInfo]");
insertSql.Append(" ([TransNo],[Applicants],[ApplicantsName],[ApplicantsNo],[Location],[ApplicantsDate],[Approval],[ApprovalName],[ApprovalDate],[Approval2],[ApprovalName2],[ApprovalDate2],[TotalPrice],[Deadline],[SalesDate],[PurchaseLocation],[Store],[StoreName],[ApprovalState],[ApprovalState2],[StaffApproval],[StaffID],[StaffName],[IsDelete],[AppState],[UnCode],[MoneyUnit],[EditRemark]) ");
insertSql.Append("values");
insertSql.AppendFormat(" ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}',{12},'{13}','{14}','{15}','{16}','{17}',{18},{19},{20},'{21}','{22}',{23},{24},'{25}',{26},'{27}')", dr["TransNo"], dr["Applicants"], dr["ApplicantsName"], dr["ApplicantsNo"], dr["Location"], dr["ApplicantsDate"], dr["Approval"], dr["ApprovalName"], dr["ApprovalDate"], dr["Approval2"], dr["ApprovalName2"], dr["ApprovalDate2"], dr["TotalPrice"], dr["Deadline"], dr["SalesDate"], dr["PurchaseLocation"], dr["Store"], dr["StoreName"], dr["ApprovalState"], dr["ApprovalState2"], dr["StaffApproval"], dr["StaffID"], dr["StaffName"], dr["IsDelete"], dr["AppState"], dr["UnCode"], dr["MoneyUnit"], dr["EditRemark"]);
sq.InsertQuery(insertSql.ToString(), "Cache" + strUID, dr["TransNo"].ToString(), douTotalPrice, intFlag);
}
sq.Close();
return(1);
}
catch (Exception)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 修改申请表数据ApplicationInfo
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int UpdateApplicationInfo(DataTable dt, double douTotalPrice, string strUID, int intFlag)
{
int rows = 0;
DataTable insertDT = dt.Clone();
try
{
SqlQueue sq = new SqlQueue();
foreach (DataRow dr in dt.Rows)
{
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Update [ApplicationInfo] set ");
insertSql.AppendFormat(" [TransNo]='{0}',", dr["TransNo"]);
insertSql.AppendFormat(" [Applicants]='{0}',", dr["Applicants"]);
insertSql.AppendFormat(" [ApplicantsName]='{0}',", dr["ApplicantsName"]);
insertSql.AppendFormat(" [ApplicantsNo]='{0}',", dr["ApplicantsNo"]);
insertSql.AppendFormat(" [Location]='{0}',", dr["Location"]);
insertSql.AppendFormat(" [ApplicantsDate]='{0}',", dr["ApplicantsDate"]);
insertSql.AppendFormat(" [Approval]='{0}',", dr["Approval"]);
insertSql.AppendFormat(" [ApprovalName]='{0}',", dr["ApprovalName"]);
insertSql.AppendFormat(" [ApprovalDate]='{0}',", dr["ApprovalDate"]);
insertSql.AppendFormat(" [Approval2]='{0}',", dr["Approval2"]);
insertSql.AppendFormat(" [ApprovalName2]='{0}',", dr["ApprovalName2"]);
insertSql.AppendFormat(" [ApprovalDate2]='{0}',", dr["ApprovalDate2"]);
insertSql.AppendFormat(" [TotalPrice]={0},", dr["TotalPrice"]);
//insertSql.AppendFormat(" [Deadline]='{0}',", dr["Deadline"]);
insertSql.AppendFormat(" [SalesDate]='{0}',", dr["SalesDate"]);
insertSql.AppendFormat(" [PurchaseLocation]='{0}',", dr["PurchaseLocation"]);
insertSql.AppendFormat(" [Store]='{0}',", dr["Store"]);
insertSql.AppendFormat(" [StoreName]='{0}',", dr["StoreName"]);
insertSql.AppendFormat(" [ApprovalState]={0},", dr["ApprovalState"]);
insertSql.AppendFormat(" [ApprovalState2]={0},", dr["ApprovalState2"]);
insertSql.AppendFormat(" [StaffApproval]={0},", dr["StaffApproval"]);
insertSql.AppendFormat(" [StaffID]='{0}',", dr["StaffID"]);
insertSql.AppendFormat(" [StaffName]='{0}',", dr["StaffName"]);
insertSql.AppendFormat(" [IsDelete]={0},", dr["IsDelete"]);
insertSql.AppendFormat(" [AppState]={0},", dr["AppState"]);
insertSql.AppendFormat(" [EditReason]='{0}',", dr["EditReason"]);
insertSql.AppendFormat(" [MoneyUnit]={0},", dr["MoneyUnit"]);
insertSql.AppendFormat(" [EditRemark]='{0}',", dr["EditRemark"]);
insertSql.AppendFormat(" [UnCode]='{0}'", dr["UnCode"]);
insertSql.AppendFormat(" where [ID]={0}", dr["ID"]);
sq.InsertQuery(insertSql.ToString(), "Cache" + strUID, dr["TransNo"].ToString(), douTotalPrice, intFlag);
StringBuilder RunSql = new StringBuilder();
RunSql.Append("Update [ApplicationInfo] set ");
RunSql.AppendFormat(" [Deadline]='{0}' ", dr["Deadline"]);
RunSql.AppendFormat(" where [ID]={0}", dr["ID"]);
sq.InsertQuery(RunSql.ToString(), "Cache" + strUID, dr["TransNo"].ToString(), douTotalPrice, 2);
}
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
private void toolStripButton6_Click(object sender, EventArgs e)
{
bool connSuccess = false;
try
{
AccessHelper ah = new AccessHelper();
ah.Close();
connSuccess = true;
}
catch
{
MessageBox.Show("远程缓存同步失败", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
connSuccess = false;
}
if (connSuccess)
{
try
{
SqlQueue sq = new SqlQueue();
sq.QuickExecuteSqlQuery();
sq.Close();
//MessageBox.Show("远程缓存同步完成,远程服务器每小时轮询处理一次,在此期间,您无法查看到新处理的结果,请勿重复操作!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
MessageBox.Show("远程缓存同步完成", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
}
}
}
public void SetupQueue()
{
var x = new SqliteQueueManager(new SqliteInMemoryConnection(), new DefaultSqlQueueTableNameEncoder());
x.CreateCoreTablesIfNotExist();
x.CreateQueueIfNotExist("TestQueue");
Queue = new SqlQueue("Queue_TestQueue", x.Connection);
}
protected override void TestSetUp()
{
inboxQueue = new SqlQueue(new Uri("sql://shuttle/queue-inbox"));
outboxQueue = new SqlQueue(new Uri("sql://shuttle/queue-outbox"));
inboxQueue.Create();
outboxQueue.Create();
inboxQueue.Purge();
outboxQueue.Purge();
}
private static void CreateQueue(out Dictionary <string, Queue <object> > queues, out SqlQueue queue)
{
var q = new Queue <object>();
q.Enqueue(1);
queues = new Dictionary <string, Queue <object> >();
queues.Add("QUEUEDESTINATION", q);
var fake = new FakeSqlServerBroker(queues, "QUEUEDESTINATION");
var parameters = new SqlQueueParameters("", "SERVICEORIGIN", "SERVICEDESTINATION", "CONTRACT", "MESSAGETYPE", "QUEUEORIGIN", "QUEUEDESTINATION", "QUEUEBAGGAGE");
queue = new SqlQueue(fake, parameters);
}
private void AccessQueueTimer_Tick(object sender, EventArgs e)
{
try
{
SqlQueue sq = new SqlQueue();
//sq.ExecuteSqlQuery();
sq.QuickExecuteSqlQuery();
sq.Close();
}
catch (Exception)
{
}
}
/// <summary>
/// 购买确认详情
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int UpdateBuyApplicationDetail(DataTable dt, string TransNo)
{
int rows = 0;
DataTable insertDT = dt.Clone();
try
{
SqlQueue sq = new SqlQueue();
foreach (DataRow dr in dt.Rows)
{
if (dr["IsSuccess"].ToString() == "1")
{
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Update [ApplicationDetail] set ");
insertSql.AppendFormat(" [CodeID]='{0}',", dr["CodeID"]);
insertSql.AppendFormat(" [TransNo]='{0}',", dr["TransNo"]);
insertSql.AppendFormat(" [ItemID]='{0}',", dr["ItemID"]);
insertSql.AppendFormat(" [Detail]='{0}',", dr["Detail"]);
insertSql.AppendFormat(" [Price]={0},", dr["Price"]);
insertSql.AppendFormat(" [MoneyUnit]={0},", dr["MoneyUnit"]);
insertSql.AppendFormat(" [Count]={0},", dr["Count"]);
insertSql.AppendFormat(" [IsDelete]={0},", dr["IsDelete"]);
insertSql.AppendFormat(" [SelforGift]={0},", dr["SelforGift"]);
insertSql.AppendFormat(" [ApprovalCount]={0},", dr["ApprovalCount"]);
insertSql.AppendFormat(" [ApprovalDiscount]={0},", dr["ApprovalDiscount"]);
insertSql.AppendFormat(" [FinalPrice]={0},", dr["FinalPrice"]);
insertSql.AppendFormat(" [Recipient]='{0}',", dr["Recipient"]);
insertSql.AppendFormat(" [Relationship]='{0}',", dr["Relationship"]);
insertSql.AppendFormat(" [Reason]='{0}',", dr["Reason"]);
insertSql.AppendFormat(" [IsSuccess]='{0}',", dr["IsSuccess"]);
insertSql.AppendFormat(" [PhoneNum]='{0}'", dr["PhoneNum"]);
insertSql.AppendFormat(" where [ID]={0}", dr["ID"]);
sq.InsertQuery(insertSql.ToString(), "确认唯一码", TransNo, 1, int.Parse(dr["ID"].ToString()));
}
}
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="UID"></param>
/// <returns></returns>
public int DeleteUser(string ID)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
string sql = string.Format("Update Users Set IsDelete =1 Where ID={0}", ID);
sq.InsertQuery(sql, "", "", 0, 0);
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
}
/// <summary>
/// 删除订单表数据
/// </summary>
/// <param name="CtrlID"></param>
/// <returns></returns>
public int DeleteApplicaionInfo(string TransNo)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
string sql = string.Format("Update ApplicationInfo Set IsDelete =1 Where TransNo='{0}'", TransNo);
sq.InsertQuery(sql, "", "", 0, 2);
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 商品部最终确认
/// </summary>
/// <param name="CtrlID">控制号</param>
/// <returns></returns>
public int FinalConfirm(string TransNo)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
string sql = string.Format("Update ApplicationInfo Set AppState=9 , FinalState=1 where IsDelete = 0 and TransNo='{0}'", TransNo);
sq.InsertQuery(sql, "", "", 0, 0);
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 确认店面确认
/// </summary>
/// <param name="CtrlID">控制号</param>
/// <returns></returns>
public int StoreConfirm(string TransNo, Users user, DateTime dt)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
string sql = string.Format("Update ApplicationInfo Set StaffName = '{0}' ,StaffID='{1}' ,SalesDate='{2}', AppState=6,StaffApproval=1 where AppState<6 and IsDelete = 0 and TransNo='{3}'", user.UserName, user.UID, dt, TransNo);
sq.InsertQuery(sql.ToString(), "确认唯一码", TransNo, 0, 0);
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 经理审批
/// </summary>
/// <param name="CtrlID">控制号</param>
/// <returns></returns>
public int ApprovalApplication2(string TransNo, Users users, int ApprovalState, DateTime dt)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
string sql = string.Format("Update ApplicationInfo Set ApprovalDate2 = '{3}', AppState = 1 ,Approval2='{1}' , ApprovalName2='{2}' where AppState=0 and IsDelete = 0 and TransNo='{0}'", TransNo, users.UID, users.UserName, dt);
sq.InsertQuery(sql, "", "", 0, 0);
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int UpdateUser(Users user)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Update [Users] set ");
insertSql.AppendFormat(" [EmployeeID]='{0}',", user.EmployeeID);
insertSql.AppendFormat(" [UserName]='{0}',", user.UserName);
insertSql.AppendFormat(" [UserPwd]='{0}',", user.UserPwd);
insertSql.AppendFormat(" [Tel]='{0}',", user.Tel);
insertSql.AppendFormat(" [Email]='{0}',", user.Email);
insertSql.AppendFormat(" [Position]='{0}',", user.Position);
insertSql.AppendFormat(" [Department]='{0}',", user.Department);
insertSql.AppendFormat(" [Detail]='{0}',", user.Detail);
insertSql.AppendFormat(" [IsAdmin]={0},", user.IsAdmin);
insertSql.AppendFormat(" [Character]={0},", user.Character);
insertSql.AppendFormat(" [IsDelete]={0},", user.IsDelete);
insertSql.AppendFormat(" [TotalAmount]={0},", user.TotalAmount);
insertSql.AppendFormat(" [UsedAmount]={0},", user.UsedAmount);
insertSql.AppendFormat(" [RestAmount]={0},", user.RestAmount);
insertSql.AppendFormat(" [MoneyUnit]={0},", user.MoneyUnit);
insertSql.AppendFormat(" [ManagerID]='{0}',", user.ManagerID);
insertSql.AppendFormat(" [Store]='{0}',", user.Store);
insertSql.AppendFormat(" [IsAble]={0},", user.IsAble);
insertSql.AppendFormat(" [EmpDate]=#{0}#,", user.EmpDate);
insertSql.AppendFormat(" [AbleMode]={0}", user.AbleMode);
insertSql.AppendFormat(" where [UID]='{0}'", user.UID);
sq.InsertQuery(insertSql.ToString(), "", "", 0, 0);
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 扣额度
/// </summary>
/// <param name="CtrlID">控制号</param>
/// <returns></returns>
public int StorePay(string TransNo, string check, string UID, double TotalPrice, double MoneyRate)
{
int rows = 0;
try
{
double FinalPrice = TotalPrice * MoneyRate;
SqlQueue sq = new SqlQueue();
string sql = string.Format("Update [Users] Set [RestAmount] = ([RestAmount]-{0}) where [UID]='{1}'", FinalPrice, UID);
sq.InsertQuery(sql.ToString(), "确认唯一码", TransNo, 0, 0);
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
///// <summary>
///// 商品部审批不通过
///// </summary>
///// <param name="CtrlID">控制号</param>
///// <returns></returns>
//public int ApprovalNotApplication(string TransNo, string UID ,string UserName, int ApprovalState, DateTime dt)
//{
// int rows = 0;
// AccessHelper ah = new AccessHelper();
// string sql;
// sql = string.Format("Update ApplicationInfo Set ApprovalDate = '{3}', AppState = 3,Approval='{1}' , ApprovalName='{2}' where AppState=1 and IsDelete = 0 and TransNo='{0}'", TransNo, UID, UserName, dt);
// try
// {
// OleDbCommand comm = new OleDbCommand(sql, ah.Conn);
// rows = comm.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// ah.Close();
// return 0;
// }
// ah.Close();
// return rows;
//}
/// <summary>
/// 员工确认商品部修改后的申请单
/// </summary>
/// <param name="CtrlID">控制号</param>
/// <returns></returns>
public int StaffApprovalApplication(string TransNo)
{
string unCode = GetSHA1(TransNo);
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
string sql = string.Format("Update ApplicationInfo Set AppState = 4,UnCode='{1}' where AppState=3 and IsDelete = 0 and TransNo='{0}'", TransNo, unCode);
sq.InsertQuery(sql, "", "", 0, 0);
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
/// <summary>
/// 修改商品表数据Items
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int UpdateItems(DataTable dt)
{
int rows = 0;
try
{
SqlQueue sq = new SqlQueue();
foreach (DataRow dr in dt.Rows)
{
StringBuilder insertSql = new StringBuilder();
insertSql.Append("Update [Items] set ");
insertSql.AppendFormat(" [ItemID]='{0}',", dr["ItemID"]);
insertSql.AppendFormat(" [Price]={0},", dr["Price"]);
insertSql.AppendFormat(" [Price2]={0},", dr["Price2"]);
insertSql.AppendFormat(" [Price3]={0},", dr["Price3"]);
insertSql.AppendFormat(" [Price4]={0},", dr["Price4"]);
insertSql.AppendFormat(" [Price5]={0},", dr["Price5"]);
insertSql.AppendFormat(" [Price6]={0},", dr["Price6"]);
insertSql.AppendFormat(" [Price7]={0},", dr["Price7"]);
insertSql.AppendFormat(" [Price8]={0},", dr["Price8"]);
insertSql.AppendFormat(" [Price9]={0},", dr["Price9"]);
insertSql.AppendFormat(" [Price10]={0},", dr["Price10"]);
insertSql.AppendFormat(" [Detail]='{0}',", dr["Detail"]);
insertSql.AppendFormat(" [IsDelete]={0},", dr["IsDelete"]);
insertSql.AppendFormat(" [IsSpecial]={0},", dr["IsSpecial"]);
insertSql.AppendFormat(" [ItemName]='{0}'", dr["ItemName"]);
insertSql.AppendFormat(" where [ID]={0}", dr["ID"]);
sq.InsertQuery(insertSql.ToString(), "", "", 0, 0);
}
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
public void Connect()
{
Disconnect();
Queue = _openQueue();
}
/// <summary>
/// 修改申请表详情数据ApplicationDetail
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int UpdateApplicationDetail(DataTable dt, double douTotalPrice, string strUID, int intFlag)
{
int rows = 0;
DataTable insertDT = dt.Clone();
try
{
SqlQueue sq = new SqlQueue();
foreach (DataRow dr in dt.Rows)
{
StringBuilder insertSql = new StringBuilder();
if (dr.RowState == DataRowState.Added)
{
insertSql.Append("Insert into [ApplicationDetail]");
insertSql.Append(" ([CodeID],[TransNo],[ItemID],[Detail],[Price],[MoneyUnit],[Count],[IsDelete],[SelforGift],[ApprovalCount],[ApprovalDiscount],[FinalPrice],[Recipient],[Relationship],[Reason],[IsSuccess],[PhoneNum]) ");
insertSql.Append("values");
insertSql.AppendFormat(" ('{0}','{1}','{2}','{3}',{4},{5},{6},{7},{8},{9},{10},{11},'{12}','{13}','{14}',{15},'{16}')", dr["CodeID"], dr["TransNo"], dr["ItemID"], dr["Detail"], dr["Price"], dr["MoneyUnit"], dr["Count"], dr["IsDelete"], dr["SelforGift"], dr["ApprovalCount"], dr["ApprovalDiscount"], dr["FinalPrice"], dr["Recipient"], dr["Relationship"], dr["Reason"], dr["IsSuccess"], dr["PhoneNum"]);
}
else if (dr.RowState == DataRowState.Deleted)
{
dr.RejectChanges();
insertSql.AppendFormat("Delete from [ApplicationDetail] where [ID]={0}", dr["ID"]);
}
else
{
insertSql.Append("Update [ApplicationDetail] set ");
insertSql.AppendFormat(" [CodeID]='{0}',", dr["CodeID"]);
insertSql.AppendFormat(" [TransNo]='{0}',", dr["TransNo"]);
insertSql.AppendFormat(" [ItemID]='{0}',", dr["ItemID"]);
insertSql.AppendFormat(" [Detail]='{0}',", dr["Detail"]);
insertSql.AppendFormat(" [Price]={0},", dr["Price"]);
insertSql.AppendFormat(" [MoneyUnit]={0},", dr["MoneyUnit"]);
insertSql.AppendFormat(" [Count]={0},", dr["Count"]);
insertSql.AppendFormat(" [IsDelete]={0},", dr["IsDelete"]);
insertSql.AppendFormat(" [SelforGift]={0},", dr["SelforGift"]);
insertSql.AppendFormat(" [ApprovalCount]={0},", dr["ApprovalCount"]);
insertSql.AppendFormat(" [ApprovalDiscount]={0},", dr["ApprovalDiscount"]);
insertSql.AppendFormat(" [FinalPrice]={0},", dr["FinalPrice"]);
insertSql.AppendFormat(" [Recipient]='{0}',", dr["Recipient"]);
insertSql.AppendFormat(" [Relationship]='{0}',", dr["Relationship"]);
insertSql.AppendFormat(" [Reason]='{0}',", dr["Reason"]);
insertSql.AppendFormat(" [IsSuccess]='{0}',", dr["IsSuccess"]);
insertSql.AppendFormat(" [PhoneNum]='{0}'", dr["PhoneNum"]);
insertSql.AppendFormat(" where [ID]={0}", dr["ID"]);
}
if (insertSql.ToString().ToLower().Substring(0, 6) == "insert".Substring(0, 6) || insertSql.ToString().ToLower().Substring(0, 6) == "update".Substring(0, 6))
{
sq.InsertQuery(insertSql.ToString(), "Cache" + strUID, dr["TransNo"].ToString(), douTotalPrice, intFlag);
}
else
{
sq.InsertQuery(insertSql.ToString(), "", "", 0, 0);
}
}
sq.Close();
return(1);
}
catch (Exception ex)
{
//throw ex;
return(0);
}
return(rows);
}
static void Main(string[] args)
{
string connectionString = null;
string serviceOrigin = null;
string serviceDestination = null;
string contract = null;
string messageType = null;
string queueOrigin = null;
string queueDestination = null;
string baggageTable = null;
var parser = new Fclp.FluentCommandLineParser();
parser.Setup <string>("connectionString").Callback(x => connectionString = x);
parser.Setup <string>("serviceOrigin").Callback(x => serviceOrigin = x);
parser.Setup <string>("serviceDestination").Callback(x => serviceDestination = x);
parser.Setup <string>("contract").Callback(x => contract = x);
parser.Setup <string>("messageType").Callback(x => messageType = x);
parser.Setup <string>("queueOrigin").Callback(x => queueOrigin = x);
parser.Setup <string>("queueDestination").Callback(x => queueDestination = x);
parser.Setup <string>("baggageTable").Callback(x => baggageTable = x);
parser.Parse(args);
Console.WriteLine("Connecting...");
var parameters = new SqlQueueParameters(connectionString, serviceOrigin, serviceDestination, contract, messageType, queueOrigin, queueDestination, baggageTable);
var queue = new SqlQueue(parameters);
queue.CreateObjects();
queue.EnableQueue();
queue.Clear();
var item1 = new ItemDto(1)
{
InnerDto = new BaseDto.InnerBaseDto(18, "InnerDtoText")
};
var item2 = new ItemDto(2);
var item3 = new ItemDto(3);
var ea = new SomeDomainEvent("a", "b", "c", new[] { "d" })
{
User = new DomainEventArgs.UserInfo(143, "name")
};
queue.Enqueue(ea);
ea = queue.Dequeue <SomeDomainEvent>();
Debug.Assert(ea.User.Id == 143);
Debug.Assert(ea.User.Name == "name");
var event2 = new SomeDomainEvent2(SomeDomainEvent2.InnerEnum1.EnumValue1, SomeDomainEvent2.InnerEnum2.Enum2Value2, 1, "message");
queue.Enqueue(event2);
event2 = queue.Dequeue <SomeDomainEvent2>();
Debug.Assert(event2.Inner1 == SomeDomainEvent2.InnerEnum1.EnumValue1);
Debug.Assert(event2.Inner2 == SomeDomainEvent2.InnerEnum2.Enum2Value2);
queue.Enqueue(item1);
queue.Enqueue(item2);
queue.Enqueue(item3);
item1 = queue.Dequeue <ItemDto>();
item2 = queue.Dequeue <ItemDto>();
item3 = queue.Dequeue <ItemDto>();
Console.WriteLine("item1.Id == 1");
Debug.Assert(item1.Int == 1);
Debug.Assert(item1.Long == 5);
Debug.Assert(item1.Options.Count() == 2);
Debug.Assert(item1.Options[0] == ENUM.A);
Debug.Assert(item1.Options[1] == ENUM.B);
Debug.Assert(item1.Strings.Count() == 2);
Debug.Assert(item1.Strings[0] == "abc");
Debug.Assert(item1.Strings[1] == "def");
Debug.Assert(item1.UniqueID == Guid.Parse("c060ee98-2527-4a47-88cb-e65263ed4277"));
Debug.Assert(System.Text.Encoding.UTF8.GetString(item1.VeryBigBuffer) == "VERYBIGTEXT");
Debug.Assert(System.Text.Encoding.UTF8.GetString(item1.DictionaryBuffers["buffer1"]) == "BUFFER1");
Debug.Assert(System.Text.Encoding.UTF8.GetString(item1.DictionaryBuffers["buffer2"]) == "BUFFER2");
Debug.Assert(item1.BaseInt == 98);
Debug.Assert(item1.BaseChild.Int == 99);
Debug.Assert(item1.InnerDto.InnerDtoInt == 18);
Debug.Assert(item1.InnerDto.InnerDtoText == "InnerDtoText");
Console.WriteLine("item1.Id == 2");
Debug.Assert(item2.Int == 2);
Console.WriteLine("item1.Id == 3");
Debug.Assert(item3.Int == 3);
queue.Enqueue(item1);
var items = queue.DequeueGroup();
Debug.Assert(items.Count() == 1);
Debug.Assert((items.Single() as ItemDto).Int == 1);
queue.Enqueue(new NullDto());
var nullDto = queue.Dequeue <NullDto>();
Debug.Assert(nullDto.Child == null);
Debug.Assert(nullDto.DateTime == null);
Debug.Assert(nullDto.DictionaryBuffers == null);
Debug.Assert(nullDto.Double == null);
Debug.Assert(nullDto.Float == null);
Debug.Assert(nullDto.Int == null);
Debug.Assert(nullDto.Float == null);
Debug.Assert(nullDto.Long == null);
Debug.Assert(nullDto.Options == null);
Debug.Assert(nullDto.Strings == null);
Debug.Assert(nullDto.Text == null);
Debug.Assert(nullDto.UniqueID == null);
Debug.Assert(nullDto.VeryBigBuffer == null);
queue.Enqueue(new NullDto()
{
Int = 1
});
nullDto = queue.Dequeue <NullDto>();
Debug.Assert(nullDto.Child == null);
Debug.Assert(nullDto.DateTime == null);
Debug.Assert(nullDto.DictionaryBuffers == null);
Debug.Assert(nullDto.Double == null);
Debug.Assert(nullDto.Float == null);
Debug.Assert(nullDto.Int.HasValue);
Debug.Assert(nullDto.Int == 1);
Debug.Assert(nullDto.Float == null);
Debug.Assert(nullDto.Long == null);
Debug.Assert(nullDto.Options == null);
Debug.Assert(nullDto.Strings == null);
Debug.Assert(nullDto.Text == null);
Debug.Assert(nullDto.UniqueID == null);
Debug.Assert(nullDto.VeryBigBuffer == null);
queue.Enqueue(new NullDto()
{
Text = "SOMESTRING"
});
nullDto = queue.Dequeue <NullDto>();
Debug.Assert(nullDto.Child == null);
Debug.Assert(nullDto.DateTime == null);
Debug.Assert(nullDto.DictionaryBuffers == null);
Debug.Assert(nullDto.Double == null);
Debug.Assert(nullDto.Float == null);
Debug.Assert(nullDto.Int == null);
Debug.Assert(nullDto.Float == null);
Debug.Assert(nullDto.Long == null);
Debug.Assert(nullDto.Options == null);
Debug.Assert(nullDto.Strings == null);
Debug.Assert(nullDto.Text == "SOMESTRING");
Debug.Assert(nullDto.UniqueID == null);
Debug.Assert(nullDto.VeryBigBuffer == null);
var item5 = new ItemDto(5);
var item6 = new ItemDto(6);
queue.Enqueue(new[] { item5, item6 });
var itemdtos = queue.DequeueGroup().Cast <ItemDto>();
Debug.Assert(itemdtos.Skip(0).First().Int == 5);
Debug.Assert(itemdtos.Skip(1).First().Int == 6);
try
{
queue.Enqueue(new NonSerializableDto());
var nonserializable = queue.Dequeue <NonSerializableDto>();
Debug.Assert(false);
}
catch
{
}
// Transactional processing must work
var itemT1 = new ItemDto(6);
queue.Enqueue(itemT1);
queue.DequeueGroup(messages =>
{
Debug.Assert(messages.Count() == 1);
Debug.Assert((messages.First() as ItemDto).Int == 6);
});
// Transactional retry must work
var dic = new SqlNoMemoryDictionary <Guid, QueuItemEnvelope>();
dic.Prepare(connectionString, "QUEUESTATUS", "Oid", "Status");
dic.Clear();
queue.Clear();
queue.Enqueue(new[] { new ItemDto(5, Guid.NewGuid()), new ItemDto(6, Guid.NewGuid()) });
queue.DequeueGroup(messages =>
{
foreach (ItemDto mesage in messages)
{
dic.Add(mesage.UniqueID, new QueuItemEnvelope(mesage));
throw new Exception();
}
});
queue.DequeueGroup <Guid>(dic, x => (x as ItemDto).UniqueID, message =>
{
Console.Write(message);
});
Guid g1 = Guid.Parse("855a88f3-e2f8-4cbb-8ef5-130d86f27913");
Guid g2 = Guid.Parse("6abaeacc-f47b-4c77-b0fc-ecd873dea12a");
queue.Enqueue(new[] { new ItemDto(5, g1), new ItemDto(6, g2) });
queue.DequeueGroup(dic, x => (x as ItemDto).UniqueID, message =>
{
throw new Exception();
});
queue.DequeueGroup(dic, x => (x as ItemDto).UniqueID, message =>
{
Console.Write(message);
});
queue.Enqueue(new[] { new ItemDto(5, g1), new ItemDto(6, g2) });
queue.DequeueGroup(dic, x => (x as ItemDto).UniqueID, message =>
{
Debug.Assert(false);
});
//VERY BIG mESSAGE
var bigdto = new ItemDto(1)
{
Text = new string('a', 2000 * 1000 )
};
queue.Enqueue(bigdto);
bigdto = queue.Dequeue <ItemDto>();
Debug.Assert(bigdto.Text.Length == 2000 * 1000);
var emptyDicMsg = new EmptyDicDomainEventArgs();
queue.Enqueue(emptyDicMsg);
emptyDicMsg = queue.Dequeue <EmptyDicDomainEventArgs>();
Console.WriteLine("");
Console.WriteLine("OK!");
//Console.ReadLine();
}
