Beispiel #1
0
 public static void ClientAudit(Guid newBossID, Guid clientID, bool modePass = true)
 {
     Hashtable ht = new Hashtable();
     ht.Add("C_UserID", newBossID);
     ht.Add("C_ClientID", clientID);
     DataRow row = DAL.GetRow("vwTQAccount_List", ht);
     if (row != null)
     {
         string strTitle;
         string dateModify = row["DATE_MODIFIED"].ToString();
         string bossPhone = row["BossPhone"].ToString();
         string companyName = row["C_ClientName"].ToString();
         SMS sms = new SMS();
         if (modePass)
         {
             sms.SendTemplate(bossPhone, "56925", new string[] { dateModify, companyName });
             strTitle = string.Format("您{0}提交的{1}信息已经通过平台管理员审核!", dateModify, companyName);
         }
         else
         {
             sms.SendTemplate(bossPhone, "56926", new string[] { dateModify, companyName });
             strTitle = string.Format("您{0}提交的{1}信息审核未通过,请联系平台客服!", dateModify, companyName);
         }
         SqlProcs.spTQMessageNew(newBossID, strTitle, null);
     }
 }
Beispiel #2
0
        public static void UserApply(Guid accountID)
        {
            Hashtable ht = new Hashtable();
            ht.Add("ID", accountID);
            DataRow row = DAL.GetRow("vwTQAccount_List", ht);
            if (row != null)
            {
                Guid gTo = Sql.ToGuid(row["C_BossID"]);
                string to = row["BossPhone"].ToString();
                string phone = row["PHONE_MOBILE"].ToString();
                string realName = row["LAST_NAME"].ToString();
                string strTitle = string.Format("用户:{0},手机号:{1}申请加入您的公司,请审核!", phone, realName);

                SMS sms = new SMS();
                sms.SendTemplate(to, "57407", new string[] { phone, realName });
                SqlProcs.spTQMessageNew(gTo, strTitle, "/Member/Account/");
            }
        }
Beispiel #3
0
 public static void BossAudit(Guid gID, bool mode = false)
 {
     Hashtable ht = new Hashtable();
     ht.Add("ID", gID);
     DataRow row = DAL.GetRow("vwTQAccount_List", ht);
     if (row != null)
     {
         string strTitle;
         string phone = row["PHONE_MOBILE"].ToString();
         string company = row["C_ClientName"].ToString();
         string bossName = row["BossName"].ToString();
         string bossPhone = row["BossPhone"].ToString();
         SMS sms = new SMS();
         if (mode)
         {
             sms.SendTemplate(phone, "56929", new string[] { company, bossName, bossPhone });
             strTitle = string.Format("您提交的{0}的账户审核已通过,如有疑问请联系{1},手机号:{2},或平台客服", company, bossName, bossPhone);
         }
         else
         {
             sms.SendTemplate(phone, "56930", new string[] { company, bossName, bossPhone });
             strTitle = string.Format("您提交的{0}的账户审核未通过审核,如有疑问请联系{1},手机号:{2}", company, bossName, bossPhone);
         }
         SqlProcs.spTQMessageNew(gID, strTitle, null);
     }
 }
Beispiel #4
0
 public static void TransitAudit(Guid transitID, bool modePass = true)
 {
     Hashtable ht = new Hashtable();
     ht.Add("ID", transitID);
     DataRow row = DAL.GetRow("vwTQTransit_List", ht);
     if (row != null)
     {
         Guid sellerID = Sql.ToGuid(row["SellerID"]);
         string sellerPhone = row["SellerPhone"].ToString();
         SMS sms = new SMS();
         string strContent;
         if (modePass)
         {
             strContent = string.Format("您发布的在途气平台管理员已经通过审核!");
             sms.SendTemplate(sellerPhone, "56943", new[] { "" });
             SqlProcs.spTQMessageNew(sellerID, strContent, "/member/TransitSell/");
         }
         else
         {
             strContent = string.Format("您发布的在途气平台管理员未通过审核,请联系在线客服!");
             SqlProcs.spTQMessageNew(sellerID, strContent, null);
         }
     }
 }
Beispiel #5
0
 public static void AcceptQuotePrice(Guid quotePriceID)
 {
     Hashtable ht = new Hashtable();
     ht.Add("ID", quotePriceID);
     DataRow row = DAL.GetRow("vwTQQuotePrice_List", ht);
     if (row != null)
     {
         Guid sellerID = Sql.ToGuid(row["SellerID"]);
         string sellerPhone = row["SellerPhone"].ToString();
         string buyer = row["Buyer"].ToString();
         string strContent = string.Format("您给{0}气源报价,该公司已确认!请及时查看", buyer);
         SMS sms = new SMS();
         sms.SendTemplate(sellerPhone, "56939", new[] { buyer });
         SqlProcs.spTQMessageNew(sellerID, strContent, "/member/OrderSell/");
     }
 }
Beispiel #6
0
 public static void QuoteAudit(Guid quoteID, bool modePass = true)
 {
     Hashtable ht = new Hashtable();
     ht.Add("ID", quoteID);
     DataRow row = DAL.GetRow("vwTQQuote_List", ht);
     if (row != null)
     {
         Guid buyerID = Sql.ToGuid(row["BuyerID"]);
         string buyerPhone = row["BuyerPhone"].ToString();
         SMS sms = new SMS();
         string strContent;
         if (modePass)
         {
             strContent = string.Format("您发布的求购需求平台管理员已经通过审核,请等待卖家报价!");
             sms.SendTemplate(buyerPhone, "56942", new[] { "" });
             SqlProcs.spTQMessageNew(buyerID, strContent, "/member/Quote/");
         }
         else
         {
             strContent = string.Format("您发布的求购需求平台管理员未通过审核,请联系在线客服");
             SqlProcs.spTQMessageNew(buyerID, strContent, null);
         }
         
     }
 }
Beispiel #7
0
 public static void QuoteDetailPrice(Guid quoteDetailID, bool modeEdit = false)
 {
     Hashtable ht = new Hashtable();
     ht.Add("ID", quoteDetailID);
     DataRow row = DAL.GetRow("vwTQQuoteDetail_List", ht);
     if (row != null)
     {
         Guid buyerID = Sql.ToGuid(row["BuyerID"]);
         string buyerPhone = row["BuyerPhone"].ToString();
         string strContent;
         SMS sms = new SMS();
         if (modeEdit)   // 编辑
         {
             strContent = string.Format("您的求购需求中有卖家调整报价,请您及时登录查看报价!");
             sms.SendTemplate(buyerPhone, "56936", new[] { "" });
             SqlProcs.spTQMessageNew(buyerID, strContent, "/member/Quote/");
         }
         else // 新报价
         {
             strContent = string.Format("您的求购需求有新的卖家报价,请您及时查看报价!");
             sms.SendTemplate(buyerPhone, "56938", new[] { "" });
             SqlProcs.spTQMessageNew(buyerID, strContent, "/member/Quote/");
         }
     }
 }
Beispiel #8
0
 public static void Receipt(Guid orderDetailID)
 {
     Hashtable ht = new Hashtable();
     ht.Add("ID", orderDetailID);
     DataRow row = DAL.GetRow("vwTQOrderDetail_List", ht);
     if (row != null)
     {
         Guid sellerID = Sql.ToGuid(row["SellerID"]);
         string sellerPhone = row["SellerPhone"].ToString();
         string buyer = row["Buyer"].ToString();
         string SN = row["SN"].ToString();
         string strContent = string.Format("您公司销售给{0}的LNG,买方已经收货,请您及时查看!单号:{1}", buyer, SN);
         SMS sms = new SMS();
         sms.SendTemplate(sellerPhone, "56934", new[] { buyer, SN });
         SqlProcs.spTQMessageNew(sellerID, strContent, "/member/OrderSell/");
     }
 }
Beispiel #9
0
        /// <summary>
        /// 车辆出发
        /// </summary>
        /// <param name="orderDetailID"></param>
        /// <param name="msgContent"></param>
        /// <param name="mode">true:发送给买家, false:发送给卖家</param>
        public static void DepartCar(Guid orderDetailID, bool mode = false)
        {
            Hashtable ht = new Hashtable();
            ht.Add("ID", orderDetailID);
            DataRow row = DAL.GetRow("vwTQOrderDetail_List", ht);
            if (row != null)
            {
                Guid sellerID = Sql.ToGuid(row["SellerID"]);
                Guid buyerID = Sql.ToGuid(row["BuyerID"]);
                string sellerPhone = row["SellerPhone"].ToString();
                string buyerPhone = row["BuyerPhone"].ToString();
                string seller = row["Seller"].ToString();
                string buyer = row["Buyer"].ToString();
                string driverName = row["C_Driver"].ToString();
                string strContent;
                SMS sms = new SMS();
                if (mode)   // 买方
	            {
                    sms.SendTemplate(buyerPhone, "56933", new[] { seller, driverName });
                    strContent = string.Format("您公司订购{0}的LNG已经由驾驶员{1}上传《随货通讯单》,请及时登录平台或手机客户端查看车辆实时位置。",
                                seller, driverName);
                    SqlProcs.spTQMessageNew(buyerID, strContent, "/member/Order/");
	            }
                else
                {
                    sms.SendTemplate(sellerPhone, "56932", new[] { buyer, driverName });
                    strContent = string.Format("您公司销售给{0}的LNG已经由驾驶员{1}上传《随货通讯单》,请及时登录平台或手机客户端查看车辆实时位置。",
                        buyer, driverName);
                    SqlProcs.spTQMessageNew(sellerID, strContent, "/member/OrderSell/");
                }
            }
        }
Beispiel #10
0
 public static void DispatchCar(Guid orderDetailID, ref string msgContent)
 {
     Hashtable ht = new Hashtable();
     ht.Add("ID", orderDetailID);
     DataRow row = DAL.GetRow("vwTQOrderDetail_List", ht);
     if (row != null)
     {
         Guid driverID;
         Guid.TryParse(row["DriverID"].ToString(), out driverID);
         string driverTel = row["C_Tel"].ToString();
         string seller = row["Seller"].ToString();
         string driverName = row["C_Driver"].ToString();
         string arriveTime = row["C_ArriveTime"].ToString();
         string stationAddress = row["FullAddress"].ToString();
         string userTypeName = row["UserTypeName"].ToString();
         string buyer = row["Buyer"].ToString();
         string contactName = row["C_ContactName"].ToString();
         string contactTel = row["ContactTel"].ToString();
         string sellerName = row["SellerName"].ToString();
         msgContent = string.Format("您好:{0}的{1}:请您于{2}之前,将一车LNG送到{3}的{4},该站隶属于{5},站内联系人:{6},联系方式{7};请您及时与{8}确认信息。",
             seller, driverName, arriveTime, stationAddress, userTypeName, buyer, contactName, contactTel, sellerName);
         SMS sms = new SMS();
         sms.SendTemplate(driverTel, "52016", new[] { seller, driverName, arriveTime, stationAddress, userTypeName, buyer, contactName, contactTel, sellerName });
         if (driverID != Guid.Empty) SqlProcs.spTQMessageNew(driverID, msgContent, null);
     }
 }
Beispiel #11
0
 public static void Order(Guid orderID, ref string SN)
 {
     Hashtable ht = new Hashtable();
     ht.Add("ID", orderID);
     DataRow row = DAL.GetRow("vwTQOrder_List", ht);
     if (row != null)
     {
         Guid sellerID = Sql.ToGuid(row["SellerID"]);
         string sellerPhone = row["SellerPhone"].ToString();
         SN = row["SN"].ToString();
         string strTitle = string.Format("您发布的气源有买家下单,请您及时响应!单号{0}", SN);
         SMS sms = new SMS();
         sms.SendTemplate(sellerPhone, "56931", new string[] { SN });
         SqlProcs.spTQMessageNew(sellerID, strTitle, "/member/OrderSell/");
     }
 }