public static int InsertModel(DeviceModelEntity entity) { using (var conn = new SqlConnection(ConnStr)) { conn.Open(); var sql = @" INSERT INTO Configuration.dbo.tbl_DeviceModel ( TypeID , DeviceModel , CreateDateTime , UpdateDateTime , CreateUser, UpdateUser ) VALUES ( @TypeID , -- TypeID - int @DeviceModel , -- DeviceModel - nvarchar(30) GETDATE() , -- CreateDateTime - datetime GETDATE() , @CreateUser, @UpdateUser ); Select SCOPE_IDENTITY(); "; var sqlParam = new SqlParameter[] { new SqlParameter("@TypeID", entity.TypeId), new SqlParameter("@DeviceModel", entity.DeviceModel), new SqlParameter("@CreateUser", entity.CreateUser), new SqlParameter("@UpdateUser", entity.UpdateUser), }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlParam))); } }
public static bool UpdateModel(DeviceModelEntity entity) { using (var con = new SqlConnection(ConnStr)) { var sql = @" UPDATE Configuration.dbo.tbl_DeviceModel SET TypeID =@typeId ,DeviceModel = @deviceModel ,UpdateDateTime = GETDATE(), UpdateUser = @UpdateUser WHERE PKID = @Pkid "; var sqlParam = new SqlParameter[] { new SqlParameter("@typeId", entity.TypeId), new SqlParameter("@deviceModel", entity.DeviceModel), new SqlParameter("@UpdateUser", entity.UpdateUser), new SqlParameter("@Pkid", entity.PKID), }; return(SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql, sqlParam) > 0); } }