//-------------
public void Sync(M_Order_Invoice invMod)
{
if (invMod.UserID < 1 || string.IsNullOrEmpty(invMod.InvHead))
{
return;
}
//数量超过5则不处理
int count = DBCenter.Count(TbName, "UserID=" + invMod.UserID);
if (count >= MaxCount)
{
return;
}
//head已存在则不处理(不更新)
invMod.InvHead = invMod.InvHead.Replace(" ", "");
bool exist = DBCenter.IsExist(TbName, "InvHead=@head AND UserID=" + invMod.UserID,
new List <SqlParameter>()
{
new SqlParameter("head", invMod.InvHead)
});
if (exist)
{
return;
}
//同步写入
Insert(invMod);
}
//----------------权限检测
/// <summary>
/// 检测是否有访问用户中心的权限
/// 店长,收银员
/// </summary>
public static CommonReturn CheckUserLogin()
{
M_UserInfo mu = new B_User().GetLogin();
if (mu.IsNull)
{
return(CommonReturn.Failed("用户未登录"));
}
//检测用户是否拥有店铺,或为店铺收银员
if (mu.SiteID < 1)
{
return(CommonReturn.Failed("用户未绑定店铺"));
}
if (DBCenter.IsExist("ZL_CommonModel", "SuccessfulUserID=" + mu.UserID))
{
return(CommonReturn.Success());
}
//是否绑定了店铺,是否为收银员
if (mu.GroupID != ExConast.EmployGroup)
{
return(CommonReturn.Failed("没有访问页面的权限"));
}
return(CommonReturn.Success());
}
//---------------
public bool Add(M_User_Follow model, ref string err)
{
bool flag = false;
if (model.UserID < 1)
{
err = "用户未登录";
}
else if (model.TUserID < 1)
{
err = "被关注人不能为空";
}
else if (model.UserID == model.TUserID)
{
err = "关注人与被关注人不能是同用户";
}
else if (!new B_User().IsExist("uid", model.TUserID.ToString()))
{
err = "被关注用户不存在";
}
else if (DBCenter.IsExist(TbName, "UserID=" + model.UserID + " AND TUserID=" + model.TUserID))
{
err = "关注信息已存在";
}
else
{
Insert(model); flag = true;
}
return(flag);
}
//--------------------------
public bool Exist(int luckid, int uid)
{
if (luckid < 1 || uid < 1)
{
return(true);
}
return(DBCenter.IsExist(TbName, "UserID=" + uid + " AND LuckID=" + luckid));
}
public int Insert(M_User_BindPro model)
{
if (DBCenter.IsExist(TbName, "UserID=" + model.UserID))
{
return(0);
}
return(DBCenter.Insert(model));
}
public bool IsExist(string key)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter("key", key)
};
return(DBCenter.IsExist(strTableName, " KeyName=@key", sp));
}
public bool IsExist(string KeyName)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter("key", KeyName)
};
return(DBCenter.IsExist(TbName, "KeyWordText=@key", sp));
}
/// <summary>
/// 组织名是否存在
/// </summary>
public bool IsExist(string strName)
{
strName = strName.Trim();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter("Name", strName)
};
return(DBCenter.IsExist(TbName, "Name=@name", sp));
}
public int Insert(M_User_BindPro model)
{
//不允许重复,自动读取值
if (DBCenter.IsExist(TbName, "UserID=" + model.UserID))
{
M_User_BindPro existMod = SelModelByUid(model.UserID);
model.ID = existMod.ID;
UpdateByID(model);
return(model.ID);
}
return(DBCenter.Insert(model));
}
/// <summary>
/// 内容商城模型不允许重名
/// </summary>
public bool IsExistModelName(string modelName)
{
if (string.IsNullOrEmpty(modelName))
{
return(false);
}
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter("name", modelName)
};
return(DBCenter.IsExist(TbName, "ModelName=@name AND ModelType NOT IN (3,8,7,6,12)", sp));
}
public bool IsExist(string name, int id = 0)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter("name", name.Trim())
};
string where = "PageName =@name";
if (id != 0)
{
where += " AND ID!=" + id;
}
return(DBCenter.IsExist(TbName, where, sp));
}
public int Insert(M_WX_User model)
{
if (string.IsNullOrEmpty(model.OpenID))
{
throw new Exception("微信用户的OpenID不能为空");
}
if (DBCenter.IsExist(TbName, "OpenID=@openid", new List <SqlParameter>()
{
new SqlParameter("openid", model.OpenID)
}))
{
return(0);
}
return(DBCenter.Insert(model));
}
public int Insert(M_WX_User model)
{
if (string.IsNullOrEmpty(model.OpenID))
{
throw new Exception("微信用户的OpenID不能为空");
}
if (DBCenter.IsExist(TbName, "OpenID=@openid", new List <SqlParameter>()
{
new SqlParameter("openid", model.OpenID)
}))
{
throw new Exception("该OpenID已存在,不可重复加入");
}
return(Sql.insertID(TbName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
/// <summary>
/// 修改模型数据
/// </summary>
public void UpdateContent(DataTable ContentDT, string tbname, int itemid)
{
//需要重处理
if (ContentDT != null && ContentDT.Rows.Count > 0)
{
List <SqlParameter> splist = new List <SqlParameter>();
splist.AddRange(BLLCommon.GetParameters(ContentDT));
if (DBCenter.IsExist(tbname, "ID=" + itemid))
{
DBCenter.UpdateSQL(tbname, BLLCommon.GetFieldAndPara(ContentDT), "ID=" + itemid, splist);
}
else
{
DBCenter.Insert(tbname, BLLCommon.GetFields(ContentDT), BLLCommon.GetParas(ContentDT), splist.ToArray());
}
}
}
public static M_Ex_ERole GetERole(M_UserInfo mu)
{
M_Ex_ERole roleMod = new M_Ex_ERole();
//检测是否为店长
if (DBCenter.IsExist("ZL_CommonModel", "SuccessfulUserID=" + mu.UserID))
{
roleMod.RoleName = "店长";
return(roleMod);
}
if (mu.PageID < 1)
{
roleMod.RoleName = "未分配"; return(roleMod);
}
roleMod = new B_Ex_ERole().SelReturnModel(mu.PageID);
if (roleMod == null)
{
roleMod = new M_Ex_ERole(); roleMod.RoleName = "不存在"; return(roleMod);
}
return(roleMod);
}
protected void Page_Init(object sender, EventArgs e)
{
WxAPI.AutoSync(Request.Url.AbsoluteUri);
int sid = DataConvert.CLng(Request.QueryString["ID"]);
if (sid > 1)
{
Response.Cookies["sid"].Value = sid.ToString();
}
else if (Request.Cookies["sid"] != null)//看Cookie中是否有信息
{
sid = DataConvert.CLng(Request.Cookies["sid"].Value);
}
if (sid < 1)
{
function.WriteErrMsg("未指定店铺ID"); return;
}
if (!DBCenter.IsExist("ZL_CommonModel", "GeneralID=" + sid + " AND ModelID=24"))
{
function.WriteErrMsg("指定店铺的信息不存在");
}
}
/// <summary>
/// 校验当前登录用户的角色权限
/// </summary>
/// <param name="name"></param>
public static CommonReturn CheckUserAuth(string auth)
{
M_UserInfo mu = new B_User().GetLogin();
if (mu.SiteID < 1)
{
function.WriteErrMsg("禁止访问,用户未绑定店铺");
}
//如果是店铺的所有者,则不需要检测
bool flag = DBCenter.IsExist("ZL_CommonModel", "GeneralID=" + mu.SiteID + " AND SuccessfulUserID=" + mu.UserID);
if (flag)
{
return(CommonReturn.Success());
}
//只有店长可访问该页面
if (auth.Equals("manage"))
{
function.WriteErrMsg("你没有足够的访问权限");
}
//-----------------------检测角色权限
if (mu.PageID < 1)
{
function.WriteErrMsg("操作员未绑定角色");
}
if (string.IsNullOrEmpty(auth))
{
function.WriteErrMsg("未指定需要校验的权限");
}
string auths = DataConvert.CStr(DBCenter.ExecuteScala("ZL_Ex_ERole", "RoleAuth", "ID=" + mu.PageID));
if (!auths.Contains(auth))
{
function.WriteErrMsg("你无权访问该页面");
}
return(CommonReturn.Success());
}
public bool Update(DataTable ContentDT, M_Product model)
{
int ItemID = model.ItemID;
if (ContentDT != null && ContentDT.Rows.Count > 0)
{
if (string.IsNullOrEmpty(model.TableName))
{
throw new Exception("商品附表为空");
}
List <SqlParameter> splist = new List <SqlParameter>();
splist.AddRange(BLLCommon.GetParameters(ContentDT));
if (DBCenter.IsExist(model.TableName, "ID=" + ItemID))
{
DBCenter.UpdateSQL(model.TableName, BLLCommon.GetFieldAndPara(ContentDT), "ID=" + ItemID, splist);
}
else
{
DBCenter.Insert(model.TableName, BLLCommon.GetFields(ContentDT), BLLCommon.GetParas(ContentDT), splist.ToArray());
}
}
UpdateByID(model);
return(true);
}
/// <summary>
/// 是否已存在未确认的好友申请,True已存在
/// </summary>
public bool IsExist(int suid, int tuid)
{
string where = "UserID=" + suid + " AND TUserID=" + tuid + " AND ZStatus=" + (int)ConStatus.UnAudit;
return(DBCenter.IsExist(TbName, where));
}
//--------------------
public bool IsExist(double money)
{
//同种金额的不能重复添加
return(DBCenter.IsExist(TbName, "Min='" + money + "'"));
}
//-------------------Tools
public bool IsSeat(int uid)
{
return(DBCenter.IsExist(strTableName, "S_AdminID=" + uid));
}
public string Register_API()
{
M_APIResult retMod = new M_APIResult(M_APIResult.Success);
string action = GetParam("action");
string value = GetParam("value").Replace(" ", "");
string result = "";
switch (action)
{
case "uname":
if (!CheckUserName(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
case "mobile": //手机号不可重复
{
string mobile = GetParam("mobile");
if (string.IsNullOrEmpty(mobile))
{
retMod.retmsg = "手机号码不能为空";
}
else if (!RegexHelper.IsMobilPhone(mobile))
{
retMod.retmsg = "手机号码格式不正确";
}
else
{
bool flag = DBCenter.IsExist("ZL_UserBase", "Mobile=@mobile",
new List <SqlParameter>()
{
new SqlParameter("mobile", mobile)
});
if (flag)
{
retMod.retmsg = "手机号码已存在";
}
else
{
retMod.retcode = M_APIResult.Success;
}
}
}
break;
case "puser": //推荐人为空则不检测
if (!string.IsNullOrEmpty(value) && CheckParentUser(value).IsNull)
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = "推荐人不存在";
}
break;
case "email":
if (!CheckEmail(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
case "birth":
if (!CheckBirthDay(value, ref result))
{
retMod.retcode = M_APIResult.Failed;
retMod.retmsg = result;
}
break;
case "GetModelFied":
return(GetUserGorupModel(value));
default:
retMod.retmsg = "[" + action + "]接口不存在";
break;
}
return(retMod.ToString());
}
public bool IsExistTemplate(int NodeID, int ModelID)
{
return(DBCenter.IsExist("ZL_Node_ModelTemplate", "NodeID=" + NodeID + " AND ModelID=" + ModelID));
}
/// <summary>
/// 查看用户是否已对流程审批，是则返回true
/// </summary>
public bool CheckApproval(int userid, int stepnum, int appid)
{
string where = "Appid=" + appid + " AND ApproveID=" + userid + " AND ProLevel=" + stepnum;
return(DBCenter.IsExist(TbName, where));
}
/// <summary>
/// 双方是否为有效的好友,True:是,
/// </summary>
public bool IsFriend(int uid, int tuid)
{
string where = GetWhere(uid, tuid) + " AND ZStatus=" + (int)ConStatus.Audited;
return(DBCenter.IsExist(TbName, where));
}
public bool SelByIP(string IP)
{
return(DBCenter.IsExist(TbName, "IP=" + IP));
}
public bool Has(int suid, int tuid)
{
string where = "UserID=" + suid + " AND TUserID=" + tuid;
return(DBCenter.IsExist(TbName, where));
}
public bool IsExistModel(int GroupID, int ModelID)
{
return(DBCenter.IsExist("ZL_GroupModel", " GroupID=" + GroupID + " and UserModel=" + ModelID));
}
/// <summary>
/// 是否已有会员组，没有会员组时新增的第一个会员组自动成默认会员组
/// </summary>
public bool HasGroup()
{
return(DBCenter.IsExist(strTableName, ""));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Pid <= 0)
{
function.WriteErrMsg("参数错误!不存在此信息!");
}
M_Pub mpub = pubBll.GetSelect(Pid);
mu = buser.GetLogin();
if (mpub == null || mpub.Pubid < 1)
{
function.WriteErrMsg("互动信息不存在");
}
M_APIResult retMod = new M_APIResult();
int spid = DataConvert.CLng(Request.Form["spfbrid"]);
if (mu.UserID < 1)
{
retMod.retmsg = "未登录不可提交订单"; RepToClient(retMod.ToString()); return;
}
if (spid < 1)
{
retMod.retmsg = "未指定教师信息"; RepToClient(retMod.ToString()); return;
}
{
//如果存在与该老师的进行中订单,则忽略
string where = "xsrid=" + mu.UserID + " AND spfbrid=" + spid;
where += " AND status_order>=0 AND status_order<100";
if (DBCenter.IsExist("ZL_Pub_dsmx", where))
{
retMod.retmsg = "已存在生效中的订单";
RepToClient(retMod.ToString());
return;
}
}
M_UserInfo spmu = buser.SelReturnModel(spid);
if (spmu.IsNull)
{
retMod.retmsg = "老师信息不存在"; RepToClient(retMod.ToString()); return;
}
//-----------------------获取用户提交的数据
//隐藏字段值
int PubContentid = DataConverter.CLng(Request.Form["PubContentid"]);
int Parentid = DataConvert.CLng(Request.Form["Parentid"]);
//用户提交
string pbtitle = Server.HtmlEncode(DataConvert.CStr(Request.Form["PubTitle"]));
string pbcontent = Server.HtmlEncode(DataConvert.CStr(Request.Form["PubContent"]));
if (!pbtitle.Contains("的"))//xxx的课程
{
pbtitle = B_User.GetUserName(spmu.HoneyName, spmu.UserName) + "的课程";
}
//-----------------------可提交判断
List <SqlParameter> sp = new List <SqlParameter>();
//-----------------------初始化参数
//删除超过保留期限的值
//pubBll.DeleteModel(mpub.PubTableName, "DateDiff(d,PubAddTime,getdate())>" + mpub.Pubkeep);
//ModelField表中仅存了自定义的字段
B_CodeModel codeBll = new B_CodeModel(mpub.PubTableName);
DataRow dr = codeBll.NewModel();
DataTable mfDT = mfBll.DB_SelByModel(mpub.PubModelID);
mfDT.DefaultView.RowFilter = "sys_type=0";
mfDT = mfDT.DefaultView.ToTable();
//-----固定的系统字段
dr["Pubnum"] = 1;
dr["PubIP"] = EnviorHelper.GetUserIP();
dr["PubUserID"] = mu.UserID;
dr["PubUserName"] = mu.UserName;
dr["Pubupid"] = mpub.Pubid;
dr["PubAddTime"] = DateTime.Now;
dr["Parentid"] = Parentid;
dr["PubTitle"] = pbtitle;
dr["PubContent"] = pbcontent;
dr["Pubstart"] = mpub.PubIsTrue == 1 ? 0 : 1;//取反
dr["PubInputer"] = B_User.GetUserName(mu.HoneyName, mu.UserName);
dr["PubContentid"] = PubContentid;
//dr["cookflag"] = CookFlag;
//=========订单初始化
dr["status_order"] = 0;
dr["status_user"] = 0;
dr["status_teacher"] = 0;
dr["status_money"] = 0;
dr["edate"] = "";
dr["fcAmount"] = 0;
dr["fcDate"] = "";
//int djid = DataConvert.CLng(mu.ParentUserID);
//if (djid < 1) { djid = DataConvert.CLng(Request["djid"]); }
dr["djid"] = DataConvert.CLng(Request["djid"]);
//------非系统字段
for (int i = 0; i < mfDT.Rows.Count; i++)
{
M_ModelField mfMod = new M_ModelField().GetModelFromReader(mfDT.Rows[i]);
string value = Server.HtmlEncode(Request.Form[mfMod.FieldName] ?? "");
Parentid = DataConvert.CLng(Request.Form["Parentid"]);
if (mfMod.IsNotNull && string.IsNullOrEmpty(value))
{
RepToClient(mfMod.FieldName + "不能为空");
}
dr[mfMod.FieldName] = value;
switch (mpub.PubType)
{
#region 根据互动类型,进行空值判断
case 0:
if (string.IsNullOrEmpty(pbcontent))
{
RepToClient("评论内容不能为空!");
}
break;
case 1:
if (string.IsNullOrEmpty(pbtitle))
{
RepToClient("标题不能为空!");
}
break;
case 2:
if (string.IsNullOrEmpty(pbtitle))
{
RepToClient("标题不能为空!");
}
if (string.IsNullOrEmpty(pbcontent))
{
RepToClient("活动信息不能为空!");
}
break;
case 3:
if (string.IsNullOrEmpty(pbtitle) || string.IsNullOrEmpty(pbcontent))
{
RepToClient("标题与内容不能为空!");
}
break;
case 4:
if (string.IsNullOrEmpty(pbtitle))
{
RepToClient("标题不能为空!");
}
break;
case 5:
break;
case 7: //将评星控件的数据写入数据表中
dr["PubContent"] = Request.Params["scoreVal"];
break;
case 8: //互动表单
break;
#endregion
}
}
codeBll.Insert(dr);
retMod.retcode = M_APIResult.Success;
RepToClient(retMod.ToString());
//Upaddnums(mpub); //更新总参与人数
}
