/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Users model) { var strSql = new StringBuilder(); strSql.Append("insert into T_Users("); strSql.Append("UserName,Pwd,Mobile,Email,Status,RegTime,RoleId,LastTime,NowTime,ReMark)"); strSql.Append(" values ("); strSql.Append("@UserName,@Pwd,@Mobile,@Email,@Status,@RegTime,@RoleId,@LastTime,@NowTime,@ReMark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Pwd", SqlDbType.NVarChar, 32), new SqlParameter("@Mobile", SqlDbType.NVarChar, 20), new SqlParameter("@Email", SqlDbType.NVarChar, 128), new SqlParameter("@Status", SqlDbType.TinyInt, 1), new SqlParameter("@RegTime", SqlDbType.DateTime), new SqlParameter("@RoleId", SqlDbType.Int, 4), new SqlParameter("@LastTime", SqlDbType.DateTime), new SqlParameter("@NowTime", SqlDbType.DateTime), new SqlParameter("@ReMark", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.UserName; parameters[1].Value = model.Pwd; parameters[2].Value = model.Mobile; parameters[3].Value = model.Email; parameters[4].Value = model.Status; parameters[5].Value = model.RegTime; parameters[6].Value = model.RoleId; parameters[7].Value = model.LastTime; parameters[8].Value = model.NowTime; parameters[9].Value = model.ReMark; var obj = DbHelperSql.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount(string strWhere) { var strSql = new StringBuilder(); strSql.Append("select count(1) FROM T_ESHour "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } var obj = DbHelperSql.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }