/// <summary> /// 增加一条数据 /// </summary> public int Add(MyPlatform.Model.Sys_Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Users("); strSql.Append("CreatedBy,CreatedDate,UpdatedBy,UpdatedDate,Deleted,Account,Password,UserName"); strSql.Append(") values ("); strSql.Append("@CreatedBy,@CreatedDate,@UpdatedBy,@UpdatedDate,@Deleted,@Account,@Password,@UserName"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CreatedBy", SqlDbType.NVarChar, 20), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@UpdatedBy", SqlDbType.NVarChar, 20), new SqlParameter("@UpdatedDate", SqlDbType.DateTime), new SqlParameter("@Deleted", SqlDbType.Int, 4), new SqlParameter("@Account", SqlDbType.VarChar, 18), new SqlParameter("@Password", SqlDbType.VarChar, 20), new SqlParameter("@UserName", SqlDbType.NVarChar, 20) }; parameters[0].Value = model.CreatedBy; parameters[1].Value = model.CreatedDate; parameters[2].Value = model.UpdatedBy; parameters[3].Value = model.UpdatedDate; parameters[4].Value = model.Deleted; parameters[5].Value = model.Account; parameters[6].Value = model.Password; parameters[7].Value = model.UserName; IDataBase db = new SqlServerDataBase(dbCon); return(db.ExecuteNonQuery(strSql.ToString(), parameters)); }
/// <summary> /// 登录验证账号密码 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Exists(MyPlatform.Model.Sys_Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from sys_users where deleted=0 and Account=@Account and password=@Password"); SqlParameter[] parameters = { new SqlParameter("@Account", SqlDbType.VarChar, 30), new SqlParameter("@Password", SqlDbType.VarChar, 30) }; parameters[0].Value = model.Account; parameters[1].Value = model.Password; IDataBase db = new SqlServerDataBase(dbCon); return(Convert.ToInt32(db.ExecuteScalar(strSql.ToString(), parameters)) == 0 ? false : true); }