/// <summary>
/// 检查卖家当前账户短信账户是否足够发送
/// </summary>
public static Boolean CheckSellerMsgStatus()
{
DataTable tbmsgCanUseCount = MsgDAL.GetSellerMsgStatus(Users.Nick);
if (tbmsgCanUseCount != null && tbmsgCanUseCount.Rows.Count > 0)
{
var msgCanUseCount = tbmsgCanUseCount.Rows[0]["msgCanUseCount"].ToString();
if (!string.IsNullOrEmpty(msgCanUseCount) && Convert.ToInt32(msgCanUseCount) > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 统计发送的计费情况
/// </summary>
/// <param name="sellerNick"></param>
/// <returns></returns>
public static DataTable GetMsgSendJifen(string startTime, string endTime)
{
DataTable dtTwo = MsgDAL.GetTwo();
DataTable dt = MsgDAL.GetMsgSendCount(startTime, endTime);
MsgDAL.DeleteMsgRecords();
for (int i = 0; i < dt.Rows.Count; i++)
{
int j = 0;
if (CheckTwo(dtTwo, dt.Rows[i]["sellernick"].ToString(), ref j))
{
//获取卖家购买的短信包
DataTable dt1 = MsgDAL.GetMsgHisByNick(dt.Rows[i]["sellernick"].ToString());
if (dt1.Rows.Count >= 2)
{
if (dt1.Rows[1]["packageName"].ToString() == "店铺管家短信套餐(淘宝)200000条")
{
bool re = MsgDAL.InsertMsgRecords(dt.Rows[i]["sellernick"].ToString(), dt.Rows[i]["msgCount"].ToString(), (Convert.ToInt32(dt.Rows[i]["msgCount"]) * 0.034).ToString(), "3.4分/条");
}
}
else
{
if (((Convert.ToInt32(dt.Rows[i]["msgCount"])) + Convert.ToInt32(dtTwo.Rows[j]["msgCanUseCount"])) > 200000)
{
int price_35 = (((Convert.ToInt32(dt.Rows[i]["msgCount"])) + Convert.ToInt32(dtTwo.Rows[j]["msgCanUseCount"])) - 200000);
int price_34 = (Convert.ToInt32(dt.Rows[i]["msgCount"])) - price_35;
bool re = MsgDAL.InsertMsgRecords(dt.Rows[i]["sellernick"].ToString(), dt.Rows[i]["msgCount"].ToString(), (price_34 * 0.034 + price_35 * 0.035).ToString(), price_34 + "条 3.4分/条，" + price_35 + "条 3.5分/条，");
}
else
{
bool re = MsgDAL.InsertMsgRecords(dt.Rows[i]["sellernick"].ToString(), dt.Rows[i]["msgCount"].ToString(), (Convert.ToInt32(dt.Rows[i]["msgCount"]) * 0.034).ToString(), "3.4分/条");
}
}
}
else
{
bool re = MsgDAL.InsertMsgRecords(dt.Rows[i]["sellernick"].ToString(), dt.Rows[i]["msgCount"].ToString(), (Convert.ToInt32(dt.Rows[i]["msgCount"]) * 0.035).ToString(), "3.5分/条");
}
}
//MsgDAL.InsertMsgRecords();
return(MsgDAL.GetMsgRecords(""));
}
public static bool DeleteMsgHis(string sellerNick, string startDate, string endDate, string sendType)
{
DataTable dt = MsgDAL.GetSellerMsgSendHis(sellerNick, startDate, endDate, sendType, "", "", "");
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
string transNumber = dt.Rows[i]["transNumber"].ToString();
MsgDAL.DeleteMsgHis(transNumber);
}
catch (Exception ex) {
continue;
}
}
}
return(true);
}
public static DataTable GetMsgRecordsSum()
{
return(MsgDAL.GetMsgRecordsSum());
}
public static bool AddSellerYDNumber(string nick, string number)
{
return(MsgDAL.AddSellerYDNumber(nick, number));
}
public static DataTable GetAuditMessage(string sellerNick, string startDate, string endDate, string auditSatus)
{
return(MsgDAL.GetAuditMessage(sellerNick, startDate, endDate, auditSatus));
}
public static bool UpdateMsgTransServiceStatus(string sellerNick, Boolean serviceStatus)
{
return(MsgDAL.UpdateMsgTransServiceStatus(sellerNick, serviceStatus));
}
public static bool CountFailedMsgSend()
{
return(MsgDAL.CountFailedMsgSend());
}
public static String GetSellerSendMsgCusContent(string sellerNick)
{
return(MsgDAL.GetSellerSendMsgCusContent(sellerNick));
}
/// <summary>
/// 获取卖家短信事务明细
/// </summary>
/// <param name="sellerNick"></param>
/// <returns></returns>
public static DataTable GetSellerMsgTrans(string sellerNick)
{
return(MsgDAL.GetSellerMsgTrans(sellerNick));
}
public static DataTable GetMsgContentByTransID(string transNumber)
{
return(MsgDAL.GetMsgContentByTransID(transNumber));
}
public static DataTable GetMoreYiWanMsg()
{
return(MsgDAL.GetMoreYiWanMsg());
}
/// <summary>
/// 获得给卖家设置的发送百分之几
/// </summary>
/// <param name="sellerNick"></param>
/// <returns></returns>
public static DataTable GetSellerMsgSendPrecent(string sellerNick)
{
return(MsgDAL.GetSellerMsgSendPrecent(sellerNick));
}
public static DataTable GetMsgPakageByID(string id)
{
return(MsgDAL.GetMsgPakageByID(id));
}
public static bool UpdateMsgPakage(string id)
{
return(MsgDAL.UpdateMsgPakage(id));
}
public static bool DeleteMsgPakage(string tempId)
{
return(MsgDAL.DeleteMsgPakage(tempId));
}
public static DataTable GetMsgHis(string sellerNick, string satrtOrderDate, string endOrderDate, string rank)
{
return(MsgDAL.GetMsgHis(sellerNick, satrtOrderDate, endOrderDate, rank));
}
public static DataTable GetMsgReminderHisBySellerNick(string sellerNick, string starteDate, string endDate, string type)
{
return(MsgDAL.GetMsgReminderHisBySellerNick(sellerNick, starteDate, endDate, type));
}
public static DataTable GetSellerYDNumbers(string sellerNick, string startDate, string endDate)
{
return(MsgDAL.GetSellerYDNumbers(sellerNick, startDate, endDate));
}
/// <summary>
/// 统计营销发送的条数
/// </summary>
/// <param name="sellerNick"></param>
/// <returns></returns>
public static DataTable GetMsgSendHisCount(string seller)
{
return(MsgDAL.GetMsgSendHisCount(seller));
}
public static bool ClearMsgCountForCT()
{
return(MsgDAL.ClearMsgCountForCT());
}
public static string CheckSellerMsgTransIsExit(string sellerNick)
{
return(MsgDAL.CheckSellerMsgTransIsExit(sellerNick));
}
public static DataTable GetMsgHisByNick(string sellerNick)
{
return(MsgDAL.GetMsgHisByNick(sellerNick));
}
public static bool DeleteMsgHisForReminder(string transNumber)
{
return(MsgDAL.DeleteMsgHisForReminder(transNumber));
}
public static bool UpdateSellerCusMsgContent(string sellerNick, string msgContent)
{
return(MsgDAL.UpdateSellerCusMsgContent(sellerNick, msgContent));
}
/// <summary>
/// 每条短信发送条数更新
/// </summary>
/// <param name="sellerNick"></param>
/// <param name="perMsgCount">每条内容耗费短信条数</param>
/// <returns></returns>
public static bool UpdateMsgTransUseCount(string sellerNick, int perMsgCount)
{
return(MsgDAL.UpdateMsgTransUseCount(sellerNick, perMsgCount));
}
public static bool AddMsgTrans(MsgPackage obj)
{
return(MsgDAL.AddMsgTrans(obj));
}
public static bool SellerSendPhoneYes(string sellerNick, string cellPhone)
{
return(MsgDAL.SellerSendPhoneYes(sellerNick, cellPhone));
}
public static DataTable GetSellerMsgSendHisForReminder(string sellerNick, string startDate, string endDate, string sendType, string helpSellerNick, string buyerPhone)
{
return(MsgDAL.GetSellerMsgSendHisForReminder(sellerNick, startDate, endDate, sendType, helpSellerNick, buyerPhone));
}
public static DataTable GetMsgRecords(string nick)
{
return(MsgDAL.GetMsgRecords(nick));
}
