/// <summary>
/// 增加一条数据
/// </summary>
public static int AddSupp(ChannelTypeUserInfo model)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@typeId", SqlDbType.Int, 4),
new SqlParameter("@userId", SqlDbType.Int, 4),
new SqlParameter("@suppid", SqlDbType.Int, 4),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@updateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.typeId;
parameters[1].Value = model.userId;
parameters[2].Value = model.suppid;
parameters[3].Value = model.addTime;
parameters[4].Value = model.updateTime;
object obj = DataBase.ExecuteScalar(CommandType.StoredProcedure, "proc_channeltypeusers_addsuppid", parameters);
if (obj == null)
{
return(0);
}
else
{
ClearCache(model.userId);
return(Convert.ToInt32(obj));
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(0);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void rpt_paymode_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView dr = e.Item.DataItem as DataRowView;
int typeId = int.Parse(dr["typeId"].ToString());
ChannelTypeUserInfo setting = ChannelTypeUsers.GetModel(UserID, typeId);
if (setting != null)
{
if (setting.sysIsOpen.HasValue)
{
Button btnOpen = e.Item.FindControl("btn_open") as Button;
Button btnClose = e.Item.FindControl("btn_close") as Button;
btnOpen.Enabled = !setting.sysIsOpen.Value;
btnClose.Enabled = setting.sysIsOpen.Value;
}
}
DropDownList ddlsupp = e.Item.FindControl("ddlsupp") as DropDownList;
if (ddlsupp != null)
{
////ddlsupp.Visible = (typeId == 102);
//if (typeId == 102)
//{
//}
int suppid = int.Parse(dr["suppid"].ToString());
bind(ddlsupp, suppid);
}
}
}
/// <summary>
/// 系统通道状态 包括后台对用户的设置，通道本身的开户状态
/// </summary>
/// <param name="userId"></param>
/// <param name="chanelNo"></param>
/// <param name="typeId"></param>
/// <param name="defaultvalue"></param>
/// <returns></returns>
public static bool GetSysOpenStatus(int userId, int typeId, bool defaultvalue)
{
bool result = defaultvalue;
ChannelTypeUserInfo typeuserinfo = ChannelTypeUsers.GetCacheModel(userId, typeId);
if (typeuserinfo == null)
{
return(result);
}
/*系统设置状态*/
if (typeuserinfo.sysIsOpen.HasValue)
{
result = typeuserinfo.sysIsOpen.Value;
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <param name="typeId"></param>
/// <param name="defaultvalue"></param>
/// <returns></returns>
public static int GetUserOpenStatus(int userId, int typeId, int defaultvalue)
{
int result = defaultvalue;
ChannelTypeUserInfo typeuserinfo = ChannelTypeUsers.GetCacheModel(userId, typeId);
if (typeuserinfo == null)
{
return(result);
}
/*用户设置状态*/
if (typeuserinfo.userIsOpen.HasValue)
{
result = typeuserinfo.userIsOpen.Value ? 1 : 0;
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string flag = Request.QueryString["flag"];
int uid = CurrentUser.ID;
string channelId = Request.QueryString["id"];
if (!string.IsNullOrEmpty(flag) && !string.IsNullOrEmpty(channelId))
{
ChannelTypeUserInfo info = new ChannelTypeUserInfo();
info.typeId = Convert.ToInt32(channelId);
info.userId = CurrentUser.ID;
info.userIsOpen = flag == "on" ? true : false;
info.sysIsOpen = null;
info.addTime = DateTime.Now;
info.updateTime = DateTime.Now;
viviapi.BLL.Channel.ChannelTypeUsers.Add(info);
}
LoadData();
}
}
void DoCmd()
{
if (typeId > 0 && !string.IsNullOrEmpty(cmd) && this.ajaxUserId > 0)
{
var obj = new ChannelTypeUserInfo
{
userId = ajaxUserId,
typeId = typeId,
sysIsOpen = cmd != "close",
addTime = DateTime.Now,
userIsOpen = null
};
string result = "error";
if (viviapi.BLL.Channel.ChannelTypeUsers.Add(obj) > 0)
{
result = "success";
}
Response.Write(result);
Response.End();
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
foreach (RepeaterItem item in rpt_paymode.Items)
{
if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)
{
HiddenField hfTypeId = item.FindControl("hftypeId") as HiddenField;
if (hfTypeId != null)
{
int typeId = Convert.ToInt32(hfTypeId.Value);
DropDownList ddlsupp = item.FindControl("ddlsupp") as DropDownList;
if (ddlsupp != null)
{
var setting = new ChannelTypeUserInfo {
updateTime = DateTime.Now, typeId = typeId
};
setting.updateTime = DateTime.Now;
setting.userId = UserID;
setting.suppid = int.Parse(ddlsupp.SelectedValue);
ChannelTypeUsers.AddSupp(setting);
}
//if (typeId == 102)
//{
//}
}
}
string cacheKey = string.Format(ChannelTypeUsers.ChannelTypeUsers_CACHEKEY, UserID);
viviapi.WebComponents.WebUtility.ClearCache(cacheKey);
}
LoadData();
}
/// <summary>
///
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void rpt_paymode_ItemCommand(object source, RepeaterCommandEventArgs e)
{
var setting = new ChannelTypeUserInfo
{
updateTime = DateTime.Now,
typeId = int.Parse(e.CommandArgument.ToString())
};
setting.updateTime = DateTime.Now;
setting.userId = UserID;
setting.userIsOpen = null;
if (e.CommandName == "open")
{
setting.sysIsOpen = true;
}
else if (e.CommandName == "close")
{
setting.sysIsOpen = false;
}
viviapi.BLL.Channel.ChannelTypeUsers.Add(setting);
LoadData();
}
/// <summary>
/// 两者同时为1才 为开启
/// </summary>
/// <param name="typeStatus">类型状态</param>
/// <param name="userId">用户ID</param>
/// <param name="chanelNo">通道</param>
/// <param name="typeId">通道类型ID</param>
/// <returns></returns>
public static int GetChanelSysStatus(int typeStatus, int userId, string chanelNo, int typeId, ref int suppid)
{
suppid = -1;
int result = 0;
int chanelValue = -1;
int sysSettingValue = -1;
ChannelInfo channelInfo = null;
if (!string.IsNullOrEmpty(chanelNo))
{
channelInfo = Channel.GetCacheModel(chanelNo);
}
ChannelTypeUserInfo typeUserConf = ChannelTypeUsers.GetCacheModel(userId, typeId);
if (channelInfo != null && channelInfo.isOpen.HasValue)
{
chanelValue = channelInfo.isOpen.Value;
}
if (typeUserConf != null)
{
if (typeUserConf.sysIsOpen.HasValue)
{
sysSettingValue = typeUserConf.sysIsOpen.Value ? 1 : 0;
}
if (typeUserConf.suppid.HasValue)
{
if (typeUserConf.suppid.Value > 0)
{
suppid = typeUserConf.suppid.Value;
}
}
}
//默认是关闭
if (typeStatus == 4)
{
if (chanelValue == -1)
{
chanelValue = 0;
}
if (sysSettingValue == -1)
{
sysSettingValue = 0;
}
}
//默认是开启
else if (typeStatus == 8)
{
if (chanelValue == -1)
{
chanelValue = 1;
}
if (sysSettingValue == -1)
{
sysSettingValue = 1;
}
}
//同时开启才开启
if (chanelValue == 1 && sysSettingValue == 1)
{
result = 1;
}
return(result);
}
private void LoadData()
{
DataTable data = viviapi.BLL.Channel.ChannelType.GetList(true).Tables[0];
//通道类别状态
if (!data.Columns.Contains("type_status"))
{
data.Columns.Add("type_status", typeof(string));
}
//系统设置
if (!data.Columns.Contains("sys_setting"))
{
data.Columns.Add("sys_setting", typeof(string));
}
//用户前台设置
if (!data.Columns.Contains("user_setting"))
{
data.Columns.Add("user_setting", typeof(string));
}
if (!data.Columns.Contains("payrate"))
{
data.Columns.Add("payrate", typeof(double));
}
if (!data.Columns.Contains("suppid"))
{
data.Columns.Add("suppid", typeof(int));
}
foreach (DataRow dr in data.Rows)
{
int typeId = int.Parse(dr["typeId"].ToString());
bool type_stutas = false;
bool?sys_setting = null;
bool?user_setting = null;
ChannelTypeUserInfo setting = ChannelTypeUsers.GetModel(CurrentUser.ID, typeId);
ChannelTypeInfo typeInfo = ChannelType.GetModelByTypeId(typeId);
switch (typeInfo.isOpen)
{
case OpenEnum.Close:
case OpenEnum.AllClose:
type_stutas = false;
break;
case OpenEnum.Open:
case OpenEnum.AllOpen:
type_stutas = true;
break;
}
dr["type_status"] = type_stutas ? "right" : "wrong";
dr["sys_setting"] = "Unknown";
dr["user_setting"] = "Unknown";
dr["suppid"] = 0;
if (setting != null)
{
if (setting.sysIsOpen.HasValue)
{
dr["sys_setting"] = setting.sysIsOpen.Value ? "right" : "wrong";
if (!setting.sysIsOpen.Value) //如果端口未开放
{
if (typeId == 101) //支付宝
{
class992 = hid;
}
else if (typeId == 100)//财付通
{
class993 = hid;
}
else if (typeId == 207)//微信支付
{
class1004 = hid;
}
else if (typeId == 300)//wap微信支付
{
class1007 = hid;
}
else if (typeId == 213)//qq支付
{
class51 = hid;
}
else if (typeId == 200)//Wap支付宝
{
class1008 = hid;
}
lit1.Text += "sysIsOpen" + typeId + ",";
}
}
if (setting.userIsOpen.HasValue)
{
dr["user_setting"] = setting.userIsOpen.Value ? "right" : "wrong";
if (!setting.userIsOpen.Value) //如果端口未开放
{
if (typeId == 101) //支付宝
{
class992 = hid;
}
else if (typeId == 100)//财付通
{
class993 = hid;
}
else if (typeId == 207)//微信支付
{
class1004 = hid;
}
else if (typeId == 300)//wap微信支付
{
class1007 = hid;
}
else if (typeId == 213)//qq支付
{
class51 = hid;
}
else if (typeId == 200)//Wap支付宝
{
class1008 = hid;
}
lit2.Text += "userIsOpen" + typeId + ",";
}
}
lit3.Text += "userIsOpenuserIsOpen" + typeId + ",";
if (setting.suppid.HasValue)
{
dr["suppid"] = setting.suppid.Value;
}
}
//dr["payrate"] = 100 * viviapi.BLL.Finance.PayRate.Instance.GetUserPayRate(this.UserID, Convert.ToInt32(dr["typeId"]));
}
//rpt_paymode.DataSource = data;
//rpt_paymode.DataBind();
}
/// <summary>
///
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static ChannelTypeUserInfo GetModelFromRow(DataRow dr)
{
ChannelTypeUserInfo model = new ChannelTypeUserInfo();
if (dr["id"].ToString() != "")
{
model.id = int.Parse(dr["id"].ToString());
}
if (dr["typeId"].ToString() != "")
{
model.typeId = int.Parse(dr["typeId"].ToString());
}
if (dr["userId"].ToString() != "")
{
model.userId = int.Parse(dr["userId"].ToString());
}
if (dr["userIsOpen"].ToString() != "")
{
if ((dr["userIsOpen"].ToString() == "1") || (dr["userIsOpen"].ToString().ToLower() == "true"))
{
model.userIsOpen = true;
}
else
{
model.userIsOpen = false;
}
}
else
{
model.userIsOpen = null;
}
if (dr["sysIsOpen"].ToString() != "")
{
if ((dr["sysIsOpen"].ToString() == "1") || (dr["sysIsOpen"].ToString().ToLower() == "true"))
{
model.sysIsOpen = true;
}
else
{
model.sysIsOpen = false;
}
}
else
{
model.sysIsOpen = null;
}
if (dr.Table.Columns.Contains("addTime") && dr["addTime"].ToString() != "")
{
model.addTime = DateTime.Parse(dr["addTime"].ToString());
}
if (dr.Table.Columns.Contains("updateTime") && dr["updateTime"].ToString() != "")
{
model.updateTime = DateTime.Parse(dr["updateTime"].ToString());
}
model.suppid = null;
if (dr["suppid"].ToString() != "")
{
model.suppid = int.Parse(dr["suppid"].ToString());
}
return(model);
}
void LoadData()
{
DataTable data = viviapi.BLL.Channel.ChannelType.GetCacheList();
if (!data.Columns.Contains("payrate"))
{
data.Columns.Add("payrate", typeof(double));
}
if (!data.Columns.Contains("plmodestatus"))
{
data.Columns.Add("plmodestatus", typeof(string));
}
if (!data.Columns.Contains("usermodestatus"))
{
data.Columns.Add("usermodestatus", typeof(string));
}
foreach (DataRow dr in data.Rows)
{
//if (dr["release"] != DBNull.Value && Convert.ToBoolean(dr["release"]) == false)
//{
// //data.Rows.Remove(dr);
// continue;
//}
int typeId = int.Parse(dr["typeId"].ToString());
bool isuserOpen = true;
bool issysOpen = false;
ChannelTypeUserInfo setting = ChannelTypeUsers.GetCacheModel(UserId, typeId);
if (setting != null)
{
if (setting.userIsOpen.HasValue)
{
isuserOpen = setting.userIsOpen.Value;
}
}
ChannelTypeInfo typeInfo = ChannelType.GetCacheModel(typeId);
switch (typeInfo.isOpen)
{
case OpenEnum.AllClose:
issysOpen = false;
break;
case OpenEnum.AllOpen:
issysOpen = true;
break;
case OpenEnum.Close:
issysOpen = false;
if (setting != null)
{
if (setting.sysIsOpen.HasValue)
{
issysOpen = setting.sysIsOpen.Value;
}
}
break;
case OpenEnum.Open:
issysOpen = true;
if (setting != null && setting.sysIsOpen.HasValue)
{
issysOpen = setting.sysIsOpen.Value;
}
break;
}
dr["payrate"] = 100 * viviapi.BLL.Finance.PayRate.Instance.GetUserPayRate(this.UserId, Convert.ToInt32(dr["typeId"]));
if (isuserOpen)
{
dr["usermodestatus"] = "right";
}
else
{
dr["usermodestatus"] = "wrong";
}
if (issysOpen)
{
dr["plmodestatus"] = "right";
}
else
{
dr["plmodestatus"] = "wrong";
}
}
rpt_paymode.DataSource = data;
rpt_paymode.DataBind();
}
public void ProcessRequest(HttpContext context)
{
string msg = string.Empty;
try
{
string userid = viviLib.Web.WebBase.GetFormString("userid", string.Empty);
if (!string.IsNullOrEmpty(userid))
{
int UserId = 0;
if (int.TryParse(userid, out UserId))
{
DataTable dtcardtypes = new DataTable();
dtcardtypes.Columns.Add("typeid", typeof(int));
dtcardtypes.Columns.Add("typename", typeof(string));
dtcardtypes.Columns.Add("facevalues", typeof(string));
DataTable data = viviapi.BLL.Channel.ChannelType.GetCacheList();
DataTable facevalue = viviapi.BLL.Channel.Channel.GetCardChanels(UserId, 0, 0, 1);
foreach (DataRow dr in data.Rows)
{
int typeId = int.Parse(dr["typeId"].ToString());
if (typeId < 103 || typeId == 300 || typeId == 114)
{
continue;
}
bool isuserOpen = true;
bool issysOpen = false;
//用户关闭
ChannelTypeUserInfo setting = viviapi.BLL.Channel.ChannelTypeUsers.GetCacheModel(UserId, typeId);
if (setting != null)
{
if (setting.userIsOpen.HasValue)
{
isuserOpen = setting.userIsOpen.Value;
if (!isuserOpen)
{
continue;
}
}
}
ChannelTypeInfo typeInfo = ChannelType.GetCacheModel(typeId);
switch (typeInfo.isOpen)
{
case OpenEnum.AllClose:
issysOpen = false;
break;
case OpenEnum.AllOpen:
issysOpen = true;
break;
case OpenEnum.Close:
issysOpen = false;
if (setting != null)
{
if (setting.sysIsOpen.HasValue)
{
issysOpen = setting.sysIsOpen.Value;
}
}
break;
case OpenEnum.Open:
issysOpen = true;
if (setting != null && setting.sysIsOpen.HasValue)
{
if (setting.sysIsOpen.HasValue)
{
issysOpen = setting.sysIsOpen.Value;
}
}
break;
}
if (!isuserOpen)
{
continue;
}
if (!issysOpen)
{
continue;
}
DataRow _dr = dtcardtypes.NewRow();
_dr["typeid"] = typeId;
_dr["typename"] = dr["modetypename"];
_dr["facevalues"] = GetFaceValues(facevalue, typeId);
dtcardtypes.Rows.Add(_dr);
}
msg = "success" + Newtonsoft.Json.JsonConvert.SerializeObject(dtcardtypes, Newtonsoft.Json.Formatting.Indented);
}
}
}
catch
{
}
context.Response.ContentType = "text/plain";
context.Response.Write(msg);
}
/// <summary>
///
/// </summary>
private void LoadData()
{
DataTable data = viviapi.BLL.Channel.ChannelType.GetList(true).Tables[0];
//通道类别状态
if (!data.Columns.Contains("type_status"))
{
data.Columns.Add("type_status", typeof(string));
}
//系统设置
if (!data.Columns.Contains("sys_setting"))
{
data.Columns.Add("sys_setting", typeof(string));
}
//用户前台设置
if (!data.Columns.Contains("user_setting"))
{
data.Columns.Add("user_setting", typeof(string));
}
if (!data.Columns.Contains("payrate"))
{
data.Columns.Add("payrate", typeof(double));
}
if (!data.Columns.Contains("suppid"))
{
data.Columns.Add("suppid", typeof(int));
}
foreach (DataRow dr in data.Rows)
{
int typeId = int.Parse(dr["typeId"].ToString());
bool type_stutas = false;
bool?sys_setting = null;
bool?user_setting = null;
ChannelTypeUserInfo setting = ChannelTypeUsers.GetModel(UserID, typeId);
ChannelTypeInfo typeInfo = ChannelType.GetModelByTypeId(typeId);
switch (typeInfo.isOpen)
{
case OpenEnum.Close:
case OpenEnum.AllClose:
type_stutas = false;
break;
case OpenEnum.Open:
case OpenEnum.AllOpen:
type_stutas = true;
break;
}
dr["type_status"] = type_stutas ? "right" : "wrong";
dr["sys_setting"] = "Unknown";
dr["user_setting"] = "Unknown";
dr["suppid"] = 0;
if (setting != null)
{
if (setting.sysIsOpen.HasValue)
{
dr["sys_setting"] = setting.sysIsOpen.Value ? "right" : "wrong";
}
if (setting.userIsOpen.HasValue)
{
dr["user_setting"] = setting.userIsOpen.Value ? "right" : "wrong";
}
if (setting.suppid.HasValue)
{
dr["suppid"] = setting.suppid.Value;
}
}
dr["payrate"] = 100 * viviapi.BLL.Finance.PayRate.Instance.GetUserPayRate(this.UserID, Convert.ToInt32(dr["typeId"]));
}
rpt_paymode.DataSource = data;
rpt_paymode.DataBind();
}
