/// <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);
}
}
}
