/// <summary> /// 根据手机号,查找最后一次发送的验证码记录 /// </summary> public M_Safe_Mobile SelLastModel(string mobile, string source = "") { if (string.IsNullOrEmpty(mobile)) { return(null); } List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("mobile", mobile.Trim()), new SqlParameter("source", source) }; string where = "Phone=@mobile"; if (!string.IsNullOrEmpty(source)) { where += " AND Source=@source"; } using (DbDataReader reader = DBCenter.SelReturnReader(TbName, where, "ID DESC", sp)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public static M_AdminInfo AuthenticateAdmin(string AdminName, string Password) { if (string.IsNullOrEmpty(AdminName) || string.IsNullOrEmpty(Password)) { return(null); } M_AdminInfo adminMod = null; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("AdminName", AdminName), new SqlParameter("AdminPassword", StringHelper.MD5(Password)) }; using (DbDataReader reader = DBCenter.SelReturnReader(tbName, "AdminName=@AdminName AND AdminPassword=@AdminPassword", sp)) { if (reader.Read()) { adminMod = new M_AdminInfo().GetModelFromReader(reader); } else { return(null); } } //adminMod.LastLoginIP = IPScaner.GetUserIP(); adminMod.LastLoginTime = DateTime.Now; adminMod.LoginTimes++; Update(adminMod); return(adminMod); }
//----------------------用于运行 /// <summary> /// 获取路径,为空则取首页 /// </summary> public static M_Design_Page SelByPath(string path = "") { List <SqlParameter> sp = new List <SqlParameter>(); string where = "ZType=0 "; if (string.IsNullOrEmpty(path)) { where += " AND (Path='' OR Path='/index' OR Path='/')"; } else { path = "/" + (path.TrimStart('/').Replace(" ", "")); sp.Add(new SqlParameter("path", path)); where += " AND Path=@path"; } using (DbDataReader reader = DBCenter.SelReturnReader("ZL_Design_Page", where, "", sp)) { if (reader.Read()) { return(new M_Design_Page().GetModelFromReader(reader)); } else { return(null); } } }
/// <summary> /// 支持传入Guid或ProID的方式获取 /// </summary> public M_Shop_RegionPrice SelModelByGuid(string guid) { if (string.IsNullOrEmpty(guid)) { return(null); } string where = "Guid=@guid "; if (DataConvert.CLng(guid) > 0) { where += " OR ProID=" + guid; } List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("guid", guid) }; using (DbDataReader reader = DBCenter.SelReturnReader(TbName, where, "", sp)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
/// <summary> /// 根据父ID与商品ID,看有无匹配级更高的子项 /// </summary> public M_Shop_Bonus SelModelByProID(int pid, int proid) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "ParentID=" + pid + " AND ProID=" + proid)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_Shop_Bonus SelModelByDefault() { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "IsDefault=1")) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_ARoleAuth SelModelByRid(int Rid) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, " WHERE Rid=" + Rid)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_UserBaseField GetSelect(int ID) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, PK, ID)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_CRMS_Client SelModelByUid(int uid) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "FUserID=" + uid)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_Shop_MoneyRegular SelReturnModel(int ID) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, PK, ID)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_Mail_BookRead GetSelectById(int ID) { using (DbDataReader reader = DBCenter.SelReturnReader(strTableName, PK, ID)) { if (reader.Read()) { return(initmod.GetModelFromReader(reader)); } else { return(null); } } }
public M_User_Level SelModelByLevel(int level) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "OrderID", level)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_Order_Contact SelModelByOid(int oid) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "OrderID=" + oid, "ID DESC", null)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_IServer SelReturnModel(int id) { using (DbDataReader reader = DBCenter.SelReturnReader(strTableName, PK, id)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_Group SelReturnModel(int id) { using (DbDataReader reader = DBCenter.SelReturnReader(strTableName, PK, id)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(new M_Group(true)); } } }
public M_Guest_BarAuth SelModelByUid(int cateid, int uid) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "BarID=" + cateid + " And Uid=" + uid)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
private M_Design_Page SelModelByWhere(string tbname, string where, List <SqlParameter> sp) { using (DbDataReader reader = DBCenter.SelReturnReader(tbname, where, "", sp)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
private M_Arrive SelReturnModel(string strWhere, SqlParameter[] sp) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, strWhere, sp)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_User_StoreUser SelModelByUid(int uid, int sid) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "UserID=" + uid + " AND StoreId=" + sid)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
private M_MailTemp SelReturnModel(string strWhere) { using (DbDataReader reader = DBCenter.SelReturnReader(strTableName, strWhere)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_Node SelModelByWhere(string where, SqlParameter[] sp) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, where, sp)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(new M_Node(true)); } } }
public M_Shop_DeliveryMan SelModelByUid(int uid, int storeid) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "UserID=" + uid + " AND StoreID=" + storeid)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_AskCommon SelReturnModel(int ID) { using (DbDataReader reader = DBCenter.SelReturnReader(strTableName, PK, ID)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
/// <summary> /// 获取用户最后一条签到记录 /// </summary> /// <param name="mu"></param> /// <returns></returns> public M_Plat_Sign GetLastModel(M_UserInfo mu) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "UserID = " + mu.UserID, "CDate DESC")) { if (reader.Read())//结果按时间倒序排列,取的是最后一条数据 { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_Order_Invoice SelModelByOid(int oid) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "OrderID", oid)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
//public M_Pub GetSelectNode(string nodeid) //{ // SqlParameter[] cmdParams = new SqlParameter[1]; // cmdParams[0] = new SqlParameter("@nodeid", SqlDbType.NVarChar, 255); // cmdParams[0].Value = nodeid; // string sql = "select * from ZL_pub where pubnodeid like '%,'+@nodeid+',%' or pubnodeid like @nodeid+',%' or pubnodeid like '%,'+@nodeid or pubnodeid=@nodeid"; // using (DbDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, cmdParams)) // { // if (reader.Read()) // { // return new M_Pub().GetModelFromReader(reader); // } // else // { // return new M_Pub(); // } // } //} /// <summary> /// 根据模型id查询 /// </summary> public M_Pub GetPubModel(int Model) { using (DbDataReader reader = DBCenter.SelReturnReader("ZL_Pub", "PubModelID=" + Model, "ID DESC")) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(new M_Pub()); } } }
public M_GuestBook SelReturnModel(int GID) { using (DbDataReader reader = DBCenter.SelReturnReader(strTableName, "GID", GID)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(new M_GuestBook(true)); } } }
/// <summary> /// 该用户在指定问题下的回答 /// </summary> public M_GuestAnswer SelModelByAsk(int askId, int uid) { using (DbDataReader reader = DBCenter.SelReturnReader(strTableName, "QueId=" + askId + " AND UserId=" + uid, "ID DESC", null)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_Message_SMS SelReturnModel(int ID) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, PK, ID)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }
public M_Plat_Comp SelModelByCUser(int uid) { using (DbDataReader reader = DBCenter.SelReturnReader(TbName, "CreateUser", uid)) { if (reader.Read()) { return(initMod.GetModelFromReader(reader)); } else { return(null); } } }