/// <summary>
/// 添加警告2016-10-09 yao c
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static Boolean addWarnConfig(MsgSendConfig o)
{
try
{
string query = @"insert into tab_MsgConfig(sellerNick,unPayType,unpayMsg,threeDayType,blackListType,areaList,areaType,warnType,createDate,amount,amountMax)" +
"values(@sellerNick,@unPayType,@unpayMsg,@threeDayType,@blackListType,@areaList,@areaType,@warnType,getdate(),@amount,@amountMax)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", o.SellerNick),
new SqlParameter("@unPayType", o.UnPayType),
new SqlParameter("@unpayMsg", string.IsNullOrEmpty(o.UnpayMsg)?"":o.UnpayMsg),
new SqlParameter("@threeDayType", o.threeDayType),
new SqlParameter("@blackListType", o.blackListType),
new SqlParameter("@areaList", string.IsNullOrEmpty(o.areList)?"":o.areList),
new SqlParameter("@areaType", o.areType),
new SqlParameter("@warnType", o.warnType),
new SqlParameter("@amount", o.Amount),
new SqlParameter("@amountMax", o.AmountMax)
};
DataBase.ExecuteSql(query, param);
return(true);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.MaintainScrollPositionOnPostBack = true;
shopName = SellersBLL.GetSignName(Users.Nick);
users.Value = shopName;
if (!Page.IsPostBack)
{
string type = string.Empty;
if (Request.QueryString["type"] != null)
{
type = Request.QueryString["type"].ToString();
}
else
{
type = "notplay";
}
//初始化短信发送条件配置
MsgSendConfig o = new MsgSendConfig();
o.warnType = type;
mark = type;
//o.SellerNick = "TestAcc001";
o.SellerNick = Users.Nick;
if (MemberNotifyBLL.CheckMsgConfigTypeIsExit(o))
{
InitAutoControl(o);
}
else
{
clearValue(o.warnType);
}
}
}
public static bool UpdateHuiZJMsgConfig(MsgSendConfig o)
{
try
{
string query = @"update MsgSendConfig
set
huiZJType = @huiZJType,
huiZJNofityMsg = @huiZJNofityMsg,
huiZJNofityMsgCus= @huiZJNofityMsgCus,
isHuiZJMsgCus = @isHuiZJMsgCus,
updateDate = GETDATE()
where sellerNick = @sellerNick";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@huiZJType", o.HuiZJType),
new SqlParameter("@huiZJNofityMsg", o.HuiZJNofityMsg),
new SqlParameter("@huiZJNofityMsgCus", o.HuiZJNofityMsgCus),
new SqlParameter("@isHuiZJMsgCus", o.IsHuiZJMsgCus),
new SqlParameter("@sellerNick", o.SellerNick)
};
DataBase.ExecuteSql(query, param);
return(true);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.MaintainScrollPositionOnPostBack = true;
if (!Page.IsPostBack)
{
//初始化短信发送条件配置
MsgSendConfig o = new MsgSendConfig();
o.SellerNick = Users.Nick;
if (!MemberNotifyBLL.CheckMsgConfigIsExit(o))
{
o.BuyerLevel = 0;
o.Amount = "0";
o.UnPayType = "0";
o.PayType = "0";
o.ShippingType = "0";
o.DelayShippingType = "0";
o.ArrivedType = "0";
o.SignType = "0";
o.ReturnGoodsType = "0";
o.UnpayMsg = rdounpayTemp1.Text.Trim();
o.PayMsg = rdoPayType1.Text.Trim();
o.ShippingNofityMsg = rdoShippingCont1.Text.Trim();
o.DelayShippingNofityMsg = rdoDelayShipping.Text.Trim();
o.ArrivedNofityMsg = RadioButton4.Text.Trim();
o.SignNofityMsg = rdoSign1.Text.Trim();
o.ReturnGoodsMsg = "";
o.ShopName = SellersBLL.GetSignName(Users.Nick);
MemberNotifyBLL.AddMsgConfig(o);
}
else
{
InitAutoControl(o);
}
if (AppCusBLL.CheckAppCusIsExit(Users.Nick))
{
btnAuothOpen.ImageUrl = "~/Images/rate/2open.png";
}
lbShopSignPre.Text = "【" + SellersBLL.GetSignName(Users.Nick) + "】";
}
lbMsg.Text = "";
lberror2.Text = "";
lberror.Text = "";
lbSignMsg.Text = "";
versionControl.Visible = false;
if (!Utility.CheckCanSendEmail())
{
msgReminder.Visible = true;
}
else
{
msgReminder.Visible = false;
}
msgAcountCheck.Visible = false;
}
MsgSendConfig getMsgObj()
{
MsgSendConfig o = new MsgSendConfig();
o.SellerNick = Users.Nick;
//o.SellerNick = "TestAcc001";
o.ShopName = shopName;
return(o);
}
protected void receivable_Click(object sender, ImageClickEventArgs e)
{
InitImgUrl();
receivable.ImageUrl = @"../../Win_Image/huikuan01.jpg";
MsgSendConfig o = getMsgObj();
o.warnType = "refund";
InitAutoControl(o);
Label25.Text = getNameByType(o.warnType);
}
/// <summary>
/// 催款提醒
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void notpaying_Click(object sender, ImageClickEventArgs e)
{
InitImgUrl();
notpaying.ImageUrl = @"../../Win_Image/unfahuo01.jpg";
MsgSendConfig o = getMsgObj();
o.warnType = "notplay";
InitAutoControl(o);
Label25.Text = getNameByType(o.warnType);
}
protected void delay_Click(object sender, ImageClickEventArgs e)
{
InitImgUrl();
delay.ImageUrl = @"../../Win_Image/yanchi01.jpg";
MsgSendConfig o = getMsgObj();
o.warnType = "delaySend";
InitAutoControl(o);
Label25.Text = getNameByType(o.warnType);
}
protected void arrived_Click(object sender, ImageClickEventArgs e)
{
InitImgUrl();
arrived.ImageUrl = @"../../Win_Image/daoda01.jpg";
MsgSendConfig o = getMsgObj();
o.warnType = "arivde";
InitAutoControl(o);
Label25.Text = getNameByType(o.warnType);
}
protected void Sign_Click(object sender, ImageClickEventArgs e)
{
InitImgUrl();
Sign.ImageUrl = @"../../Win_Image/qianshou01.jpg";
MsgSendConfig o = getMsgObj();
o.warnType = "sign";
InitAutoControl(o);
Label25.Text = getNameByType(o.warnType);
}
/// <summary>
/// 付款短信
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnimgUnconfirmType_Click(object sender, ImageClickEventArgs e)
{
if (!CheckIsOpenMsgAcount())
{
return;
}
MsgSendConfig o = new MsgSendConfig();
o.SellerNick = Users.Nick;
string payMsg = "";
if (rdoPayType1.Checked)
{
payMsg = rdoPayType1.Text.Trim();
}
if (rdoPayType2.Checked)
{
payMsg = rdoPayType2.Text.Trim();
}
if (rdoPayType3.Checked)
{
payMsg = rdoPayType3.Text.Trim();
}
DataTable tb = MemberNotifyBLL.GetMsgConfigByBuyerSellerNick(o);
if (tb != null && tb.Rows.Count > 0)
{
if (tb.Rows[0]["payType"].ToString().Equals("1"))//unConfirmType：此后的业务意思是付款提醒字段
{
o.PayType = "0";
btnimgUnconfirmType.ImageUrl = "~/Images/work_on.gif";
}
else
{
btnimgUnconfirmType.ImageUrl = "~/Images/work_off.gif";
o.PayType = "1";
}
//o.Amount = tb.Rows[0]["amount"].ToString();
//o.BuyerLevel = int.Parse(tb.Rows[0]["buyerLevel"].ToString());
o.PayMsg = payMsg;
if (rdoPayTypeCus.Checked)
{
o.PayMsgCus = txtPayCus.Text.Trim();
o.IsPayMsgCus = "1";
}
else
{
o.PayMsgCus = "";
o.IsPayMsgCus = "0";
}
MemberNotifyBLL.UpdatePayMsgConfig(o);
InitAutoControl(o);
}
}
/// <summary>
/// 到达提醒
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnArrivedType_Click(object sender, ImageClickEventArgs e)
{
if (!CheckIsOpenMsgAcount())
{
return;
}
MsgSendConfig o = new MsgSendConfig();
o.SellerNick = Users.Nick;
string strArrieMsg = "";
if (RadioButton4.Checked)
{
strArrieMsg = RadioButton4.Text.Trim();
}
if (RadioButton5.Checked)
{
strArrieMsg = RadioButton5.Text.Trim();
}
if (RadioButton6.Checked)
{
strArrieMsg = RadioButton6.Text.Trim();
}
DataTable tb = MemberNotifyBLL.GetMsgConfigByBuyerSellerNick(o);
if (tb != null && tb.Rows.Count > 0)
{
if (tb.Rows[0]["arrivedType"].ToString().Equals("1"))
{
o.ArrivedType = "0";
btnArrivedType.ImageUrl = "~/Images/work_on.gif";
}
else
{
btnArrivedType.ImageUrl = "~/Images/work_off.gif";
o.ArrivedType = "1";
}
o.ArrivedNofityMsg = strArrieMsg;
if (RadioButton7.Checked)
{
o.ArrivedNofityMsgCus = txtArrivedContent.Text.Trim();
o.IsArrivedMsgCus = "1";
}
else
{
o.ArrivedNofityMsgCus = "";
o.IsArrivedMsgCus = "0";
}
MemberNotifyBLL.UpdateArrivedMsgConfig(o);
InitAutoControl(o);
}
}
/// <summary>
/// 签收
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void imgbtnSign_Click(object sender, ImageClickEventArgs e)
{
if (!CheckIsOpenMsgAcount())
{
return;
}
MsgSendConfig o = new MsgSendConfig();
o.SellerNick = Users.Nick;
string strSignMsg = "";
if (rdoSign1.Checked)
{
strSignMsg = rdoSign1.Text.Trim();
}
if (rdoSign2.Checked)
{
strSignMsg = rdoSign2.Text.Trim();
}
if (rdoSign3.Checked)
{
strSignMsg = rdoSign3.Text.Trim();
}
DataTable tb = MemberNotifyBLL.GetMsgConfigByBuyerSellerNick(o);
if (tb != null && tb.Rows.Count > 0)
{
if (tb.Rows[0]["signType"].ToString().Equals("1"))
{
o.SignType = "0";
imgbtnSign.ImageUrl = "~/Images/work_on.gif";
}
else
{
imgbtnSign.ImageUrl = "~/Images/work_off.gif";
o.SignType = "1";
}
o.SignNofityMsg = strSignMsg;
if (rdoSignCus.Checked)
{
o.SignNotifyMsgCus = txtSignCus.Text.Trim();
o.IsSignMsgCus = "1";
}
else
{
o.SignNotifyMsgCus = "";
o.IsSignMsgCus = "0";
}
MemberNotifyBLL.UpdateSignMsgConfig(o);
InitAutoControl(o);
}
}
/// <summary>
/// unpay付款提醒自动通知
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnimgAutoStart_Click(object sender, ImageClickEventArgs e)
{
if (!CheckIsOpenMsgAcount())
{
return;
}
MsgSendConfig o = new MsgSendConfig();
o.SellerNick = Users.Nick;
string strUnpayMsg = "";
if (rdounpayTemp1.Checked)
{
strUnpayMsg = rdounpayTemp1.Text.Trim();
}
if (rdounpayTemp2.Checked)
{
strUnpayMsg = rdounpayTemp2.Text.Trim();
}
if (rdounpayTemp3.Checked)
{
strUnpayMsg = rdounpayTemp3.Text.Trim();
}
DataTable tb = MemberNotifyBLL.GetMsgConfigByBuyerSellerNick(o);
if (tb != null && tb.Rows.Count > 0)
{
if (tb.Rows[0]["unPayType"].ToString().Equals("1"))
{
o.UnPayType = "0";
btnimgAutoStart.ImageUrl = "~/Images/work_on.gif";
}
else
{
btnimgAutoStart.ImageUrl = "~/Images/work_off.gif";
o.UnPayType = "1";
}
o.UnpayMsg = strUnpayMsg;
if (rdoUnpayCus.Checked)
{
o.UnpayMsgCus = txtUnpayCusContent.Text.Trim();
o.IsUnpayMsgCus = "1";
}
else
{
o.UnpayMsgCus = "";
o.IsUnpayMsgCus = "0";
}
MemberNotifyBLL.UpdateUnPayMsgConfig(o);
InitAutoControl(o);
}
}
//初始化
private void InitAutoControl(MsgSendConfig o)
{
clearValue(o.warnType);
tb = MemberNotifyBLL.getWarnInfo(o.SellerNick, o.warnType);
Label25.Text = getNameByType(o.warnType);
lb_phoneMsg.Text = "【" + shopName + "】" + getMsgByType(o.warnType);
mark = o.warnType;
if (tb != null && tb.Rows.Count > 0)
{
//是否开启
int ret = Convert.ToInt16(tb.Rows[0]["unPayType"] == DBNull.Value ? 0 : tb.Rows[0]["unPayType"]);
if (ret == 1)
{
radio_off.Checked = false;
radio_on.Checked = true;
}
else
{
radio_on.Checked = false;
radio_off.Checked = true;
}
//短信内容
txt_div_nopay_msg.Text = Convert.ToString(tb.Rows[0]["unpayMsg"]);
//发送短信的金额条件
txtAmount.Text = Convert.ToString(tb.Rows[0]["amount"]);
txtAmount01.Text = Convert.ToString(tb.Rows[0]["amountMax"]);
//txtAmount01.Text = tb.Rows[0]["amountMax"].ToString();
//黑名单
string blacklist = Convert.ToString(tb.Rows[0]["blackListType"]);
if (blacklist.Equals("1"))
{
cbx_blackList.Checked = true;
}
////3天内发送过的会员
if (Convert.ToString(tb.Rows[0]["threeDayType"]).Equals("1"))
{
cbx_threeDay.Checked = true;
}
////顾虑的地区不发送
if (Convert.ToString(tb.Rows[0]["areaType"]).Equals("1"))
{
cbx_area.Checked = true;
tbx_area.Text = Convert.ToString(tb.Rows[0]["areaList"]);
}
}
}
/// <summary>
/// 延时发货
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelayShipping_Click(object sender, ImageClickEventArgs e)
{
if (!CheckIsOpenMsgAcount())
{
return;
}
MsgSendConfig o = new MsgSendConfig();
o.SellerNick = Users.Nick;
string strDelayMsg = "";
if (rdoDelayShipping.Checked)
{
strDelayMsg = rdoDelayShipping.Text.Trim();
}
DataTable tb = MemberNotifyBLL.GetMsgConfigByBuyerSellerNick(o);
if (tb != null && tb.Rows.Count > 0)
{
if (tb.Rows[0]["delayShippingType"].ToString().Equals("1"))
{
o.DelayShippingType = "0";
btnDelayShipping.ImageUrl = "~/Images/work_on.gif";
}
else
{
btnDelayShipping.ImageUrl = "~/Images/work_off.gif";
o.DelayShippingType = "1";
}
o.DelayShippingNofityMsg = strDelayMsg;
if (rdoDelayShipCus.Checked)
{
o.DelayShippingNofityMsgCus = txtDelayShippingCus.Text.Trim();
o.IsDelayShippingMsgCus = "1";
}
else
{
o.DelayShippingNofityMsgCus = "";
o.IsDelayShippingMsgCus = "0";
}
MemberNotifyBLL.UpdateDelayShippingMsgConfig(o);
InitAutoControl(o);
}
}
public static DataTable GetMsgConfigByBuyerSellerNick(MsgSendConfig entity)
{
try
{
string query = @"select * from MsgSendConfig where sellerNick = @sellerNick";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", entity.SellerNick)
};
DataTable dt = DataBase.ExecuteDt(query, param, CommandType.Text);
return(dt);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(null);
}
}
//检查参数
//修改人：LU
//日期：20160909
public static bool AddMsgConfig(MsgSendConfig o)
{
try
{
string query = @"insert into MsgSendConfig(
sellerNick,unPayType,unpayMsg,payType,payMsg,shippingType,shippingNofityMsg,delayShippingType,delayShippingNofityMsg,
arrivedType,arrivedNofityMsg,signType,signNofityMsg,returnGoodsType,returnGoodsMsg,buyerLevel,amount,shopName,createDate)
values(
@sellerNick,@unPayType,@unpayMsg,@payType,@payMsg,@shippingType,@shippingNofityMsg,@delayShippingType,@delayShippingNofityMsg,
@arrivedType,@arrivedNofityMsg,@signType,@signNofityMsg,@returnGoodsType,@returnGoodsMsg,@buyerLevel,@amount,@shopName,getdate())";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", o.SellerNick),
new SqlParameter("@unPayType", o.UnPayType),
new SqlParameter("@unpayMsg", string.IsNullOrEmpty(o.UnpayMsg)?"":o.UnpayMsg),
new SqlParameter("@payType", o.PayType),
new SqlParameter("@payMsg", string.IsNullOrEmpty(o.PayMsg)?"":o.PayMsg),
new SqlParameter("@shippingType", o.ShippingType),
new SqlParameter("@shippingNofityMsg", string.IsNullOrEmpty(o.ShippingNofityMsg)?"":o.ShippingNofityMsg),
new SqlParameter("@delayShippingType", o.DelayShippingType),
new SqlParameter("@delayShippingNofityMsg", string.IsNullOrEmpty(o.DelayShippingNofityMsg)?"":o.DelayShippingNofityMsg),
new SqlParameter("@arrivedType", o.ArrivedType),
new SqlParameter("@arrivedNofityMsg", string.IsNullOrEmpty(o.ArrivedNofityMsg)?"":o.ArrivedNofityMsg),
new SqlParameter("@signType", o.SignType),
new SqlParameter("@signNofityMsg", string.IsNullOrEmpty(o.SignNofityMsg)?"":o.SignNofityMsg),
new SqlParameter("@returnGoodsType", o.ReturnGoodsType),
new SqlParameter("@returnGoodsMsg", string.IsNullOrEmpty(o.ReturnGoodsMsg)?"未设置":o.ReturnGoodsMsg),
new SqlParameter("@buyerLevel", o.BuyerLevel),
new SqlParameter("@shopName", o.ShopName),
new SqlParameter("@amount", o.Amount)
};
DataBase.ExecuteSql(query, param);
return(true);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
/// <summary>
/// 20160828 create yao
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static bool UpdateOtherParm(MsgSendConfig o)
{
try
{
string query = @"update MsgSendConfig set amount = @amount, updateDate = GETDATE() where sellerNick = @sellerNick";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@amount", o.Amount),
new SqlParameter("@sellerNick", o.SellerNick)
};
DataBase.ExecuteSql(query, param);
return(true);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
/// <summary>
/// 添加警告2016-10-09 yao c
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static Boolean updateWarn(MsgSendConfig o)
{
try
{
string query = @"update tab_MsgConfig
set
unPayType = @unPayType,
unpayMsg = @unpayMsg,
threeDayType= @threeDayType,
blackListType = @blackListType,
areaType = @areaType,
areaList=@areaList,
amount=@amount,
amountMax=@amountMax,
updateDate = GETDATE()
where sellerNick = @sellerNick and warnType=@warnType ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", o.SellerNick),
new SqlParameter("@warnType", o.warnType),
new SqlParameter("@unPayType", o.UnPayType),
new SqlParameter("@unpayMsg", string.IsNullOrEmpty(o.UnpayMsg)?"":o.UnpayMsg),
new SqlParameter("@threeDayType", o.threeDayType),
new SqlParameter("@blackListType", o.blackListType),
new SqlParameter("@areaType", o.areType),
new SqlParameter("@areaList", string.IsNullOrEmpty(o.areList)?"":o.areList),
new SqlParameter("@amount", o.Amount),
new SqlParameter("@amountMax", o.AmountMax)
};
DataBase.ExecuteSql(query, param);
return(true);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
public static Boolean CheckMsgConfigIsExit(MsgSendConfig o)
{
try
{
string query = @"SELECT 1 FROM MsgSendConfig WHERE sellerNick=@sellerNick";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", o.SellerNick)
};
DataTable dt = DataBase.ExecuteDt(query, param, CommandType.Text);
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
// public static bool UpdateMsgContent(MsgSendConfig o)
// {
// try
// {
// string query = @"update MsgSendConfig set unPayType = @unPayType,payType = @payType,
// shippingType = @shippingType,buyerLevel=@buyerLevel,amount = @amount,shippingNofityMsg = @shippingNofityMsg,
// updateDate = GETDATE() where sellerNick = @sellerNick";
// SqlParameter[] param = new SqlParameter[]
// {
// new SqlParameter("@unPayType",o.UnPayType),
// new SqlParameter("@payType",o.PayType),
// new SqlParameter("@shippingType",o.ShippingType),
// new SqlParameter("@buyerLevel",o.BuyerLevel),
// new SqlParameter("@amount",o.Amount),
// new SqlParameter("@shippingNofityMsg",o.ShippingNofityMsg),
// new SqlParameter("@sellerNick",o.SellerNick)
// };
// DataBase.ExecuteSql(query, param);
// return true;
// }
// catch (Exception ex)
// {
// ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
// return false;
// }
// }
public static bool UpdateMsgConfig(MsgSendConfig o)
{
try
{
string query = @"update MsgSendConfig
set
unPayType = @unPayType,
unpayMsg = @unpayMsg,
unpayMsgCus = @unpayMsgCus,
isUnpayMsgCus = @isUnpayMsgCus,
payType = @payType,
payMsg = @payMsg,
payMsgCus = @payMsgCus,
isPayMsgCus = @isPayMsgCus,
shippingType = @shippingType,
shippingNofityMsg = @shippingNofityMsg,
shippingNofityMsgCus = @shippingNofityMsgCus,
isShippingMsgCus = @isShippingMsgCus,
delayShippingType = @delayShippingType,
delayShippingNofityMsg = @delayShippingNofityMsg,
delayShippingNofityMsgCus = @delayShippingNofityMsgCus,
isDelayShippingMsgCus = @isDelayShippingMsgCus,
arrivedType = @arrivedType,
arrivedNofityMsg = @arrivedNofityMsg,
arrivedNofityMsgCus = @arrivedNofityMsgCus,
isArrivedMsgCus = @isArrivedMsgCus,
signType = @signType,
signNofityMsg = @signNofityMsg,
signNotifyMsgCus = @signNotifyMsgCus,
isSignMsgCus = @isSignMsgCus,
huiZJType = @huiZJType,
huiZJNofityMsg = @huiZJNofityMsg,
huiZJNofityMsgCus = @huiZJNofityMsgCus,
isHuiZJMsgCus = @isHuiZJMsgCus,
buyerLevel= @buyerLevel,
amount = @amount,
shopName = @shopName,
updateDate = GETDATE()
where sellerNick = @sellerNick";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@unPayType", o.UnPayType),
new SqlParameter("@unpayMsg", o.UnpayMsg),
new SqlParameter("@unpayMsgCus", o.UnpayMsgCus),
new SqlParameter("@isUnpayMsgCus", o.IsUnpayMsgCus),
new SqlParameter("@payType", o.PayType),
new SqlParameter("@payMsg", o.PayMsg),
new SqlParameter("@payMsgCus", o.PayMsgCus),
new SqlParameter("@isPayMsgCus", o.IsPayMsgCus),
new SqlParameter("@shippingType", o.ShippingType),
new SqlParameter("@shippingNofityMsg", o.ShippingNofityMsg),
new SqlParameter("@shippingNofityMsgCus", o.ShippingNofityMsgCus),
new SqlParameter("@isShippingMsgCus", o.IsShippingMsgCus),
new SqlParameter("@delayShippingType", o.DelayShippingType),
new SqlParameter("@delayShippingNofityMsg", o.DelayShippingNofityMsg),
new SqlParameter("@delayShippingNofityMsgCus", o.DelayShippingNofityMsgCus),
new SqlParameter("@isDelayShippingMsgCus", o.IsDelayShippingMsgCus),
new SqlParameter("@arrivedType", o.ArrivedType),
new SqlParameter("@arrivedNofityMsg", o.ArrivedNofityMsg),
new SqlParameter("@arrivedNofityMsgCus", o.ArrivedNofityMsgCus),
new SqlParameter("@isArrivedMsgCus", o.IsArrivedMsgCus),
new SqlParameter("@signType", o.SignType),
new SqlParameter("@signNofityMsg", o.SignNofityMsg),
new SqlParameter("@signNotifyMsgCus", o.SignNotifyMsgCus),
new SqlParameter("@isSignMsgCus", o.IsSignMsgCus),
new SqlParameter("@huiZJType", o.HuiZJType),
new SqlParameter("@huiZJNofityMsg", o.HuiZJNofityMsg),
new SqlParameter("@huiZJNofityMsgCus", o.HuiZJNofityMsgCus),
new SqlParameter("@isHuiZJMsgCus", o.IsHuiZJMsgCus),
new SqlParameter("@buyerLevel", o.BuyerLevel),
new SqlParameter("@amount", o.Amount),
new SqlParameter("@shopName", o.ShopName),
new SqlParameter("@sellerNick", o.SellerNick)
};
DataBase.ExecuteSql(query, param);
return(true);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
public static bool CheckMsgConfigTypeIsExit(MsgSendConfig o)
{
return(MemberNotifyDAL.CheckMsgConfigTypeIsExit(o));
}
public static bool updateWarn(MsgSendConfig o)
{
return(MemberNotifyDAL.updateWarn(o));
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
bool isOk = false;
MsgSendConfig msc = getMsgObj();
msc.warnType = mark;
int amount = 0;
int amount01 = 0;
try
{
amount = Convert.ToInt32(txtAmount.Text.Trim());
amount01 = Convert.ToInt32(txtAmount01.Text.Trim());
if (amount >= amount01)
{
Alert("请输入正确的订单金额！");
}
}
catch
{
Alert("请输入正确的金额！");
return;
}
msc.Amount = amount.ToString();
msc.AmountMax = amount01.ToString();
//是否开启提醒 统一使用UnPayType作为短信内容
if (radio_on.Checked)
{
msc.UnPayType = "1";
}
else
{
msc.UnPayType = "0";
}
//是否开启黑名单过滤
if (cbx_blackList.Checked == true)
{
msc.blackListType = 1;
}
else
{
msc.blackListType = 0;
}
//是否开启3天过滤
if (cbx_threeDay.Checked == true)
{
msc.threeDayType = 1;
}
else
{
msc.threeDayType = 0;
}//是否开启地区过滤
if (cbx_area.Checked == true)
{
msc.areType = 1;
msc.areList = tbx_area.Text.Trim();
}
//金额过滤
msc.Amount = txtAmount.Text.Trim();
//短信内容 统一使用UnpayMsg作为短信内容
msc.UnpayMsg = txt_div_nopay_msg.Text.Trim();
msc.warnType = mark;
if (MemberNotifyBLL.CheckMsgConfigTypeIsExit(msc))
{
isOk = MemberNotifyBLL.updateWarn(msc);
}
else
{
isOk = MemberNotifyBLL.addWarnConfig(msc);
}
if (isOk)
{
Alert("保存成功！");
}
else
{
Alert("保存失败！");
}
}
private void InitAutoControl(MsgSendConfig o)
{
DataTable tb = MemberNotifyBLL.GetMsgConfigByBuyerSellerNick(o);
if (tb != null && tb.Rows.Count > 0)
{
//未付款提醒
if (tb.Rows[0]["unPayType"].ToString().Equals("1"))
{
btnimgAutoStart.ImageUrl = "~/Images/work_on.gif";
}
else
{
btnimgAutoStart.ImageUrl = "~/Images/work_off.gif";
}
//付款提醒
if (tb.Rows[0]["payType"].ToString().Equals("1"))
{
btnimgUnconfirmType.ImageUrl = "~/Images/work_on.gif";
}
else
{
btnimgUnconfirmType.ImageUrl = "~/Images/work_off.gif";
}
//发货通知
if (tb.Rows[0]["shippingType"].ToString().Equals("1"))
{
btnimgshippingType.ImageUrl = "~/Images/work_on.gif";
//rdoShipingStatus(true);
}
else
{
btnimgshippingType.ImageUrl = "~/Images/work_off.gif";
//rdoShipingStatus(false);
}
//延迟发货
if (tb.Rows[0]["delayShippingType"].ToString().Equals("1"))
{
btnDelayShipping.ImageUrl = "~/Images/work_on.gif";
}
else
{
btnDelayShipping.ImageUrl = "~/Images/work_off.gif";
}
//达到提醒
if (tb.Rows[0]["arrivedType"].ToString().Equals("1"))
{
btnArrivedType.ImageUrl = "~/Images/work_on.gif";
}
else
{
btnArrivedType.ImageUrl = "~/Images/work_off.gif";
}
//签收
if (tb.Rows[0]["signType"].ToString().Equals("1"))
{
imgbtnSign.ImageUrl = "~/Images/work_on.gif";
}
else
{
imgbtnSign.ImageUrl = "~/Images/work_off.gif";
}
//回款
if (tb.Rows[0]["huiZJType"].ToString().Equals("1"))
{
btnHuiZJ.ImageUrl = "~/Images/work_on.gif";
}
else
{
btnHuiZJ.ImageUrl = "~/Images/work_off.gif";
}
//催款
if (rdounpayTemp1.Text.Equals(tb.Rows[0]["unpayMsg"].ToString()))
{
rdounpayTemp1.Checked = true;
}
if (rdounpayTemp2.Text.Equals(tb.Rows[0]["unpayMsg"].ToString()))
{
rdounpayTemp2.Checked = true;
}
if (rdounpayTemp3.Text.Equals(tb.Rows[0]["unpayMsg"].ToString()))
{
rdounpayTemp3.Checked = true;
}
if (tb.Rows[0]["isUnpayMsgCus"].ToString().Equals("1"))
{
rdoUnpayCus.Checked = true;
}
txtUnpayCusContent.Text = tb.Rows[0]["unpayMsgCus"].ToString();
//付款
if (rdoPayType1.Text.Equals(tb.Rows[0]["payMsg"].ToString()))
{
rdoPayType1.Checked = true;
}
if (rdoPayType2.Text.Equals(tb.Rows[0]["payMsg"].ToString()))
{
rdoPayType2.Checked = true;
}
if (rdoPayType3.Text.Equals(tb.Rows[0]["payMsg"].ToString()))
{
rdoPayType3.Checked = true;
}
if (tb.Rows[0]["isPayMsgCus"].ToString().Equals("1"))
{
rdoPayTypeCus.Checked = true;
}
txtPayCus.Text = tb.Rows[0]["payMsgCus"].ToString();
//发货
if (rdoShippingCont1.Text.Equals(tb.Rows[0]["shippingNofityMsg"].ToString()))
{
rdoShippingCont1.Checked = true;
}
if (rdoShippingCont2.Text.Equals(tb.Rows[0]["shippingNofityMsg"].ToString()))
{
rdoShippingCont2.Checked = true;
}
if (rdoShippingCont3.Text.Equals(tb.Rows[0]["shippingNofityMsg"].ToString()))
{
rdoShippingCont3.Checked = true;
}
if (tb.Rows[0]["isShippingMsgCus"].ToString().Equals("1"))
{
rdoShiping.Checked = true;
}
txtShippingContent.Text = tb.Rows[0]["shippingNofityMsgCus"].ToString();
//延迟发货
if (rdoDelayShipping.Text.Equals(tb.Rows[0]["delayShippingNofityMsg"].ToString()))
{
rdoDelayShipping.Checked = true;
}
if (tb.Rows[0]["isDelayShippingMsgCus"].ToString().Equals("1"))
{
rdoDelayShipCus.Checked = true;
}
txtDelayShippingCus.Text = tb.Rows[0]["delayShippingNofityMsgCus"].ToString();
//达到
if (RadioButton4.Text.Equals(tb.Rows[0]["arrivedNofityMsg"].ToString()))
{
RadioButton4.Checked = true;
}
if (RadioButton5.Text.Equals(tb.Rows[0]["arrivedNofityMsg"].ToString()))
{
RadioButton5.Checked = true;
}
if (RadioButton6.Text.Equals(tb.Rows[0]["arrivedNofityMsg"].ToString()))
{
RadioButton6.Checked = true;
}
if (tb.Rows[0]["isArrivedMsgCus"].ToString().Equals("1"))
{
RadioButton7.Checked = true;
}
txtArrivedContent.Text = tb.Rows[0]["arrivedNofityMsgCus"].ToString();
//签收
if (rdoSign1.Text.Equals(tb.Rows[0]["signNofityMsg"].ToString()))
{
rdoSign1.Checked = true;
}
if (rdoSign2.Text.Equals(tb.Rows[0]["signNofityMsg"].ToString()))
{
rdoSign2.Checked = true;
}
if (rdoSign3.Text.Equals(tb.Rows[0]["signNofityMsg"].ToString()))
{
rdoSign3.Checked = true;
}
if (tb.Rows[0]["isSignMsgCus"].ToString().Equals("1"))
{
rdoSignCus.Checked = true;
}
txtSignCus.Text = tb.Rows[0]["signNotifyMsgCus"].ToString();
//回款
if (rdoHuiZJCont.Text.Equals(tb.Rows[0]["huiZJNofityMsg"].ToString()))
{
rdoHuiZJCont.Checked = true;
}
if (tb.Rows[0]["isHuiZJMsgCus"].ToString().Equals("1"))
{
rdoHuiZJCus.Checked = true;
}
txtHuiZJContent.Text = tb.Rows[0]["huiZJNofityMsgCus"].ToString();
txtArrivedContent.Text = tb.Rows[0]["arrivedNofityMsgCus"].ToString();
txtAmount.Text = tb.Rows[0]["amount"].ToString();
}
}
public static bool addWarnConfig(MsgSendConfig o)
{
return(MemberNotifyDAL.addWarnConfig(o));
}
public static DataTable GetMsgConfigByBuyerSellerNick(MsgSendConfig entity)
{
return(MemberNotifyDAL.GetMsgConfigByBuyerSellerNick(entity));
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
try
{
//检查输入项的值是否正确
if (String.IsNullOrEmpty(txtAmount.Text.Trim()))
{
lberror2.Text = "金额不能为空！"; return;
}
if (!Utility.IsINT(txtAmount.Text.Trim()))
{
lberror2.Text = "金额必须为正整数！"; return;
}
MsgSendConfig o = new MsgSendConfig();
o.SellerNick = Users.Nick;
o.ShopName = SellersBLL.GetSignName(Users.Nick);
string strUnpayType = "0";
string payType = "0";
string shippingType = "0";
string arrivedType = "0";
string signType = "0";
string delayShipType = "0";
string huiZJType = "0";
DataTable tb = MemberNotifyBLL.GetMsgConfigByBuyerSellerNick(o);
if (tb != null && tb.Rows.Count > 0)
{
strUnpayType = tb.Rows[0]["unPayType"].ToString();
payType = tb.Rows[0]["payType"].ToString();
shippingType = tb.Rows[0]["shippingType"].ToString();
arrivedType = tb.Rows[0]["arrivedType"].ToString();
signType = tb.Rows[0]["signType"].ToString();
delayShipType = tb.Rows[0]["delayShippingType"].ToString();
huiZJType = tb.Rows[0]["huiZJType"].ToString();
}
#region 催款
string strUnpayMsg = "";
string unpayMsgCus = "";
string isUnpayMsgCus = "0";
if (rdounpayTemp1.Checked)
{
strUnpayMsg = rdounpayTemp1.Text.Trim();
}
if (rdounpayTemp2.Checked)
{
strUnpayMsg = rdounpayTemp2.Text.Trim();
}
if (rdounpayTemp3.Checked)
{
strUnpayMsg = rdounpayTemp3.Text.Trim();
}
if (rdoUnpayCus.Checked)
{
unpayMsgCus = txtUnpayCusContent.Text.Trim();
isUnpayMsgCus = "1";
}
else
{
unpayMsgCus = "";
isUnpayMsgCus = "0";
}
o.UnpayMsg = strUnpayMsg;
o.UnPayType = strUnpayType;
o.UnpayMsgCus = unpayMsgCus;
o.IsUnpayMsgCus = isUnpayMsgCus;
#endregion
#region 付款
string payMsg = "";
string payMsgCus = "";
string isPayMsgCus = "0";
if (rdoPayType1.Checked)
{
payMsg = rdoPayType1.Text.Trim();
}
if (rdoPayType2.Checked)
{
payMsg = rdoPayType2.Text.Trim();
}
if (rdoPayType3.Checked)
{
payMsg = rdoPayType3.Text.Trim();
}
if (rdoPayTypeCus.Checked)
{
payMsgCus = txtPayCus.Text.Trim();
isPayMsgCus = "1";
}
else
{
payMsgCus = "";
isPayMsgCus = "0";
}
o.PayMsg = payMsg;
o.PayType = payType;
o.PayMsgCus = payMsgCus;
o.IsPayMsgCus = isPayMsgCus;
#endregion
#region 发货
string shippingNofityMsg = "";
string shippingNofityMsgCus = "";
string isShippingMsgCus = "0";
if (rdoShippingCont1.Checked)
{
shippingNofityMsg = rdoShippingCont1.Text.Trim();
}
if (rdoShippingCont2.Checked)
{
shippingNofityMsg = rdoShippingCont2.Text.Trim();
}
if (rdoShippingCont3.Checked)
{
shippingNofityMsg = rdoShippingCont3.Text.Trim();
}
if (rdoShiping.Checked)
{
shippingNofityMsgCus = txtShippingContent.Text.Trim();
isShippingMsgCus = "1";
}
else
{
shippingNofityMsgCus = "";
isShippingMsgCus = "0";
}
o.ShippingNofityMsg = shippingNofityMsg;
o.ShippingType = shippingType;
o.ShippingNofityMsgCus = shippingNofityMsgCus;
o.IsShippingMsgCus = isShippingMsgCus;
#endregion
#region 延时发货
string delayShippingNofityMsg = "";
string delayShippingNofityMsgCus = "";
string isDelayShippingMsgCus = "0";
if (rdoDelayShipping.Checked)
{
delayShippingNofityMsg = rdoDelayShipping.Text.Trim();
}
if (rdoDelayShipCus.Checked)
{
delayShippingNofityMsgCus = txtDelayShippingCus.Text.Trim();
isDelayShippingMsgCus = "1";
}
else
{
delayShippingNofityMsgCus = "";
isDelayShippingMsgCus = "0";
}
o.DelayShippingNofityMsg = delayShippingNofityMsg;
o.DelayShippingType = delayShipType;
o.DelayShippingNofityMsgCus = delayShippingNofityMsgCus;
o.IsDelayShippingMsgCus = isDelayShippingMsgCus;
#endregion
#region 达到
string arrivedNofityMsg = "";
string arrivedNofityMsgCus = "";
string isArrivedMsgCus = "0";
if (RadioButton4.Checked)
{
arrivedNofityMsg = RadioButton4.Text.Trim();
}
if (RadioButton5.Checked)
{
arrivedNofityMsg = RadioButton5.Text.Trim();
}
if (RadioButton6.Checked)
{
arrivedNofityMsg = RadioButton6.Text.Trim();
}
if (RadioButton7.Checked)
{
arrivedNofityMsgCus = txtArrivedContent.Text.Trim();
isArrivedMsgCus = "1";
}
else
{
arrivedNofityMsgCus = "";
isArrivedMsgCus = "0";
}
o.ArrivedNofityMsg = arrivedNofityMsg;
o.ArrivedType = arrivedType;
o.ArrivedNofityMsgCus = arrivedNofityMsgCus;
o.IsArrivedMsgCus = isArrivedMsgCus;
#endregion
#region 签收
string signNofityMsg = "";
string signNotifyMsgCus = "";
string isSignMsgCus = "0";
if (rdoSign1.Checked)
{
signNofityMsg = rdoSign1.Text.Trim();
}
if (rdoSign2.Checked)
{
signNofityMsg = rdoSign2.Text.Trim();
}
if (rdoSign3.Checked)
{
signNofityMsg = rdoSign3.Text.Trim();
}
if (rdoSignCus.Checked)
{
signNotifyMsgCus = txtSignCus.Text.Trim();
isSignMsgCus = "1";
}
else
{
signNotifyMsgCus = "";
isSignMsgCus = "0";
}
o.SignNofityMsg = signNofityMsg;
o.SignType = signType;
o.SignNotifyMsgCus = signNotifyMsgCus;
o.IsSignMsgCus = isSignMsgCus;
#endregion
#region 回款
string huiZJNofityMsg = "";
string huiZJNotifyMsgCus = "";
string isHuiZJMsgCus = "0";
if (rdoHuiZJCont.Checked)
{
huiZJNofityMsg = rdoHuiZJCont.Text.Trim();
}
if (rdoHuiZJCus.Checked)
{
huiZJNotifyMsgCus = txtHuiZJContent.Text.Trim();
isHuiZJMsgCus = "1";
}
else
{
huiZJNotifyMsgCus = "";
isHuiZJMsgCus = "0";
}
o.HuiZJNofityMsg = huiZJNofityMsg;
o.HuiZJType = huiZJType;
o.HuiZJNofityMsgCus = huiZJNotifyMsgCus;
o.IsHuiZJMsgCus = isHuiZJMsgCus;
#endregion
//if (tb != null && tb.Rows.Count > 0)
//{
o.Amount = txtAmount.Text.Trim().ToString();
o.BuyerLevel = 0;
if (MemberNotifyBLL.UpdateMsgConfig(o))
{
lbMsg.Text = "条件保存成功！";
lbMsg.ForeColor = Color.Blue;
}
else
{
lbMsg.Text = "条件保存失败，请联系客服";
}
//}
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Web_UI);
lbMsg.Text = "条件保存失败，请联系客服";
}
}
public static bool UpdateHuiZJMsgConfig(MsgSendConfig o)
{
return(MemberNotifyDAL.UpdateHuiZJMsgConfig(o));
}
